checkbillid.java

还是超市系统

package checkbillid;

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

public class Checkbillid extends HttpServlet{
	 
	 public void doGet(HttpServletRequest req,HttpServletResponse res)
	 	throws ServletException,IOException{
	 		
	 		db.ConnOracle conn = new db.ConnOracle();
	 		ResultSet rs = null;
	 		
	 		try{
	 			String sql = "select max(bill_id) from table_bill";
	 			rs = conn.query(sql);
	 			
	 			req.setAttribute("rs",rs);
	 		}catch(Exception e){
	 			e.printStackTrace();
	 		}
	 		getServletConfig().getServletContext().getRequestDispatcher("/pages/Countbill.java").forward(req,res);
	 	}
	 
	 public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
}