?? view.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 oa.data.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
****************************************************
*類名稱: View<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 View extends HttpServlet{
private Statement stmt=null;
private ResultSet rs=null;
private Statement stmt1=null;
private ResultSet rs1=null;
private String name,birthday,dep,job,state,learn,post,tel,addr,sql="SELECT * FROM eminfo";
private RequestDispatcher dispatcher=null;
private HttpSession session=null;
private int deid,jobid,stateid,sex,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();
Collection coll=new ArrayList();
//獲取數據
Db db=new Db();
Str str=new Str();
try{
stmt=db.getStmtread();
rs=stmt.executeQuery(sql);
while(rs.next()){
id=rs.getInt(1);
name=rs.getString(2);
sex=rs.getInt(3);
birthday=rs.getString(4);
learn=rs.getString(5);
post=rs.getString(6);
deid=rs.getInt(7);
jobid=rs.getInt(8);
tel=rs.getString(9);
addr=rs.getString(10);
stateid=rs.getInt(11);
dep=db.IdtoDo("Name","department WHERE departmentid="+deid);
job=db.IdtoDo("Name","job WHERE jobid="+jobid);
state=db.IdtoDo("Name","emstate WHERE stateid="+stateid);
//字符轉換
name=str.outStr(name);
birthday=birthday.substring(0,10);
dep=str.outStr(dep);
job=str.outStr(job);
state=str.outStr(state);
learn=str.outStr(learn);
post=str.outStr(post);
tel=str.outStr(tel);
addr=str.outStr(addr);
Eminfo eminfo=new Eminfo();
eminfo.setId(id);
eminfo.setName(name);
eminfo.setSex(sex);
eminfo.setBirthday(birthday);
eminfo.setLearn(learn);
eminfo.setPost(post);
eminfo.setDepartment(dep);
eminfo.setJob(job);
eminfo.setTel(tel);
eminfo.setAddr(addr);
eminfo.setState(state);
coll.add(eminfo);
}
}catch(Exception e){
e.printStackTrace();
}finally{
db.close();
request.setAttribute("msg",coll);
dispatcher=request.getRequestDispatcher("view.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 + -