产品中心
public static void testJDBCSelect() throws SQLException {
//1创建DataSource对象
DataSource dataSource = new MysqlDataSource();
//2连接数据库
((MysqlDataSource)dataSource).setURL("jdbc:mysql://127.0.0.1:3306/java_5_31?characterEncoding=utf-8&useSSL=true");
((MysqlDataSource)dataSource).setUser("root");
((MysqlDataSource)dataSource).setPassword("listen");
Connection connection = dataSource.getConnection();
//3拼接sql
String sql = "select * from student";
PreparedStatement statement = connection.prepareStatement(sql);
//4执行sql
ResultSet resultSet = statement.executeQuery();
//5遍历得到的集合
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
int classId = resultSet.getInt("classId");
System.out.println("id " + id + " name " + name + " classId " + classId);
}
//6关闭资源
resultSet.close();
statement.close();
connection.close();
}到此这篇关于MySQL详解进行JDBC编程与增删改查方法的文章就介绍到这了,更多相关MySQL JDBC编程内容请搜索以前的文章或继续浏览下面的相关文章希望大家以后多多支持！
