这里列举了JDBC连接Oracle 、 SQLServer 、MySQL 三种 数据库
1、Oracle连接(导入classes12.jar 包)
public static Connection getConnection(){
Connection conn=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");//加载驱动
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","UserName","Password");//连接数据库
}catch(Exception e){
e.printStackTrace();
}
return conn;//返回连接对象
}
2、SQLServer 连接(导入sqljdbc.jar 包)
public static Connection getConnection(){
Connection conn=null;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;datebase=DBName","UserName","Password");
}catch(Exception e){
e.printStackTrace();
}
return conn;
}
3、MySql连接数(导入 mysql-connector-java-5.0.8.jar 包)
public static Connection getConnection(){
Connection conn=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/datebaseName", "userName", "password");
}catch(Execution e){
e.printStackTrace();
}
return conn;
}
//操作完之后记得都要断开连接(释放资源)
public static void close(ResultSer rs,Statement st,Connection com){
try{
if(rs!=null) rs.close();
if(st!=null) st.close();
if(con!=null) con.close();
}catch(){
e.printStackTrace();
}
}