用mvc框架查询数据库数据

用mvc框架查询数据库数据

首先我们要新建一个项目

然后在src文件夹下新建四个包

分别为entity、DAO、servlet、tools

在entity下新建一个实体User

package entity;

public class User {
private String userID;
private String username;
private String userword;

public String getUserID() {
    return userID;
}
public void setUserID(String userID) {
    this.userID = userID;
}
public String getUsername() {
    return username;
}
public void setUsername(String username) {
    this.username = username;
}
public String getUserword() {
    return userword;
}
public void setUserword(String userword) {
    this.userword = userword;
}

}

然后在DAO下新建一个class名字为userdao

代码如下

package DAO;

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

import entity.*;
import DBHelper.DBHelper;

public class Userdao {
//String SQL=“SELECT*FROM users”;
// ResultSet rs= DBHelper.getResultSet(SQL);
//return tools.resultSetTolist(rs.User.class);
public boolean insert(User u){
String SQL=“INSERT INTO user(userID,username,password) VALUES(?,?,?)”;
Object[] params=new Object[]{u.getUserID(),u.getUsername(),u.getUserword()};
int n=DBHelper.ExecSql(SQL,params);
if(n>0) return true;
else return false;

}

public List getAllUser()

{
try{
String SQL=“SELECT*FROM users”;
ResultSet rs= DBHelper.getResultSet(SQL);
List users=new ArrayList();
while(rs.next())
{
User u=new User();
u.setUserID(rs.getString(“userID”));
u.setUsername(rs.getString(“username”));
u.setUserword(rs.getString(“password”));
users.add(u);
}
return users;
}catch(Exception ex){return null;}

}

}

package dao;

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

import entity.*;
import DBHelper.DBHelper;

public class Userdao {
//String SQL=“SELECT*FROM users”;
// ResultSet rs= DBHelper.getResultSet(SQL);
//return tools.resultSetTolist(rs.User.class);
public boolean insert(User u){
String SQL=“INSERT INTO user(userID,username,password) VALUES(?,?,?)”;
Object[] params=new Object[]{u.getUserID(),u.getUsername(),u.getUserword()};
int n=DBHelper.ExecSql(SQL,params);
if(n>0) return true;
else return false;

}
public List getAllUser()

{
try{
String SQL=“SELECT*FROM users”;
ResultSet rs= DBHelper.getResultSet(SQL);
List users=new ArrayList();
while(rs.next())
{
User u=new User();
u.setUserID(rs.getString(“userID”));
u.setUsername(rs.getString(“username”));
u.setUserword(rs.getString(“password”));
users.add(u);
}
return users;
}catch(Exception ex){return null;}

}

}

在servlet下新建一个servlet名字为Userservlet

代码如下

package servlet;

import java.io.;
import java.util.;

import javax.security.auth.message.callback.PrivateKeyCallback.Request;
import javax.servlet.;
import javax.servlet.http.;

import dao.;
import entity.;
import DBHelper.*;
public class Userservlet extends HttpServlet {

/**
 * Constructor of the object.
 */
public Userservlet() {
    super();
}

/**
 * Destruction of the servlet. <br>
 */
public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
}

/**
 * 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 {
        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 {
    request.setCharacterEncoding("UTF-8");
    String type=request.getParameter("type");
    Userdao dao=new Userdao();
    List<User> users=(List<User>)dao.getAllUser();
    //List users=dao.getAllUser();
request.getSession().setAttribute("users", users);
response.sendRedirect("../User.jsp");
    //request.setAttribute("users", users);
//    RequestDispatcher rd=request.getRequestDispatcher(type);
    //.sendRedirect("../User.jsp");
    
}



/**
 * Initialization of the servlet. <br>
 *
 * @throws ServletException if an error occurs
 */
public void init() throws ServletException {
    // Put your code here
}

}

在WebRoot下新建文件User.jsp

将DBHelper复制到tools包下

然后运行Userservlet

得到数据库数据

注意：数据库用户名和密码在DBHelper.java里更改

转载自：https://www.cnblogs.com/js19961226/p/5286545.html