jdbc连接数据库(记录)
包:mysql-connector-java
代码:
package com.ly975.jdbc;
import java.sql.*;
public class TestJDBC {
public static void main(String[] args) throws SQLException {
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//创建连接
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/login_user", "root", "*****");
//创建sql语句执行对象
statement = connection.createStatement();
//执行语句
resultSet = statement.executeQuery("SELECT * FROM login_user");
//操作resultSet结构集
while (resultSet.next()) {
String username=resultSet.getString(1);
String password=resultSet.getString(2);
System.out.println("username="+username+ " password="+password);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
connection.close();
statement.close();
resultSet.close();
}
}
}