使用Servlet敲写的用户登陆注册
本案例使用Servlet+jsp制作,用Intellij Idea IDE和Mysql数据库进行搭建,详细介绍了搭建过程及知识点。
主要功能有:
1.用户注册
2.用户登录
涉及到的知识点:
1.JDBC
2.Servlet
一、首先打开mysql数据库 新建一个数据库jdbc,然后生成对应的表结构
二、编写各个对应的包
1.com.dao
2.com.pojo
3.com.servlet
4.com.util
三、在util包下建立一个UserDb类来处理数据库连接的问题
package com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class UserDb {
static String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=yes&characterEncoding=UTF-8&useSSL=false";
static String root = "root";
static String password = "158699";
public static Connection getConnection(){
//加载驱动
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
//获取连接
conn = DriverManager.getConnection(url,root,password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
//获取连接
}
四、在pojo下创建实体类User
package com.pojo;
public class User {
private int id;
private String name;
private String password;
private String sex;
public User() {
}
public User(int id, String name, String password, String sex, String address) {
this.id = id;
this.name = name;
this.password = password;
this.sex = sex;
this.address = address;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", password='" + password + '\'' +
", sex='" + sex + '\'' +
", address='" + address + '\'' +
'}';
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
private String address;
}
五、在dao包下建立一个UserDao接口类,以及它所对应的实现类
package com.dao;
i