Servlet利用多控制器实现增删查改。
跳转在web.xml里配。无通配符。
当然,这样效率和可维护性是极低的。权当初学者教程吧。
增加方法
package emp;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class AddEmpServlet extends HttpServlet
{
protected void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
{
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
//读取请求参数值
String name = request.getParameter("name");
double salary = Double.parseDouble(request.getParameter("salary"));
int age = Integer.parseInt(request.getParameter("age"));
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
//检查请求参数值是否合法,暂时略
//JDBC
Connection conn = null;
PreparedStatement stat = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
stat = conn.prepareStatement("INSERT INTO emp(name,salary,age) VALUES(?,?,?)");
stat.setString(1, name);
stat.setDouble(2, salary);
stat.setInt(3, age);
stat.executeUpdate();
// out.println("添加员工成功");
// out.println("<a href='list'>查看所有员工</a>");
//重定向到员工列表
response.sendRedirect("list");
System.out.println("重定向之后的代码");
} catch (Exception e) {
e.printStackTrace();
/*
* 判断异常是否能够恢复,如果不能够恢复
* (比如,数据库服务暂停,网络中断等等,一般称之为系统异常),提示用户稍后重试即可。
* 如果能够恢复(应用异常),要立即恢复。
*/
out.println("系统繁忙,稍后重试");
}finally{
if(stat!=null){
try{
stat.close();
}catch(SQLException e){
e.printStackTrace();
}
}
if(conn!=null){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
}
删除方法
package emp;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSe