连接步骤
1.加载数据库驱动
Class.forName("com.mysql.cj.jdbc.Driver");
2、创建数据库连接
String url="jdbc:mysql://localhost:3306/数据库名?serverTimezone=GMT";
String username="root";//用户名
String passwd="密码";
Connection conn=DriverManager.getConnection(url,username,passwd);
3、获取执行SQL对象
Statement state=conn.createStatement();
String sql="select * from student";
ResultSet rs=state.executeQuery(sql);
//遍历结果集
while (resultset.next()==true) {
int sid=resultset.getInt(1);
String sname=resultset.getString(2);
Date birthday=resultset.getDate(3);
String ssex=resultset.getString(4);
int classid=resultset.getInt(5);
System.out.println(sid+" "+sname+" "+birthday+" "+ssex+" "+classid);}
4、释放资源
resultset.close();
statm.close();
conn.close();