public class JDBCTest {
public static void main(String[] args) throws SQLException {
//1.注册数据库驱动
DriverManager.registerDriver(new Driver());
//2.获取数据库连接
Connection conn= DriverManager.getConnection("jdbc:mysql:///yhdb", "root", "root");
//3.获取传输器
Statement stat= conn.createStatement();
//4.执行SQL
ResultSet rs= stat.executeQuery("select * from tb_door");
//5.遍历结果集
while(rs.next()){
//int id = rs.getInt(1);也可用int类型去获取id
String id = rs.getString(1);
String doorName = rs.getString(2);
String tel = rs.getString(3);
System.out.println(id+" "+doorName+" "+tel);
}
//6.释放资源
rs.close();
stat.close();
conn.close();
}
}
java代码实现连接mysql数据库
最新推荐文章于 2024-05-08 23:48:40 发布