81,091
社区成员
发帖
与我相关
我的任务
分享
<%@ page contentType="text/html; charset=GBK" %>package com.util;
/* 数据访问组件 */
import java.io.*;
import java.util.*;
import java.sql.*;
public class A{
private static DBPool instance = null;
private Connection _getConnection(){
try{
String sDBDriver = null;
String sConnection = null;
String sUser = null;
String sPassword = null;
sDBDriver ="sun.jdbc.odbc.JdbcOdbcDriver";
sConnection = "jdbc:odbc:dbm";
sUser ="";
sPassword = "";
Properties pr = new Properties();
pr.put("user",sUser);
pr.put("password",sPassword);
pr.put("characterEncoding", "GB2312");
pr.put("useUnicode", "TRUE");
Class.forName(sDBDriver).newInstance();
return DriverManager.getConnection(sConnection,pr);
}
catch(Exception se){
System.out.println(se);
return null;
}
}
//释放资源
public static void dbClose(Connection conn,PreparedStatement ps,ResultSet rs)
throws SQLException
{
rs.close();
ps.close();
conn.close();
}
public static void main(String[] args) {
System.out.println(DBPool.getConnection());
}
}