Java语言JDBC数据库连接操作

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