加载正确的驱动程序后,就可以使用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);