countbill.java

还是超市系统

package countbill;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import db.ConnOracle;

public class Countbill extends HttpServlet{
	
	public void doGet(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			
			db.ConnOracle conn = new db.ConnOracle();
			ResultSet rs = null;
			HttpSession session = req.getSession();
			session.getAttribute("counts");
			String good_id = req.getParameter("id");
			int id = Integer.parseInt("good_id");
			session.getAttribute("dept_id");
			ResultSet rs = (ResultSet)session.getAttribute("rs");
			rs.next();
			
			try{
				
				String sql = "insert into table_bill values("+(rs.getInt("bill_id")+1)+","+id+","+session.getAttribute("counts")+","++")"
			}catch(Exception e){
				e.printStackTrace();
			}
		}
}