一,项目结构和数据库
1,项目结构
2,数据库
二,后端代码
1,DBUtil.java
package com.util;
import java.sql.*;
public class DBUtil {
private static String driver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/javawebdemo";
private static String user = "root";
private static String pwd = "123456";
//加载驱动
static{
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//连接对象
public static Connection getConnection(){
Connection conn = null;
try {
conn = DriverManager.getConnection(url, user, pwd);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
//关闭流
public static void close(ResultSet rs, Statement st, Connection conn){
try {
if(rs != null){
rs.close();
}
if(st != null){
st.close();
}
if(conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(PreparedStatement pst, Connection conn){
close(null, pst, conn);
}
}
2,测试是否能连接数据库,JDBCTest.java
package com.test;
import com.util.DBUtil;
import java.sql.Connection;
public class JDBCTest {
public static void main(String[] args) {
//测试连接数据库是否成功
Connection conn = DBUtil.getConnection();
if(conn != null){
System.out.println("测试:数据库连接成功!");
}else{
System.out.println("测试:数据库连接失败!");
}
}
}
3,实体类User.java
package com.domain;
public class User {
protected String username;
protected String password;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPas