直连数据库

直连数据库
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")