Servlet编写网页并与数据库连接

最新推荐文章于 2021-01-19 18:21:54 发布
最新推荐文章于 2021-01-19 18:21:54 发布
阅读量887 收藏 4
点赞数 1

首先要保证电脑已经安装tomcat 和mysql并用myeslipse(esplise)实现

//首页 登陆页面 Login.java

package nuc.exam.servlet;

import java.io.IOException;
import java.io.PrintWriter;

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

public class Login extends HttpServlet {
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
/**
 * Constructor of the object.
 */
public Login() {
    super();
}

    public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    this.doPost(request, response);
}

    public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    response.setContentType("text/html;charset=utf-8");
    request.setCharacterEncoding("utf-8");
    PrintWriter out = response.getWriter();
    out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
    out.println("<HTML>");
    out.println("  <HEAD><TITLE>登陆界面</TITLE></HEAD>");
    out.println("  <BODY>");
    out.print("<form action='Insert' method='post'>");
    out.print("<table border='1' align='center'>");
    out.print("<tr align='center'>");
    out.print("<td colspan='2'>");out.print("<h2>电影介绍</h2>");out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>");out.print("电影名称：");out.print("</td>");
    out.print("<td>");out.print("<input type='text' name='name' value=''>");out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>");out.print("电影价格：");out.print("</td>");
    out.print("<td>");out.print("<input type='text' name='price' value=''>");out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>");out.print("电影产地：");out.print("</td>");
    out.print("<td>");
    out.print("<input type='radio' name='from' value='大陆'>大陆");
    out.print("<input type='radio' name='from' value='香港'>香港");
    out.print("<input type='radio' name='from' value='国外'>国外");
    out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>");out.print("电影类型：");out.print("</td>");
    out.print("<td>");
    out.print("<select name='type'>");
    out.print("<option>动作片</option>");
    out.print("<option>动画片</option>");
    out.print("<option>剧情片</option>");
    out.print("</select>");
    out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>");out.print("电影主演：");out.print("</td>");
    out.print("<td>");
    out.print("<input type='checkbox' name='actor' value='李小龙'>李小龙");
    out.print("<input type='checkbox' name='actor' value='成龙'>成龙");
    out.print("<input type='checkbox' name='actor' value='其他'>其他");
    out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>");out.print("电影简介：");out.print("</td>");
    out.print("<td height='100px'>");
    out.print("<input type='textarea' style='height:100px;' name='' value=''> ");
    out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>");out.print("电影详细介绍：");out.print("</td>");
    out.print("<td>");
    out.print("<input type='file'  name='' calue=''>");
    out.print("</td>");
    out.print("</tr>");
    out.print("<tr>");
    out.print("<td colspan='2'>");
    out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
    out.print("<input type='submit' value='提交'>");
    out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
    out.print("<input type='reset' value='重置'>");
    out.print("</td>");
    out.print("</tr>");
    out.print("</table>");
    out.print("</form>");
    out.println("");
    out.println("  </BODY>");
    out.println("</HTML>");
    out.flush();
    out.close();
}

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90

}
这里写图片描述
//这个是用servlet 写的。

这里写图片描述

链接数据库 UserCoon.java

