makenewbill.java

还是超市系统

/**@(#)MakeNewBill.java*/
package test.expense;

import java.io.IOException;
import java.sql.*;

import javax.servlet.*;
import javax.servlet.http.*;

/**生成新的table_bill记录
 * @version 0.1
 * @author kyle
 * @date 20060803 am 10:20
 */
public class MakeNewBill extends HttpServlet {

	Connection conn;
	
	int deptId ;
	int venderId;
	int billId;
	int goodId;
	int goodAmount;
	
	public MakeNewBill(){
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:SMarket","scott","tiger");
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
    public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
    	HttpSession session = req.getSession();
    	
    	//---------------------------
    	Statement ttms;
    	ResultSet ss;
    	
    	try{
    		ttms = conn.createStatement();
    		ss = ttms.executeQuery("SELECT max(bill_id) as id FROM table_bill");
    		
    		if(ss.next()){
    			
    			billId = ss.getInt("id")+1;
    		}
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	
        //---------------------------
    	Statement stmt;
    	ResultSet rs;
    	
    	try{
    		
    		stmt = conn.createStatement();
    		rs = stmt.executeQuery("SELECT dept_id FROM table_dept WHERE dept_name='"+(String)(session.getAttribute("deptName"))+"'");
    		if(rs.next()){
    			
    			deptId = rs.getInt("dept_id");
    		}
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	
    	//----------------------------
    	Statement tmts;
    	ResultSet sr;
    	try{
    		tmts = conn.createStatement();
    		sr = tmts.executeQuery("SELECT vender_id FROM table_vender WHERE vender_name='"+(String)(session.getAttribute("venderName"))+"'");
    		if(sr.next()){
    			
    			venderId = sr.getInt("vender_id");
    		}
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	//----------------------------
    	goodId = Integer.parseInt(req.getParameter("goodId"));
    	goodAmount = Integer.parseInt(req.getParameter("goodAmount"));
    	
    	try{
    		Statement mm = conn.createStatement();
    		mm.executeUpdate("INSERT INTO table_bill VALUES("+billId+","+goodId+","+goodAmount+",to_date('"+req.getParameter("date")+"','YYYY-MM-DD'),"+deptId+","+venderId+",to_date('"+req.getParameter("billDueDay")+"','YYYY-MM-DD'))");
    		System.out.println("INSERT INTO table_bill VALUES("+billId+","+goodId+","+goodAmount+",to_date('"+req.getParameter("date")+"','YYYY-MM-DD'),"+deptId+","+venderId+",to_date('"+req.getParameter("billDueDay")+"','YYYY-MM-DD'))");
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	/*
    	try{
    		PreparedStatement pstmt = conn.prepareStatement("INSERT INTO table_bill VALUES(?,?,?,?,?,?,?)");
    		pstmt.setInt(1,billId);
    		pstmt.setInt(2,goodId);
    		pstmt.setInt(3,goodAmount);
    		pstmt.setDate(4,new java.sql.Date(new java.util.Date(req.getParameter("date")).getTime()));
    		pstmt.setInt(5,deptId);
    		pstmt.setInt(6,venderId);
    		pstmt.setDate(7,new java.sql.Date(new java.util.Date(req.getParameter("billDueDay")).getTime()));
    		
    		pstmt.executeUpdate();
    		
    		pstmt.close();
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    	*/
    	finally{
    		
    		try{
    			if(conn!=null){
    				//conn.close();
    			}
    		}catch(Exception e){
    			e.printStackTrace();
    		}
    	}
    	
    	getServletConfig().getServletContext().getRequestDispatcher("/pages/newok.html").forward(req,res);
    }
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		doGet(req,res);
	}
}