package cn.sh.daniel.test;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.PreparedStatement;
public class Test1 {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
PreparedStatement preparedStatement = null;
try {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 创建连接
String url = "jdbc:mysql://127.0.0.1:3306/management";
String username = "root";
String password = "root123";
connection = DriverManager.getConnection(url, username, password);
String sql = "SELECT * FROM user WHERE id = ?";
// 获取Statement对象
preparedStatement = connection.prepareStatement(sql);
// 设置参数,2个参数,下标、数据,下标是从1开始
preparedStatement.setString(1, "2");
// 执行sql
resultSet = preparedStatement.executeQuery();
// 处理结果集
while (resultSet.next()) {
System.out.println("username : " + resultSet.getString("userName"));
System.out.println("name : " + resultSet.getString("userAge"));
System.out.println("age : " + resultSet.getString("userAddress"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
// 关闭连接,释放资源
try {
if (null != resultSet) {
resultSet.close();
}
if (null != preparedStatement) {
preparedStatement.close();
}
if (null != connection) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.PreparedStatement;
public class Test1 {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
PreparedStatement preparedStatement = null;
try {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 创建连接
String url = "jdbc:mysql://127.0.0.1:3306/management";
String username = "root";
String password = "root123";
connection = DriverManager.getConnection(url, username, password);
String sql = "SELECT * FROM user WHERE id = ?";
// 获取Statement对象
preparedStatement = connection.prepareStatement(sql);
// 设置参数,2个参数,下标、数据,下标是从1开始
preparedStatement.setString(1, "2");
// 执行sql
resultSet = preparedStatement.executeQuery();
// 处理结果集
while (resultSet.next()) {
System.out.println("username : " + resultSet.getString("userName"));
System.out.println("name : " + resultSet.getString("userAge"));
System.out.println("age : " + resultSet.getString("userAddress"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
// 关闭连接,释放资源
try {
if (null != resultSet) {
resultSet.close();
}
if (null != preparedStatement) {
preparedStatement.close();
}
if (null != connection) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}