通过servlet来实现对Mysql进行连接、插入、修改、删除操作
来源:互联网 发布:淘宝开店认证 上半身 编辑:程序博客网 时间:2024/05/18 00:46
通过servlet来实现对Mysql进行连接、插入、修改、删除操作
来自:http://blog.sina.com.cn/s/blog_4bea2fb10100f3w3.html
package Servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import src.Logg;
import src.MysData;
public class UserServlet extends HttpServlet {
Logg log=new Logg();
MysData usr=new MysData();
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, SQLException{
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
//java.sql.Connection conn=log.ConnectMysql();不能在这里这样写。具体在操作函数里连接,见后面。
usr.setName(request.getParameter("username"));
usr.setPassword(request.getParameter("password"));
usr.setEmail(request.getParameter("email"));
String de=request.getParameter("eee");//从不同的form过来的隐藏属性字段“eee”,通过对其值的判断就知道说哪个form,然后执行不同的操作
if(de.equals("qq")){
log.InsertSql(usr);
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet NewServlet</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet NewServlet at " + request.getContextPath () + "</h1>");
out.println("wewewe");
out.println("<br>");
out.println(request.getAttributeNames());
out.println("注册成功!");
out.println(de);
out.println("</body>");
out.println("</html>");
}else if(de.equals("cha")){
String password= request.getParameter("password");
//String email= request.getParameter("email");
//String userid=request.getParameter("userid");
//下面的5是随便设置的值,很明显,这个值应该是当然登陆的用户的值,那么这个值如何获得呢?明天研究。//后来研究了下,通过session来弄的。后面有用到session,但是只是简单弄了下。
String upsql="update user set password="+password+" where userid=5";
out.print(upsql);
log.UpdateSql(upsql);