?? set.java
字號:
/*
* Created on 2004-9-22
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package com.sys;
import oa.sys.*;
import oa.sys.Time;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
****************************************************
*類名稱: Set<br>
*類功能: 設置員工密碼<br>
*創建: 白偉明 2004年9月28日<br>
****************************************************
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class Set extends HttpServlet{
private Db db=null;
private Str str=null;
private Time time=null;
private int temp,id;
private String password,sqlu,sqli,sqlsp,sqlse;
private HttpSession session=null;
private PrintWriter out=null;
private ResultSet rs=null;
private Statement stmt=null;
private PreparedStatement pstmt=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();
time=new Time();
str=new Str();
db=new Db();
//取得時間
try{
id=Integer.parseInt((String)request.getParameter("id"));
}catch(Exception e){
id=0;
}
password=request.getParameter("password");
password=str.inStr(password);
sqlsp="SELECT * FROM password WHERE employeeid="+id;
sqlse="SELECT employeeid FROM eminfo WHERE employeeid="+id;
sqlu="UPDATE password SET time='"+time.getYMDHMS()+"',password='"+password+"' WHERE employeeid="+id;
sqli="INSERT INTO password(employeeid,password,time) VALUES("+id+",'"+password+"','"+time.getYMDHMS()+"')";
try {
stmt=db.getStmtread();
rs=stmt.executeQuery(sqlsp);
//不是第一次設置更新數據庫
if(rs.next()){
db.close();
stmt=db.getStmt();
temp=0;
temp=stmt.executeUpdate(sqlu);
if(temp>0){
request.setAttribute("msg","設置成功");
}else{
request.setAttribute("msg","設置失敗");
}
db.close();
}else{
//第一次設置
db.close();
temp=0;
stmt=db.getStmtread();
rs=stmt.executeQuery(sqlse);
if(rs.next()){
//id存在
rs.close();
stmt.close();
temp=0;
stmt=db.getStmt();
temp=stmt.executeUpdate(sqli);
if(temp>0){
request.setAttribute("msg","設置成功");
}else{
request.setAttribute("msg","設置失敗");
}
db.close();
}else{
//id不存在
db.close();
request.setAttribute("msg","員工序號不存在");
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
RequestDispatcher dispatcher=request.getRequestDispatcher("set.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 + -