mysql jdbc 封装_jdbc封装写法

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();

}

}

}