一、数据库查询的常规方法
代码如下:
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.建立连接
connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "root");
//3.创建Statement对象
statement = connection.createStatement();
//4.书写SQL语句
String sql = "select * from user_info";
//5.执行SQL语句
resultSet = statement.executeQuery(sql);
//6.逐条查询数据库中的数据,并把信息并打印到控制台上
while(resultSet.next()) {
String id = resultSet.getString("id");
String userName = resultSet.getString("user_name");
String password = resultSet.getString("password");
System.out.println(id+","+userName+","+password);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
//7.释放资源(注意顺序)
try {
if (resultSet!=null) {
resultSet.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (statement!=null) {
statement.close<