dbutil.java

来自「WAP PUSH后台源码,WAP PUSH后台源码」· Java 代码 · 共 27 行

package push.test;
import java.sql.*;
public class DBUtil {
    private static String driver_class = "oracle.jdbc.driver.OracleDriver";
    private static String driver_url = "jdbc:oracle:thin:@10.29.1.2:1521:ora8";
    private static String driver_username = "wappush";
    private static String driver_password = "pushwap";

    public static Connection getConnection() {
        Connection conn = null;
        try {
            Class.forName(driver_class);
            conn = DriverManager.getConnection(driver_url,driver_username,driver_password);
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
        return conn;
    }

    public static void close(Connection conn) {
        try {
            if (conn !=null)
                conn.close();
        } catch (Exception e) {
        }
    }
}