#声明
- 单纯记录学习计算机当中所遇到的问题
- 把解决问题的方法分享给大家
- 希望大佬不要喷我这个小白
#链接mysql数据库
public class BaseDao {
public Connection getConnection() throws ClassNotFoundException, SQLException {
//url里的demo4为数据库名称
String url = "jdbc:mysql://localhost:3306/demo4?serverTimezone=UTC&useSSL=false&characterEncoding=UTF-8";
String user = "root";//数据库用户名
String pwd = "123456";//数据库密码
Connection conn = null;
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection(url,user,pwd);
return conn;
}
}
#创建实体类
private Integer id;
private String userName;
private String userPwd;
#定义添加的数据库操作(后续的删除,修改,查找大致相同)
public int addUser(String name,String pwd){
int code = 0;
try {
conn = baseDao.getConnection();
PreparedStatement pst = null;
String sql="insert into user(userName,userPwd) values(?,?)";
pst = conn.prepareStatement(sql);
pst.setString(1,name);
pst.setString(2,pwd);
code = pst.executeUpdate();
pst.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}
return code;
}
#定义添加的servelt操作方法
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 java.io.IOException;
import java.io.PrintWriter;
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req,resp);
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
PrintWriter out = resp.getWriter();
String username = req.getParameter("username");
String password = req.getParameter("password");
UserDao userDao = new UserDao();
int code = userDao.addUser(username,password);
if(code>0){
resp.setHeader("refresh","1;URL=login.jsp");
out.print("注册成功,即将前往登录");
}else {
resp.setHeader("refresh","1;URL=register.jsp");
out.print("注册失败,请重新注册");
}
}
}
#完整代码放在百度网盘了
https://pan.baidu.com/s/1GklAQLdv9WYBlukayZfiow?pwd=tcie
提取码:tcie