1.创建项目并导入数据驱动
数据驱动下载
2.创建数据表
3.连接数据库
测试数据库连接
public class DBUtil {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver"); //反射:reflect - 封装,想要得到封装体里面的细节,需要用反射机制来获取
System.out.println("获取驱动成功");
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/db_java1ssm?useSSL=true&characterEncoding=utf-8","root","123456");
System.out.println("连接数据库成功");
}catch (Exception e){
e.printStackTrace();
}
}
}
运行结果
显示数据库内容
public class TestDemo01 {
//1.查询tb_user这张表中的数据
public static void printAllUser(){
try {
//(1)加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//(2)创建数据库连接
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/db_java1ssm?useSSL=true&characterEncoding=utf-8","root","123456");
System.out.println("连接数据库成功");
//(3)准备写出SQL语句
String sql = "select * from tb_user";
//(4)选中语句并执行它
PreparedStatement pstm = conn.prepareStatement(sql);
//(5)产生结果
ResultSet rs =pstm.executeQuery();
//(6)处理结果
while (rs.next()){
System.out.println("用户编号:"+rs.getInt(1)+",用户名称:"+rs.getString(2)+",用户密码:"+rs.getString(3)+",用户类型:"+rs.getInt(4));
}
//(7)释放连接
rs.close();
pstm.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}finally {
}
}
}