直连数据库
public boolean createConn_Direct(String drv,String url,string usr,String pwd){
try{
if(connAction.equals("GET")){
throw new SQLException("数据库已连接,无须重连!");}
Class.forName(drv).newInstance();
conn = DriverManager.getConnection(url,usr,pwd);
connAction ="GET";
connType=false;
showConnNUM();
}catch(ClassNotFoundException ec){
ds.log("直连数据库时出错;/r/n错误为:"+ec);}
catch(SQLException es){
ds.log("直连数据库时出错;/r/n错误为:"+es);}
catch(Exception ex){
ds.log("直连数据库时出错;/r/n错误为:"+ex);}
if (conn == null) return false;
else return true;
}
oracle数据库连接的代码:
drv 数据库驱动名,例如: oracle.jdbc.driver.OracleDriver
url 数据库连接地址,例如: jdbc:oracle:thin:@192.168.0.254:1521:tigger
usr 数据库用户名,例如: test
pwd 数据库密码,例如: test
对于sql server的连接,可以做如下调用:
createConn_Direct("com.microsoft.jdbc.sqlserver.SQLServerDriver",
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","sa")
对于Access的连接(name为配置的ODBC的别名,用户名和密码可以为空.)
creatConn_Direct("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:NAME","","")
对于MySql的连接(第二个参数的结尾参数是为了支持中文)
createConn_Direct("org.gjt.mm.mysql.Driver",
"jdbc:mysql://localhost/mysql?useUnicode=true&characterEncoding=8859_1","root","")
对于DB2的连接:
createConn_Direct("com.ibm.db2.jdbc.app.DB2Driver","jdbc:db2://localhost:5000/sample","test","test")
对于informix的连接:
createConn_Direct("com.informix.jdbc.IfxDriver",
"jdbc:informix-sqli://123.45.67.89.1533/testDB:INFORMIXSERVER=myserver","test","test");
对于Sybase的连接:
createConn_Direct("com.sybase.jdbc.sybDriver","jdbc:sybase:Tds:localhost:5007/tsdatea","test","test")
对于PostgreSQL的连接:
createConn_Direct("org.postgresql.Driver","jdbc:postgresql://localhost/soft","test","test")