JDBC

2023-03-16 09:20| 来源: 网络整理| 查看: 265

1. 工程文件

工作软件我用的是eclipse和MYSQL 8.0 连接数据库用的驱动JDBC.jar一定要有，怎么用网上有教程

2.数据库样式

3.DBUtil.java package com.imooc.jdbc; import java.sql.Connection; import java.sql.DriverManager; //连接数据库 public class DBUtil { private static final String URI = "jdbc:mysql://localhost:3306/ tbl_user_info?" + "user=root&password=123456&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8"; private static final String DRIVER = "com.mysql.cj.jdbc.Driver"; public static Connection connectDB() throws Exception { //1、加载数据库驱动 Class.forName(DRIVER); //2、获取数据库连接 Connection conn = DriverManager.getConnection(URI); return conn; } } 4.UserDao.java package com.imooc.jdbc; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import com.imooc.jdbc.DBUtil; //工具类 public class UserDao { public boolean queryByParams(List params) throws Exception {//查询 Connection conn = DBUtil.connectDB(); StringBuilder sql = new StringBuilder("SELECT * FROM tb_user WHERE 1=1"); for(Map param : params) { sql.append(" and "); sql.append(" " +param.get("col")+ " "); sql.append(" " + param.get("rel") + " "); sql.append(" " + "'"+param.get("value") + "'"+ " "); } Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql.toString()); if(rs.next()) { return true; } else{ return false; } } public boolean addUser(UserVO user) throws Exception {//增加 Connection conn = DBUtil.connectDB(); String sql = "INSERT INTO tb_user(username,email,password,sex,address) " + " VALUES(?,?,?,?,?)"; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, user.getUsername()); pstmt.setString(2, user.getEmail()); pstmt.setString(3, user.getPassword()); pstmt.setString(4, user.getSex()); pstmt.setString(5, user.getAddress()); pstmt.execute(); return true; } } 5.Login.jsp 登录页面去注册. 用户登录用户名密码登录 6.LoginServlet.java package com.imooc.jdbc; import java.io.IOException; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.RequestDispatcher; 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.imooc.jdbc.*; //登录验证 @WebServlet(name = "LoginServlet", urlPatterns = { "/LoginServlet" }) public class LoginServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{ doPost(request, response); } protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String name = request.getParameter("username"); String password = request.getParameter("password"); String flag = request.getParameter("isLogin"); List params = new ArrayList(); Map param1 = new HashMap(); param1.put("col", "username"); param1.put("rel", "like"); param1.put("value", name); params.add(param1); Map param2 = new HashMap(); param2.put("col", "password"); param2.put("rel", "like"); param2.put("value", password); params.add(param2); UserDao dao = new UserDao(); try { if (dao.queryByParams(params)) { RequestDispatcher dis = request.getRequestDispatcher("LoginSuc.jsp"); dis.forward(request, response); } else { request.setAttribute( "flag_login","false"); request.getRequestDispatcher("LoginFal.jsp").forward(request,response); //RequestDispatcher dis = request.getRequestDispatcher("Login2.jsp"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } 7.Register.jsp 注册注册页面. 返回登录. 注册用户用户名邮箱密码性别男女住址注册 8.RegisterServlet.java package com.imooc.jdbc; import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.RequestDispatcher; 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.imooc.jdbc.*; //注册验证 @WebServlet(name = "RegisterServlet", urlPatterns = { "/RegisterServlet" }) public class RegisterServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{ doPost(request, response); } protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String name = request.getParameter("username"); String password = request.getParameter("password"); String email = request.getParameter("email"); String sex = request.getParameter("sex"); String Address = request.getParameter("Address"); //String flag = request.getParameter("isLogin"); UserVO user = new UserVO(); user.setUsername(name); user.setEmail(email); user.setPassword(password); user.setSex(sex); user.setAddress(Address); UserDao dao = new UserDao(); try { if(dao.addUser(user)) { RequestDispatcher dis = request.getRequestDispatcher("RegisterSuc.jsp"); dis.forward(request, response); } } catch (Exception e) { e.printStackTrace(); } } } 效果

登录页面

注册页面参考文章： https://blog.csdn.net/u011024652/article/details/51753481

https://blog.csdn.net/chineseD/article/details/84720338 第一次完成自己的web项目，感谢大佬

【本文地址】

JDBC

JDBC

今日新闻

推荐新闻