selectservlet.java

student managment systemstudent managment systemstudent managment systemstudent managment systemstud

package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import bean.StudentBean;

import common.DataBaseConnection;
import common.NumFormat;

public class SelectServlet extends HttpServlet
{  
	public void init(ServletConfig config) throws ServletException
    {
		super.init(config);
    }
   public  void  doPost(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
   		String operator=request.getParameter("opertator");
   		request.setAttribute("opertator",operator);
   		StudentBean student=new StudentBean();  //创建Javabean对象
   		request.setAttribute("student",student);
   		StringBuffer str=new StringBuffer();
   		try{
   			 Connection con=DataBaseConnection.getConnection();
   			 PreparedStatement prst=con.prepareStatement("SELECT * FROM score order by sno");
   			 ResultSet rs = prst.executeQuery();	
	        while(rs.next())
			{
				
				str.append("<tr bordercolor=#990066>");
				str.append("<td>"+NumFormat.transSelect(rs.getString(1))+"</td>");
				str.append("<td>"+NumFormat.transSelect(rs.getString(2))+"</td>");
				str.append("<td>"+rs.getString(3)+"</td>");
				str.append("<td>"+rs.getString(4)+"</td>");
				str.append("<td>"+rs.getString(5)+"</td>");
				//更改
				if(operator.equals("update")){
					str.append("<td><a href='UpdateSelectStudent?sno="+
							NumFormat.transSelect(rs.getString("sno"))+"'>"
							+NumFormat.transSelect("更改")+"</a>");
				}
				//删除
				if(operator.equals("delete")){
					str.append("<td><a href='DeleteStudent?sno="
							+NumFormat.transSelect(rs.getString("sno"))+"'>"
							+NumFormat.transSelect("删除")+"</a>");
				}
				str.append("</tr>");
			}
	        student.setPresentPageResult(str);
		    con.close();
   		}catch(SQLException e){
   			e.printStackTrace();
   		}
		RequestDispatcher dispatcher= request.getRequestDispatcher("/getAllStudents.jsp");
	    dispatcher.forward(request, response); //请求getAllStudents.jsp显示student中的数据
    } 
   public  void  doGet(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
   		doPost(request,response);
    }
}