- public class MyJDBC {
- public static void main(String[] args)
- {
- // 数据库JDBC驱动地址
- String driverManageString = null;
- // 数据库连接地址
- String url = null;
- // 数据连接密码
- String password = null;
- // 数据库连接用户名
- String user = null;
- try {
- // 加载数据库JDBC连接恭驱动
- Class.forName(driverManageString);
- // 创建数据库连接
- Connection connection = DriverManager.getConnection(url, user, password);
- // 创建一个执行SQL语句的工具接口
- Statement stmt = connection.createStatement();
- ResultSet rs = stmt.executeQuery(" select id, name, pwd from custmer");
- //获取查询出的数据
- while (rs.next()) {
- System.out.println(rs.getObject(1));
- }
- // 创建一个预编译的SQL语句工具接口
- PreparedStatement pstmt = connection.prepareStatement(" select id, name, pwd from custmer where id = ?");
- pstmt.setObject(0, new Object());
- // 结果集,返回SQL查询后生成的一张数据表
- ResultSet prs = pstmt.executeQuery();
- while (prs.next()) {
- System.out.println(rs.getObject(1));
- }
- connection.close();
- rs = null;
- prs = null;
- }
- catch (ClassNotFoundException e)
- {
- e.printStackTrace();
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
- }
- }
Java语言JDBC数据库
于 2018-08-21 14:54:22 首次发布