今天，正是步入servlet,jsp

package web;


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.SQLException;


import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;


/**
 * Servlet implementation class ListEmpServlet
 */
@WebServlet("/ListEmpServlet")
public class ListEmpServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ListEmpServlet() {
        super();
        // TODO Auto-generated constructor stub
    }


/**
* @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
*/
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
Connection conn=null;
try{
Class.forName("com.mysql.jdbc.Driver");
conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/jd1109db2", "root", "");
Statement stat=(Statement)conn.createStatement();
ResultSet rst=(ResultSet)stat.executeQuery("select * from t_emp");
response.setContentType("text/html;charset=utf-8");
PrintWriter out=response.getWriter();
out.println("<table border='1' width='60%' cellpading='0' cellspacing='0'>");
out.println("<tr>"+"<td>id</td>"+"<td>姓名</td>"+"<td>薪水</td>"+"<td>年龄</td></tr>");
while(rst.next()){
long id=rst.getLong("id");
String name=rst.getString("name");
double salary=rst.getDouble("salary");
int age=rst.getInt("age");
out.println("<tr><td>"+id+"</td><td>"+name+"</td><td>"+salary+"</td><td>"+age+"</td><td>"+"<a href='del?id="+id+"'>"+"删除</a>"+

"&nbsp"+"<a href='load?id="+id+"'>"+"修改</a></td></tr>");

}
out.println("</table>");

out.println("<a href='addEmp.html'>增加新雇员</a>");
out.close();
}
catch(Exception e){
e.printStackTrace();
throw new ServletException(e);
}
finally{
if(conn!=null){
try{conn.close();}
catch(SQLException e){
e.printStackTrace();
}
}
}