java 连接各类数据库

Oracle/i/i数据库（thin模式）

ClassforName(oraclejdbcdriverOracleDriver)newInstance();

String url=jdbc:oracle:thin:@localhost::orcl;

//orcl为数据库的SID

String user=test;

String password=test;

Connection conn= DriverManagergetConnection(urluserpassword);

DB数据库

ClassforName(comibmdbjdbcappDBDriver )newInstance();

String url=jdbc:db://localhost:/sample;

//sample为你的数据库名

String user=admin;

String password=;

Connection conn= DriverManagergetConnection(urluserpassword);

Sql Server/数据库

ClassforName(commicrosoftjdbcsqlserverSQLServerDriver)newInstance();

String url=jdbc:microsoft:sqlserver://localhost:;DatabaseName=mydb;

//mydb为数据库

String user=sa;

String password=;

Connection conn= DriverManagergetConnection(urluserpassword);

Sybase数据库

ClassforName(comsybasejdbcSybDriver)newInstance();

String url = jdbc:sybase:Tds:localhost:/myDB;

//myDB为你的数据库名

Properties sysProps = SystemgetProperties();

SysPropsput(useruserid);

SysPropsput(passworduser_password);

Connection conn= DriverManagergetConnection(url SysProps);

Informix数据库

ClassforName(rmixjdbcIfxDriver)newInstance();

String url =

jdbc:informixsqli://:/myDB:INFORMIXSERVER=myserver;

user=testuser;password=testpassword;

//myDB为数据库名

Connection conn= DriverManagergetConnection(url);

MySQL数据库

ClassforName(orggjtmmmysqlDriver)newInstance();

String url =jdbc:mysql://localhost/myDB?user=soft&password=soft&useUnicode=true&characterEncoding=_

//myDB为数据库名

Connection conn= DriverManagergetConnection(url);

PostgreSQL数据库

ClassforName(orgpostgresqlDriver)newInstance();

String url =jdbc:postgresql://localhost/myDB

//myDB为数据库名

String user=myuser;

String password=mypassword;

Connection conn= DriverManagergetConnection(urluserpassword);

JDBCODBC桥

ClassforName(sunjdbcodbcJdbcOdbcDriver);

Connection con=DriverManagergetConnection(jdbc:odbc:jsp);

jsp为建立的odbc数据源名事先要先将SQL server的表设置为数据源在管理工具数据源odbc里用系统DNS添加

Oracle/i/i数据库（thin模式）

//import javasql*;

ClassforName(oraclejdbcdriverOracleDriver)newInstance();

String url=jdbc:oracle:thin:@localhost::orcl; //orcl为数据库的SID

String user=test;

String password=test;

Connection conn= DriverManagergetConnection(urluserpassword);

Statement stmtNew=conncreateStatement();

DB数据库

//import javasql*;

ClassforName(comibmdbjdbcappDBDriver )newInstance();

String url=jdbc:db://localhost:/sample; //sample为你的数据库名

String user=admin;

String password=;

Connection conn= DriverManagergetConnection(urluserpassword);

Statement stmtNew=conncreateStatement();

Sql Server/数据库

//import javasql*;

ClassforName(commicrosoftsqlserverjdbcSQLServerDriver)newInstance();

//String url=jdbc:microsoft:sqlserver://localhost:;DatabaseName=db; //

String url=jdbc:sqlserver://localhost:;DatabaseName=db; //

//db为数据库名

String user=sa;

String password=;

Connection conn= DriverManagergetConnection(urluserpassword);

Statement stmtNew=conncreateStatement();

Sybase数据库

//import javasql*;

ClassforName(comsybasejdbcSybDriver)newInstance();

String url = jdbc:sybase:Tds:localhost:/myDB;//myDB为你的数据库名

Properties sysProps = SystemgetProperties();

SysPropsput(useruserid);

SysPropsput(passworduser_password);

Connection conn= DriverManagergetConnection(url SysProps);

Statement stmtNew=conncreateStatement();

Informix数据库

//import javasql*;

ClassforName(rmixjdbcIfxDriver)newInstance();

String url = jdbc:informixsqli://:/myDB:INFORMIXSERVER=myserver;

user=testuser;password=testpassword; //myDB为数据库名

Connection conn= DriverManagergetConnection(url);

Statement stmtNew=conncreateStatement();

MySQL数据库

//import javasql*;

//ClassforName(orggjtmmmysqlDriver)newInstance();

ClassforName(commysqljdbcDriver);

//String url =jdbc:mysql://localhost/myDB?user=soft&password=soft&useUnicode=true&characterEncoding=_;

String url =jdbc:mysql://localhost:/myDB;

//myDB为数据库名

Connection conn= DriverManagergetConnection(urlrootroot);

Statement stmtNew=conncreateStatement();

PostgreSQL数据库

//import javasql*;

ClassforName(orgpostgresqlDriver)newInstance();

String url =jdbc:postgresql://localhost/myDB //myDB为数据库名

String user=myuser;

String password=mypassword;

Connection conn= DriverManagergetConnection(urluserpassword);

Statement stmtNew=conncreateStatement();

access数据库直连用ODBC的

//import javasql*;

ClassforName(sunjdbcodbcJdbcOdbcDriver) ;

String url=jdbc:odbc:Driver={MicroSoft Access Driver (*mdb)};DBQ=+applicationgetRealPath(/Data/ReportDemomdb);

Connection conn = DriverManagergetConnection(urlsa);

Statement stmtNew=conncreateStatement();

程序计时

long time=SystemcurrentTimeMillis();

long time=SystemcurrentTimeMillis();

long interval=timetime;

延时

try {

Threadsleep(IntegerParse(%%));

} catch(InterruptedException e) {

eprintStackTrace();

}

连接Excel文件

//import javasql*;

ClassforName(sunjdbcodbcJdbcOdbcDriver);

String url = jdbc:odbc:driver={Microsoft Excel Driver (*xls)};DBQ=D:\\myDBxls; // 不设置数据源

String user=myuser;

String password=mypassword;

Connection conn= DriverManagergetConnection(urluserpassword);

Statement stmtNew=conncreateStatement();