JDBC_note

JDBC_note

JDBC （Java Database Connectivity ）

java中的数据存储技术：

1；JDBC直接访问数据库

2：第三方O/R工具，Hibernate，ibatis等框架连接

JDBC是java访问数据库的基石，其他技术都是对JDBC的封装。

package cn.itcast.mysql.connection;

import java.sql.Connection; import java.sql.Driver; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Properties;

import org.junit.Test;

//实现得到与数据库连接的Connection实现类对象的三种方式

public class TestConnection {
	@Test
	public void testGetConnection(){
		try {
			Driver driver = new com.mysql.jdbc.Driver();
			String url = "jdbc:mysql://localhost:3306/ermao";
			Properties info = new Properties();
			info.put("user", "root");
			info.put("password", "root");
			Connection  connection = driver.connect(url, info);
			System.out.println(connection);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	@Test
	public void testGetConnection2(){
		
		try {
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			String url = "jdbc:mysql://localhost:3306/ermao";
			String user = "root";
			String password = "root";
			Connection conn = DriverManager.getConnection(url, user, password);
			System.out.println(conn);
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	@Test
	
	public void testGetConnection3(){
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://localhost:3306/ermao";
			String user = "root";
			String password = "root";  
			Connection conn = DriverManager.getConnection(url, user, password);
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
}

转载于:https://my.oschina.net/u/1997259/blog/356011