package nuc.test.coon;
import java.sql.*;
public class UserCoon {
    public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
    public static final String DBURL="jdbc:mysql://localhost:3306/test";
    public static final String DBUSER="root";
    public static final String DBPASS="123456";
    Connection conn=null;
    public Connection getCoon(){
        try {
            Class.forName(DBDRIVER);
            conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }


**Find.java**各种方法  
package nuc.test.Dao;

import java.sql.*; 
import java.util.*;

import nuc.test.coon.*;
import nuc.test.user.User;
public class Find {
       public int SelectCount(){
           int count=0;
           ResultSet rs=null;
           UserCoon coon=new UserCoon();
           Connection coona=coon.getCoon();
           String sql_Counts="select count(*) from user";
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
       try {
        PreparedStatement pst=coona.prepareStatement(sql_Counts);
        rs=pst.executeQuery();
        if(rs.next()){
            count=rs.getInt(1);

        }
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
       return count;

   }


   //分页查询
   public List<User> Selectcontent(int page){
       List<User> list=new ArrayList<User>();
       UserCoon coon=new UserCoon();
       Connection coona=coon.getCoon();

       String sql_Count="select * from user limit ?,?";
       try {
        PreparedStatement pst=coona.prepareStatement(sql_Count);
        pst.setInt(1, (page-1)*User.PAGESIZE);
        pst.setInt(2, User.PAGESIZE);
        ResultSet rs=pst.executeQuery();
        while(rs.next()){
            User usera=new User();
            usera.setId(rs.getString("id"));
            usera.setUsername(rs.getString("username"));
            usera.setPassword(rs.getString("password"));
            usera.setType(rs.getString("type"));
            list.add(usera);

        }

       } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }


       return list;


   }

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48

}

UserDao.java 各种方法

package nuc.test.Dao;

import java.sql.*;

import nuc.test.coon.*;
import nuc.test.user.*;

//插入
public class UserDao {
    public int Insert(User usera){
        PreparedStatement pst=null;
        int rs=0;
        UserCoon coon=new UserCoon();
        Connection coona=coon.getCoon();
        String sql_insert="insert into user(username,password,type) values(?,?,?)";
        try{
            pst=coona.prepareStatement(sql_insert);
            pst.setString(1, usera.getUsername());
            pst.setString(2, usera.getPassword());
            pst.setString(3,usera.getType());
            rs=pst.executeUpdate();
        }catch(Exception e){
            e.printStackTrace();
        }

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
    return rs;
}

//查询
public ResultSet Query(){
    PreparedStatement pst=null;
    ResultSet rs=null;
    UserCoon coon=new UserCoon();
    Connection coona=coon.getCoon();
    String sql_query="select * from user";
    try {
        pst=coona.prepareStatement(sql_query);
        rs=pst.executeQuery();
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return rs;

}
//查找
public ResultSet Select(User usera){
    PreparedStatement pst=null;
    ResultSet rs=null;
    UserCoon coon=new UserCoon();
    Connection conna=coon.getCoon();
    String sql_Select="select * from user where id=?";
    try {
        pst=conna.prepareStatement(sql_Select);
        pst.setString(1, usera.getId());
        rs=pst.executeQuery();
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    return rs;

}


//更新
public  int Update(User usera){
    PreparedStatement pst=null;
    int rs=0;
    UserCoon coon=new UserCoon();
    Connection coona=coon.getCoon();
    String sql_update="update user set username=?,password=?,type=? where id=?";
    try {
        pst=coona.prepareStatement(sql_update);
        pst.setString(1, usera.getUsername());
        pst.setString(2, usera.getPassword());
        pst.setString(3, usera.getType());
        pst.setString(4, usera.getId());
        rs=pst.executeUpdate();
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return rs;

}

//删除
public int Delete(User usera){
    PreparedStatement pst=null;
    int rs=0;
    UserCoon coon=new UserCoon();
    Connection coona=coon.getCoon();
    String sql_delete="delete from user where id=?";
    try {
        pst=coona.prepareStatement(sql_delete);
        pst.setString(1, usera.getId());
        rs=pst.executeUpdate();
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    return rs;

}
//查找某一项数据   可用来更新
public  ResultSet Login(User usera){
    PreparedStatement pst=null;
    ResultSet rs=null;
    UserCoon coon=new UserCoon();
    Connection conna=coon.getCoon();
    String sql_Select="select * from user where username=? and password=? and type=?";
    try {
        pst=conna.prepareStatement(sql_Select);
        pst.setString(1, usera.getUsername());
        pst.setString(2, usera.getPassword());
        pst.setString(3, usera.getType());
        rs=pst.executeQuery();
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    return rs;

}

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103

}

servlet各个方法

这里写图片描述

按提交键就会调用Insert方法

以下方法都是由网页jsp方法改写的，然后调用UserDao里的方法来实现

//插入方法 Insert.java

package nuc.test.servet;

import java.io.IOException;
import java.io.PrintWriter;

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

import nuc.test.Dao.UserDao;
import nuc.test.user.User;

public class Insert extends HttpServlet {
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
/**
 * Constructor of the object.
 */
public Insert() {
    super();
}

/**
 * The doGet method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to get.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {


}

/**
 * The doPost method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to post.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=utf-8");
    PrintWriter out = response.getWriter();
    request.setCharacterEncoding("utf-8");
    User user=new User();
    UserDao dao =new UserDao();
    user.setUsername(request.getParameter("username"));
    user.setPassword(request.getParameter("password"));
    user.setType(request.getParameter("type"));
    int a=dao.Insert(user);
    if(a!=0){
        out.print("插入成功");
    }
    response.setHeader("refresh", null );
}

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49

}

这里写图片描述

//查找方法 ShowPage.java

package nuc.test.servet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

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

import nuc.test.Dao.Find;
import nuc.test.user.User;

public class ShowPage extends HttpServlet {
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
/**
 * Constructor of the object.
 */
public ShowPage() {
    super();
}

/**
 * The doGet method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to get.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    this.doPost(request, response);
}

/**
 * The doPost method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to post.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=utf-8");
    PrintWriter out = response.getWriter();
    request.setCharacterEncoding("utf-8");
    out.print(" <table align='center' width='800' border='1'>");
    out.print("<tr>");
    out.print("<td align='center' colspan='5'>");
    out.print("所有用户信息");
    out.print("</td>");
    out.print("</tr>");
    out.print("<tr align='center'>");
    out.print("<td>用户名</td><td>密码</td><td>用户类型</td><td colspan='2'>操作方法</td>");
    out.print("</tr>");

    int currpage=1;
    if(request.getParameter("page")!=null){
        currpage=Integer.parseInt(request.getParameter("page"));

    }
    Find find=new Find();
    List<User> listall=new ArrayList<User>();
    listall=find.Selectcontent(currpage);
    Iterator<User> it=listall.iterator();
    while(it.hasNext()){
           User usera=it.next();


           out.print("<tr align='center'>");
           out.print("<td>"+usera.getUsername()+"</td>");
           out.print("<td>"+usera.getPassword()+"</td>");
           out.print("<td>"+usera.getType()+"</td>");
           out.print("<td><a href='servlet/Update?id="+usera.getId()+"'>修改</a></td>");
           out.print("<td><a href='servlet/Delete?id="+usera.getId()+"'>删除</a></td>");
           out.print("</tr>");
    }
           out.print("<tr>");
           out.print("<td align='center' colspan='5'>");
           out.print("<jsp:include page='Bar.jsp'>");
           out.print("</td>");
           out.print("</tr>");
           out.print("<tr align='center'><td colspan='5'><a hraf='first.jsp'>添加用户</a></td></tr>");
           out.print("</table>");
}

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77

}

Delete.java

package nuc.test.servet;

import java.io.IOException;
import java.io.PrintWriter;

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

import nuc.test.Dao.UserDao;
import nuc.test.user.User;

public class Delete extends HttpServlet {
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
/**
 * The doGet method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to get.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    response.setContentType("text/html;charset=utf-8");
    request.setCharacterEncoding("utf-8");
    PrintWriter out = response.getWriter();
    User user=new User();
    user.setId(request.getParameter("id"));
    UserDao dao=new UserDao();
    int result=dao.Delete(user);
    if(result!=0){
        out.println("删除成功");
        //response.sendRedirect("servlet/FindPage");

    }

}

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27

}

update.java//先查出某一条记录，准备删除

package nuc.test.servet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;

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

import nuc.test.Dao.UserDao;
import nuc.test.user.User;

public class Update extends HttpServlet {
    public Update(){
        super();
    }
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
/**
 * The doGet method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to get.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    response.setContentType("text/html;charset=utf-8");
    PrintWriter out = response.getWriter();
    request.setCharacterEncoding("utf-8");

    User user=new User();
    UserDao dao =new UserDao();
    user.setId(request.getParameter("id"));
    ResultSet result=dao.Select(user);
    try{
        if(result.next()){
            out.println("<form action='doUpdate?id="+result.getString("id")+"' method='post'>");
            out.println("用户名：<input type='text' value='"+result.getString("username")+"' name='username'>");
            out.println("密 码：<input type='text' value='"+result.getString("password")+"' name='password'>");
            out.println("用户类型<select>");
            out.println("<option value='管理员'>管理员</option>");
            out.println("<option value='普通用户'>普通用户</option>");
            out.println("</select>");
            out.println("<input type='submit' value='修改'>");
            out.println("<input type='reset' value='取消'>");
            out.println("</form>");
        }
    }catc

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
h(Exception e){
            e.printStackTrace();
 
 
  • 1
  • 2
    }
}

 
 
  • 1
  • 2

}

doupdate.java
package nuc.test.servet;

import java.io.IOException;
import java.io.PrintWriter;

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

import nuc.test.Dao.UserDao;
import nuc.test.user.User;

public class doUpdate extends HttpServlet {
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
/**
 * Constructor of the object.
 */
public doUpdate() {
    super();
}

/**
 * The doGet method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to get.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    this.doPost(request, response);
}

/**
 * The doPost method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to post.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    response.setContentType("text/html;charset=utf-8");
    PrintWriter out = response.getWriter();
    request.setCharacterEncoding("utf-8");
    User user=new User();
    UserDao dao=new UserDao();

    user.setId(request.getParameter("id"));
    user.setUsername(request.getParameter("username"));
    user.setPassword(request.getParameter("password"));
    user.setType(request.getParameter("type"));
    int result=0;
            result=dao.Update(user);
    if(result!=0){
        out.print("更新成功");
    }
}

 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52

}

//user.java源代码

public class User {
     public static final int PAGESIZE=5;
 private String id;
     private String username;
     private String password;
     private String type;  
        public String getId() {
            return id;
        }
        public void setId(String id) {
            this.id = id;
        }
        public String getUsername() {
            return username;
        }
        public void setUsername(String username) {
            this.username = username;
        }
        public String getPassword() {
            return password;
        }
        public void setPassword(String password) {
            this.password = password;
        }
        public String getType() {
            return type;
        }
        public void setType(String type) {
            this.type = type;
 
 
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
wangliang369
关注
  • 1
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
servlet连接数据库的方式
m0_49053556的博客
06-30 671
关于今天所学servlet连接数据库的方式 方式一 JDBC的方式获取Connection private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"
如何编写一个Servlet
程序媛乐园
10-07 7578
Servlet 1.什么是servlet servlet本身就是一种java类,这种java类可以提供web形式的访问(Java EE 规范) 2.怎么按照JavaEE的规范编写一个servlet 关键字 作用 说明 Servlet 接口 有五个抽象方法 GenericServlet 抽象类 有一个抽象方法 HttpServlet 抽象类 没有抽象方法 HttpServ...
01使用Servlet进行网页的开发
呀！芝士的博客
09-17 169
创建一个java类去继承HttpServelt 重写service方法 在service方法中开发动态网页 @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { //响应的中文乱...
servlet连接数据库实现登录
Gorilla的博客
10-10 1万+
实现了一个简单的连接数据库查询用户名是否匹配，并登录且记住账户密码的操作。 一下是代码。 封装的一个Connection工具类 package com.xx; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; impo...
BMI计算网页并连接数据库
06-14
4. **数据库连接**: 项目中提到的后台功能包括查询、增加和删除数据库中的数据。这需要使用Java的JDBC（Java Database Connectivity）API来实现。开发者可能创建了一个数据库表来存储用户的历史BMI记录，包括日期、...
原生servlet+C3P0数据库连接池搭建的商城系统.zip
最新发布
07-24
这个系统利用了Servlet技术作为后端处理核心，结合MySQL数据库存储数据，并通过C3P0连接池管理数据库连接，优化资源利用率。下面我们将详细探讨这些关键知识点。 **Servlet技术** Servlet是Java EE平台中用于扩展...
servlet连接数据库实例.doc
06-03
servlet 连接数据库实例 标题：servlet 连接数据库实例 ...本文介绍了使用 Java 语言连接 SQLServer 数据库的基本步骤，包括 JDK 和 Tomcat 的安装和配置、数据库连接、Java Web 应用程序开发和部署等。
servlet登陆界面，连接数据库
04-17
首先需要在项目中引入MySQL的JDBC驱动，然后在Servlet中编写代码来建立数据库连接，执行SQL语句，最后关闭连接。连接数据库的关键步骤包括： 1. 加载驱动：`Class.forName("com.mysql.jdbc.Driver")` 2. 创建连接：`...
在Servlet中连接数据库的Java代码
05-17
在Servlet中，我们通常在`doGet`或`doPost`方法内编写数据库连接代码。 3. **数据库连接信息**：包括数据库URL、用户名、密码和驱动类名。例如，对于MySQL，URL可能类似于`jdbc:mysql://localhost:3306/mydatabase`...
在Servlet中使用JDBC访问数据库
热门推荐
Gamedev
05-26 1万+
在Servlet中使用JDBC访问数据库(1) 新建用户注册表单页 index.jsp<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> </head>
java servlet 连接数据库
Join Hands
01-26 3436
import java.io.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import javax.servlet.*; import javax.servlet.http.*; public class
MyEclipse的安装
晓晓的博客
05-19 6114
链接：https://pan.baidu.com/s/1X8kb3deszVTE3MiGhRtoyw 提取码：0s88 下载上面的东东 里面有两个文件，一个是安装文件，一个是破解压缩文件。 先安装好MyEclipse，一路下一步就好。 把压缩文件解压，如上不要打开安装好的MyEclipse，运行run.bat 输入Usercode, 点击’SystemId…’, 生成SystemId 点击’Active’, 生成LICENSE_KEY, ACTIVATION_CODE, ACTIVATION_KEY
java服务器端开发-servlet：3_1、Servlet使用jdbc访问数据库：增加员工信息插入mysql数据库
鲁迷那的专栏—坚持实践后再写出来！
03-16 722
一、前言 上一篇文章介绍了一些理论知识点：Servlet使用jdbc访问数据库、mysql的简单使用、重定向等。详见可参考博文：原创java服务器端开发-servlet：3、Servlet使用jdbc访问数据库、mysql的简单使用、重定向这篇文章主要介绍案例即Servlet使用jdbc访问数据库：增加员工信息插入mysql数据库 二、增加员工信息插入mysql数据库 既然是入库操作...
java 把学生信息存到mysql中_用javaweb写一个注册界面，并将数据保存到后台数据库（全部完成）（课堂测试）...
weixin_39642619的博客
01-19 1493
一、题目：WEB界面链接数据库1.考试要求：1登录账号：要求由6到12位字母、数字、下划线组成，只有字母可以开头；(1分)2登录密码：要求显示“• ”或“*”表示输入位数，密码要求八位以上字母、数字组成。(1分)3性别：要求用单选框或下拉框实现，选项只有“男”或“女”；(1分)4学号：要求八位数字组成，前四位为“2018”开头，输入自己学号；(1分)5姓名：输入自己的姓名；6点击“添加”按钮，将学...
Servlet与数据库的连接，及三层架构
qq_735311015的博客
05-10 852
吃饭的时候，首先面对的服务员，我们把需要吃的菜报给服务员，服务员通知厨师做饭，厨师做饭是通过采购购买的原材料 视图层jsp，html，js，css...(跟我们面对的服务员一样，负责给我们展示店内菜品，并通知厨师我们点了什么菜，有什么需求)主要用于展示客户端可见的内容，并把客户端输入的数据传递给业务层 业务层 Servlet(跟厨师一样，负责根据视图层(服务员)传递过来的需求进行逻辑判断，与业务操...
使用servlet连接数据库
北极传说的专栏
01-11 3233
使用servlet连接数据库主要配置web.xml的元素和元素。 1、web.xml配置 This is the description of my J2EE component This is the description of my J2EE component DBServlet jijian.test.DBServlet d
myeclispse配置自己的jdk和tomcat
不负好时光的博客
03-06 493
1配置jdk 2d 点击add 4 选择jdk所在的位置 next ok了 配置tomcat 选择自己的tomcat版本 next完成了
[JSP暑假实训] 三.MySQL数据库基本操作及Servlet网站连接显示数据库信息1
08-04
**Servlet连接显示数据库**：在Servlet部分，作者展示了如何通过Servlet来连接到MySQL数据库，获取数据，并将结果显示在JSP网页上。这涉及编写Servlet代码，使用PreparedStatement对象执行SQL查询，以防止SQL注入...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值