package op.svltbbms;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import op.db.ConnectionManager;
import op.model.students;
public class cardlist extends HttpServlet {
public cardlist() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String cardid=request.getParameter("txtcardid");
String cardname=request.getParameter("txtcardname");
String sqllist="select stuid,stuName,stuSex,stuNo,stuDept,stuClass,stuPhoto,stuMark from students where 1=1";
if((cardid!=null)&&(!cardid.equals(""))){
sqllist=sqllist+" and stuid="+cardid;
}
if((cardname!=null)&&(!cardname.equals(""))){
sqllist=sqllist+" and stuName='"+cardname+"'";
}
ArrayList ary=new ArrayList();
Connection con=ConnectionManager.getConnection();
try{
PreparedStatement pstmt=con.prepareStatement(sqllist);
ResultSet rs=pstmt.executeQuery();
while(rs.next()){
students stu=new students();
int stuid=rs.getInt("stuid"); //数据类型转换
String stuidsg=String.valueOf(stuid);
stu.setStuidsg(stuidsg);
stu.setStuname(rs.getString("stuName"));
stu.setStusex(rs.getString("stuSex"));
stu.setStuno(rs.getString("stuNo"));
stu.setStudept(rs.getString("stuDept"));
stu.setStuclass(rs.getString("stuClass"));
stu.setStuphoto(rs.getString("stuPhoto"));
stu.setStumark(rs.getString("stuMark"));
ary.add(stu);
}
}catch(Exception e){
e.printStackTrace();
}finally{
ConnectionManager.closeConnection(con);
}
request.setAttribute("students", ary);
request.getRequestDispatcher("/pagebbms/cardlist.jsp").forward(request, response);
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}