加载正确的驱动程序后,就可以使用JDBC提供的API连接和访问数据库了。首先使用DriverManager类的getConnection函数与数据库建立连接。该函数有3个重载函数,也就是说有3种方式获取数据库连接。
方法一:getConnection(String url)
方法函数:
public static Connection getConnection(String url)
具体代码如下
String jdbcURL = "jdbc:mysql:///codingwhy?user=root&password=&useUnicode=true&characterEncoding=utf-8"; Class.forName("com.mysql.jdbc.Driver",2); Connection conn = DriverManager.getConnection(jdbcURL,2); String selectSql = "select * from t_user"; PreparedStatement preparedStatement = conn.prepareStatement(selectSql,2); ResultSet rs = preparedStatement.executeQuery(,2); while(rs.next()){ String name = rs.getString("name",2); System.out.println(name,2); }
方法二:getConnection(String url,String user, String password)
方法函数:
public static Connection getConnection(String url, String user, String password)
核心代码如下(其他代码请参考代码1中的代码)
String jdbcURL = "jdbc:mysql:///codingwhy?useUnicode=true&characterEncoding=utf-8"; String jdbcUser = "root"; String jdbcPassword = ""; Connection conn = DriverManager.getConnection(jdbcURL,jdbcUser,jdbcPassword,2);
方法3:getConnection(String url, java.util.Properties info)
方法函数:
public static Connection getConnection(String url, java.util.Properties info)
核心代码如下
String jdbcURL = "jdbc:mysql:///codingwhy?useUnicode=true&characterEncoding=utf-8"; String jdbcUser = "root"; String jdbcPassword = ""; java.util.Properties jdbcInfo = new java.util.Properties(,2); jdbcInfo.put("user", jdbcUser,2); jdbcInfo.put("passowrd", jdbcPassword,2); Class.forName("com.mysql.jdbc.Driver",2); Connection conn = DriverManager.getConnection(jdbcURL,jdbcInfo,2);