1. 加载驱动
Class.forName("com.mysql.jdbc.Driver");
2. 创建连接对象
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url, user, password);
3. 创建执行sql语句的对象,传参。
Statement statement = conn.createStatement();
4. 执行sql语句,获取返回的结果集。
String sql = " select * from test";
ResultSet resultSet = statement.executeQuery(sql);
5. 解析结果集
while(resultSet.next()) {
resultSet.getInt(1);
resultSet.getString(2);
}
6.释放资源
resultSet.close();
statement.close();
conn.close();
7.代码示例:
public static void main(String[] args) throws Exception {
// 1. 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 2.创建连接对象
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url, user, password);
// 3. 创建执行sql语句的对象,传参
Statement statement = conn.createStatement();
// 4.执行sql语句
String sql = " select * from test";
ResultSet resultSet = statement.executeQuery(sql);
// 5. 解析结果集
while(resultSet.next()) {
resultSet.getInt(1);
resultSet.getString(2);
}
// 6.释放资源
resultSet.close();
statement.close();
conn.close();
}