1.注册数据库驱动类:
public static void forName(String className)throws ClassNotFoundException
例子:
Class.forName(“com.mysql.jdbc.Driver”);
2.创建连接对象:
1) public static Connection getConnection(String url)throws SQLException
2) public static Connection getConnection(String url,String name,String password)
throws SQLException
3).public static Connection getConnection(String url, Properties info)throws SQLException
例子:
Connection con=DriverManager.getConnection( );
3.三种访问数据库 url方式:
1.本地MySQL URL: jdbc:mysql://localhost:3306/databaseName
2.Java DB数据库连接的URL: jdbc:derby:[databaseName][;attribute=value]*
可通过最后的选项来操作数据库
3.MySQL连接数据库:
jdbc:mysql://[host][,failoverhost…][:port]/[database][?propertyName1][=propertyValue1]
[&propertyName2][=propertyValue2]…
database_url=jdbc:mysql://localhost/dbnameuser=root&password=1234
4.使用createStatement()方法创建Statement 对象:
public Statement createStatement()throws SQLException
例子:
Statement stmt=con.createStatement();
执行查询:
public ResultSet executeQuery(String sql)throws SQLException
例子:
ResultSet rs=stmt.executeQuery("select * from emp");
while(rs.next()){
System.out.println(rs.getInt(1)+" "+rs.getString(2));
}
5.关闭connection对象:通过关闭connection对象,Statement和ResultSet会自动关闭
public void close()throws SQLException
例子:
con.close();