?? save.java
字號:
/*
* Created on 2004-9-25
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package com.em;
import oa.sys.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
****************************************************
*類名稱: Save<br>
*類功能: 保存員工信息<br>
*創建: 白偉明 2004年9月27日<br>
****************************************************
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class Save extends HttpServlet{
private Statement stmt=null;
private String name,birthday,learn,post,tel,addr,sex,sql;
private RequestDispatcher dispatcher=null;
private HttpSession session=null;
private int deid,jobid,stateid,temp,id;
private PrintWriter out=null;
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
request.setCharacterEncoding("gb2312");
response.setContentType("text/html; charset=gb2312");
out=response.getWriter();
session=request.getSession();
//獲取數據
name=(String)request.getParameter("name");
sex=(String)request.getParameter("sex");
birthday=(String)request.getParameter("birthday");
learn=(String)request.getParameter("learn");
post=(String)request.getParameter("post");
tel=(String)request.getParameter("tel");
addr=(String)request.getParameter("addr");
try{
id=Integer.parseInt(request.getParameter("id"));
}catch(Exception e){
id=0;
}
try{
deid=Integer.parseInt((String)request.getParameter("depid"));
}catch(Exception e){
}
try{
jobid=Integer.parseInt((String)request.getParameter("jobid"));
}catch(Exception e){
}
try{
stateid=Integer.parseInt((String)request.getParameter("emsid"));
}catch(Exception e){
}
Db db=new Db();
Str str=new Str();
//字符轉換
name=str.inStr(name);
sex=str.inStr(sex);
birthday=str.inStr(birthday);
learn=str.inStr(learn);
post=str.inStr(post);
tel=str.inStr(tel);
addr=str.inStr(addr);
if(id!=0){
sql="UPDATE eminfo SET name='"+name+"',sex='"+sex+"',birthday='"+birthday+"',learn='"
+learn+"',post='"+post+"',departmentid="+deid+",jobid="+jobid+",tel='"+tel+"',addr='"
+addr+"',stateid="+stateid+" WHERE employeeid="+id;
}else{
sql="INSERT INTO eminfo(name,sex,birthday,learn,post,departmentid,jobid,tel,addr,stateid)"
+"VALUES('"+name+"','"+sex+"','"+birthday+"','"+learn+"','"+post+"',"+deid+","+jobid+",'"
+tel+"','"+addr+"',"+stateid+")";
}
try{
stmt=db.getStmt();
temp=stmt.executeUpdate(sql);
if(temp>0){
request.setAttribute("msg","操作成功");
}else{
request.setAttribute("msg","操作失敗");
}
}catch(Exception e){
request.setAttribute("msg","操作失敗,請先添加部門、職位和員工狀態等信息");
e.printStackTrace();
}finally{
db.close();
if(id!=0){
dispatcher=request.getRequestDispatcher("add?id="+id);
}else{
dispatcher=request.getRequestDispatcher("add.jsp");
}
dispatcher.forward(request,response);
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
doPost(request,response);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -