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;}