使用eclipse来查询数据
public static void main(String[] args) throws ClassNotFoundException {
// 第一步 加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
// 第二步 获取数据库连接
// 连接字符串
String url = "jdbc:mysql://localhost:3306/demo_db_2021?characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false";
// 用户名 密码
String userName = "root";
String password = "root";
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection(url, userName, password);
// 第三步 创建Statement
String strSql = "SELECT id,user_name,user_passwork,real_name,"
+ "sex,age,birthday,phone,address,user_roleid " + "FROM sys_user";
ps = conn.prepareStatement(strSql);
// 第四步 执行
rs = ps.executeQuery();
List<SysUser> userList = new ArrayList<SysUser>();
SysUser user = null;
// 第五步 获取数据 jdbc索引从1开始
while (rs.next()) {
user = new SysUser();
int id = rs.getInt("id");
user.setId(rs.getInt("id"));
user.setUserName(rs.getString("user_name"));
user.setRealName(rs.getString("real_name"));
user.setSex(rs.getByte("sex"));
user.setAge(rs.getInt("age"));
user.setBirthday(new java.sql.Date(rs.getTimestamp("birthday").getTime()));
userList.add(user);
}
for (SysUser sysUser : userList) {
System.out.println(sysUser);
}
} catch (SQLException e) {
// TODO: Auto-generated catch block
e.printStackTrace();
} finally {
if (conn != null) {
// 记住一定要关闭数据库连接
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}