addupdateemp.java

好的超市管理系统 下来看看啊 请大家多提意见啊！~

package SuperMarket;

import java.sql.ResultSet;
import java.util.Vector;

import javabean.OracleBean;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class AddUpdateEmp extends HttpServlet{
	public void doPost(HttpServletRequest req,HttpServletResponse res){
		try {
			
			 req.setCharacterEncoding("GBK");
			 int emp_id = Integer.parseInt(req.getParameter("emp_id"));
			 System.out.println("emp_id");
			 String password = req.getParameter("password");
			 String ename = req.getParameter("ename");
			 String job = req.getParameter("job");
			 String firedate=req.getParameter("year")+"-"+req.getParameter("month")+"-"+req.getParameter("day");
			 double sal = Double.parseDouble(req.getParameter("sal"));
			 double comm = Double.parseDouble(req.getParameter("comm"));
			 int deptno = Integer.parseInt(req.getParameter("deptno"));
			 int emp_tel = Integer.parseInt(req.getParameter("emp_tel"));
			 String emp_add = req.getParameter("emp_add");
			 
			 String sql = "INSERT INTO  emptable VALUES("+emp_id+",'"+password+"',"+"'"+ename+"','"+job+"',to_date('"+firedate+"','YYYY-MM-DD'),"+sal+","+comm+","+deptno+","+emp_tel+",'"+emp_add+"')";
			 
			 System.out.println(sql);
			 
			 OracleBean ob = new OracleBean();
			 
			 ob.update(sql);
			 
			 getServletConfig().getServletContext().getRequestDispatcher(
						"/AdminEmpa").forward(req, res);
			 
			// getServletConfig().getServletContext().getRequestDispatcher("/emp_admin.jsp").forward(req, res);
		}catch(Exception e){
			e.printStackTrace();
		}
		
	}
	
}