?? submitorder.java
字號:
package bookshop.bean;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import bookshop.bean.DataBase;
import bookshop.bean.shopcar;
public class SubmitOrder extends HttpServlet{
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
HttpSession session=request.getSession();
String ToJSP="/bookshop/myCar.jsp";
if(session.getAttribute("aa")==null){
ToJSP="/bookshop/login.jsp";
}else{
String user=(String)session.getAttribute("aa");
Vector list=(Vector)session.getAttribute("carList");
int key=0;
String id="";
String date="";
String totalMoney=request.getParameter("money");
GregorianCalendar d=new GregorianCalendar();
date=Integer.toString(d.get(Calendar.YEAR))+"_"
+Integer.toString(d.get(Calendar.MONTH)+1)+"_"
+Integer.toString(d.get(Calendar.DAY_OF_MONTH));
int n=list.size();
String sql="select id from userorder";
DataBase db=new DataBase();
db.connect();
ResultSet rs=db.executeQuery(sql);
try{
while(rs.next()){
key=Integer.parseInt(rs.getString("id"));
key++;
}
id=Integer.toString(key);
String command="insert into userorder values("
+"\'"+id+"\'"+","
+"\'"+user+"\'"+","
+"\'"+date+"\'"+","
+"\'"+totalMoney+"\'"+")";
db.executeUpdate(command);
for(int i=0;i<n;i++){
shopcar car=(shopcar)list.elementAt(i);
sql="select b_price from b_book where b_no="+"\'"+car.getBookNo()+"\'";
rs=db.executeQuery(sql);
rs.next();
float money=car.getquanlity()*Float.parseFloat(rs.getString("price"));
command="insert into orderlist values("
+"\'"+id+"\'"+","
+"\'"+user+"\'"+","
+"\'"+car.getBookNo()+"\'"+","
+"\'"+Integer.toString(car.getquanlity())
+"\'"+","
+"\'"+Float.toString(money)+"\')";
db.executeUpdate(command);
}
db.closeConnection();
}
catch(Exception e){
}
session.removeAttribute("carList");
}
response.sendRedirect(ToJSP);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
doGet(request,response);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -