jdbc官网"http://www.oracle.com/technetwork/java/javase/jdbc/index.html"

属于oracle官网javase目录下

 

package org.zwh.jdbcdemo.demo;

 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
//jdbc封装写法
public class Demo2 {
 
static {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// SQLServer
// String driverName = "oracle.jdbc.driver.OracleDriver";//Oracle
// String driverName = "com.mysql.jdbc.Driver";//MySQL
try {
Class.forName(driverName);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
 
static String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName = sample";// SQLServer
// String url = "jdbc:oracle:thin:@127.0.0.1:1521:sample";//Oracle
// String url = "jdbc:mysql://localhost:3306/myuser";//MySQL
 
static String username = "******";
static String password = "******";
 
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
 
public static void close(ResultSet rs, Statement stmt, Connection conn) {
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (stmt != null)
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
 
public static void close(Object obj) {
try {
if (obj instanceof ResultSet) {
((ResultSet) obj).close();
} else if (obj instanceof Statement) {
((Statement) obj).close();
} else if (obj instanceof Connection) {
((Connection) obj).close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
 
}