java连接数据库语句

1．Oracle8/8i/9i数据库（thin模式）Class.forName(oracle.jdbc.driver.OracleDriver).newInstance();Stringurl=jdbc:oracle:thin:@localhost:1521:orcl;//orcl为数据库的SIDStringuser=test;Stringpassword=test;Connectionconn=DriverManager.getConnection(url,user,password);2．DB2数据库Class.forName(com.ibm.db2.jdbc.app.DB2Driver).newInstance();Stringurl=jdbc:db2://localhost:5000/sample;//sample为你的数据库名Stringuser=admin;Stringpassword=;Connectionconn=DriverManager.getConnection(url,user,password);3．SqlServer7.0/2000数据库Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver).newInstance();Stringurl=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb;//mydb为数据库Stringuser=sa;Stringpassword=;Connectionconn=DriverManager.getConnection(url,user,password);4．Sybase数据库Class.forName(com.sybase.jdbc.SybDriver).newInstance();Stringurl=jdbc:sybase:Tds:localhost:5007/myDB;//myDB为你的数据库名PropertiessysProps=System.getProperties();SysProps.put(user,userid);SysProps.put(password,user_password);Connectionconn=DriverManager.getConnection(url,SysProps);5．Informix数据库Class.forName(com.informix.jdbc.IfxDriver).newInstance();Stringurl=jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword;//myDB为数据库名Connectionconn=DriverManager.getConnection(url);6．MySQL数据库Class.forName(org.gjt.mm.mysql.Driver).newInstance();Stringurl=jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1;//myDB为数据库名Connectionconn=DriverManager.getConnection(url);7．PostgreSQL数据库Class.forName(org.postgresql.Driver).newInstance();Stringurl=jdbc:postgresql://localhost/myDB;//myDB为数据库名Stringuser=myuser;Stringpassword=mypassword;Connectionconn=DriverManager.getConnection(url,user,password);8．access数据库直连用ODBC的Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);Stringurl=jdbc:odbc:Driver={MicroSoftAccessDriver(*.mdb)};DBQ=+application.getRealPath(/Data/ReportDemo.mdb);Connectionconn=DriverManager.getConnection(url,,);StatementstmtNew=conn.createStatement();