1、安装MySQL数据库
2、 初始化数据库
3、连接java和数据库
1)下载驱动程序 :mysql-connector-java-8.0.20.jar
2)复制粘贴到 WebContent----WEB-INF---lib
3)在common/ JdbcUtils.java文件夹下添加连接文件
package common;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JdbcUtils {
private static String driver="com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test3?serverTimezone=UTC&characterEncoding=UTF-8";
private static String username="root";
private static String pwd="123456";
static {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection con=null;
try {
con=DriverManager.getConnection(url,username,pwd);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException(e);
}
return con;
}
}
4、更改PersonDao.java中的savePerson方法,向数据库添加信息
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import common.JdbcUtils;
import pojo.Person;
public class PersonDao {
public void savePerson(Person per) {
Connection con=null;
PreparedStatement pstmt=null;
try {
con=JdbcUtils.getConnection();
String sql="insert into person(name,pwd,sex,jiguan,description) values(?,?,?,?,?)";
pstmt=con.prepareStatement(sql);
pstmt.setString(1, per.getName());
pstmt.setString(2, per.getPwd());
pstmt.setString(3, per.getSex());
pstmt.setString(4, per.getJiguan());
pstmt.setString(5, per.getDesc());
pstmt.executeUpdate();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
throw new RuntimeException(e);
}finally {
if(pstmt!=null) {
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(con!=null){
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public boolean login(String name,String pwd) {
//数据库校验
if (name.startsWith("it")&&pwd.startsWith("123")) {
return true;
}
else {
return false;
}
}
public List<Person> list(){
List<Person> list=new ArrayList<>();
for(int i=0;i<10;i++) {
Person per=new Person();
per.setName("jack"+i);
per.setJiguan("jn"+i);
list.add(per);
}
return list;
}
}
5、更新后的数据库: