- 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();
- }
-
- }
- }
