JDBC访问数据库的步骤——实例一

 

1.导入java.sql包——

                            2.加载并注册驱动——

                                                        3.创建一个Connection对象——

                                                                                                   4.创建一个Statement对象——

 JDBC访问数据库的步骤  ：                                                                                     5.执行语句——

                                                                                                           6.使用ResultSet对象——

                                                                          7.关闭ResultSet对象——

                                        8.关闭statement对象——

                      9.关闭链接——

10.结束

 ☆需要的导入的jar包：sqljdbc.jar

 

常用数据库URL地址的写法：
Oracle写法：jdbc:oracle:thin:@localhost:1521:sid
SqlServer—jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=sid
MySql—jdbc:mysql://localhost:3306/sid
Mysql的url地址的简写形式： jdbc:mysql:///sid

常用数据库DRIVER的写法：

MySql—：com.mysql.jdbc.Driver

Oracle—：oracle.jdbc.driver.OracleDriver

Sqlserver—：com.microsoft.sqlserver.jdbc.SQLServerDriver（2005版本及以后）

                    com.microsoft.jdbc.sqlserver.SQLServerDriver（2000版本）

实例一：

import java.sql.Connection;
import java.sql.DriverManager;

public class DBUtil {

	private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=test";
	private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static final String USERNAME = "sa";
	private static final String PASSWORD = "pass";
	static{
		try{	
			//加载并注册驱动程序
			Class.forName(DRIVER);
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	public static Connection getConnection(){
		Connection con = null;
		try{
			//创建一个Connection对象,通过驱动管理器获得链接
			con = DriverManager.getConnection(URL,USERNAME,PASSWORD);
		}catch(Exception e){
			e.printStackTrace();
		}
		return con;
		
	}