JDBC访问数据库及其他数据库连接方式

package com.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class TestJDBC {//数据库连接字符串public static final StringDBURL="jdbc:sqlserver://127.0.0.1:1433;databaseName=MyOffice"; //数据驱动加载字符串public static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";//数据库登录名public static final String DBUSER="sa";//数据库登录密码public static final String DBPASS="123456";/*** @param args*/public static void main(String[] args) throws Exception{Connection conn=null;Statement stmt=null;Class.forName(DBDRIVER);//加载驱动conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);//填写url,user,passwordInsertUserInfo(conn, stmt);if(null!=stmt && !(stmt.isClosed()))stmt.close();if(null!=conn && !(conn.isClosed()))conn.close();}//向数据库插入一条信息public static void InsertUserInfo(Connection conn,Statement stmt) throws SQLException{String sql="insert intoerInfo(UserId,UserName,Password,DepartId,Gender,Ro leId,UserStateId)ALUES('liqi142','张三','123456',1,1,1,1)";stmt=conn.createStatement();//实例化Statement对象stmt.executeUpdate(sql);stmt.close();conn.close();System.out.println("OK");}}其它数据连接语句：/**MySql数据库连接**/String userName="root";String userPwd="123123";String dbName="test";Class.forName("com.mysql.jdbc.Driver").newInstance();Stringurl="jdbc:mysql:localhost/"+dbName+"?user="+userName+"&password ="+userPwd;//dbName为数据库名String user="system";//用户名String pwd="admin";//密码java.sql.Connection conn=DriverManager.getConnection(url,user,pwd);/**Oracle数据库连接**/Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();String url="jdbc:oracle:thin:@localhost:1521:orcl"//orcl为数据库的SID （实例名）String user="system";//用户名String pwd="admin";//密码java.sql.Connection conn=DriverManager.getConnection(url,user,pwd);/**Sybase数据库连接**/Class.forName("com.sybase.jdbc.SybDriver").newInstance();String url="jdbc:sybase:Tds:localhost:5007/erp"//erp为数据库名Properties sysProps=System.getProperties();sysProps.put("user","sa");sysProps.put("password","");java.sql.Connection conn=DriverManager.getConnection(url,user,pwd); /**DB2数据库连接**/Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance(); String url="jdbc:db2://localhost:5000/sample"//sample为数据库名String user="admin";String pwd="";java.sql.Connection conn=DriverManager.getConnection(url,user,pwd);/**Informix数据库连接**/Class.forName("rmix.jdbc.IfxDriver").newInstance();Stringurl="jdbc:informix-sqli://localhost:1533/test:INFORMIXSERVER=infser ver;"//test为数据库名String user="admin";String pwd="";java.sql.Connection conn=DriverManager.getConnection(url,user,pwd);/**Sql Server 2000数据库连接**/Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newIns tance();Stringurl="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=db"//db为数据库名String user="sa";String pwd="111";java.sql.Connection conn=DriverManager.getConnection(url,user,pwd);/**Sql Server 2005数据库连接**/Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newIns tance();String url="jdbc:sqlserver://localhost:1433;DataBaseName=db"//db为数据库名String user="sa";String pwd="111";java.sql.Connection conn=DriverManager.getConnection(url,user,pwd);/**PostgreSQL数据库连接**/Class.forName("org.postgresql.Driver").newInstance();String url="jdbc:postgresql://localhost/netdb"//netdb为数据库名String user="root";String pwd="123112";java.sql.Connection conn=DriverManager.getConnection(url,user,pwd);/**HSQLDB(Server) **/Class.forName("org.hsqldb.jdbcDriver");java.sql.Connection con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost:port/mydb"," username","password");/**access**/Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;java.sql.Connectioncon=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=mdb的文件路径","username","password");。