建议再执行一遍新增,这样数据库就有两条数据,方便观察结果。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class SelectDate {
private static String url = "jdbc:mysql://localhost:3306/easilyj"; // 数据库地址
private static String userName = "root"; // 数据库用户名
private static String passWord = "123456"; // 数据库密码
private static Connection conn = null;
public static Connection getConnection() {
if (null == conn) {
try {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 创建数据库连接
conn = DriverManager.getConnection(url, userName, passWord);
} catch (Exception e) {
e.printStackTrace();
}
}
return conn;
}
public static void main(String[] args) {
// 准备sql
String sql = "select * from user";
Connection conn = getConnection();
PreparedStatement pst = null;
try {
// 创建预编译语句
pst = conn.prepareStatement(sql);
// 执行SQL
ResultSet rst = pst.executeQuery();
while (rst.next()) {
System.out.print(rst.getInt("user_id"));
System.out.print(rst.getString("user_name"));
System.out.println(rst.getString("user_password"));
}
System.out.println("JDBC 查询成功");
// 关闭资源
pst.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
System.out.println("JDBC 查询失败");
}
}
}运行结果:
1大海绵654321 2小海绵123456 JDBC 查询成功
编程那点事
