Jdbc连接数据库大全
来源:互联网 发布:proface触摸屏软件 编辑:程序博客网 时间:2024/05/16 07:50
oracle
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Stringurl="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
Connection conn=DriverManager.getConnection(url,user,password);
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
//MS sql server
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Stringurl="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
//db2
Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();
Stringurl="jdbc:db2://localhost:5000/sample";
String user="admin";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
//informix
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
String url = "jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword";
Connection conn=DriverManager.getConnection(url);
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
//sybase
Class.forName("com.sybase.jdbc.SybDriver").newInstance();
String url ="jdbc:sybase:Tds:localhost:5007/tsdata";
Properties sysProps =System.getProperties();
SysProps.put("user","userid");
SysProps.put("password","user_password");
Connection conn=DriverManager.getConnection(url, SysProps);
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
//mysql
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
Connection conn=DriverManager.getConnection(url);
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
//postgresql
Class.forName("org.postgresql.Driver").newInstance();
String url="jdbc:postgresql://localhost/soft"
String user="myuser";
String password="mypassword";
Connection conn=DriverManager.getConnection(url,user,password);
Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
//access
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn =DriverManager.getConnection("jdbc:odbc:shnxn","user","");
Statement stmt = conn.createStatement();
ResultSet rs =stmt.executeQuery("SELECT * FROM member");
1、Oracle8/8i/9i数据库(thin模式)
Class.forName(“oracle.jdbc.driver.OracleDriver“).newInstance();
String url=“jdbc:oracle:thin:@localhost:1521:orcl“; //orcl为数据库的SID
String user=“test“;
String password=“test“;
Connection conn=DriverManager.getConnection(url,user,password);
2、DB2数据库
Class.forName(“com.ibm.db2.jdbc.app.DB2Driver“).newInstance();
String url=“jdbc:db2://localhost:5000/sample“; //sample为你的数据库名
String user=“admin“;
String password=““;
Connection conn=DriverManager.getConnection(url,user,password);
3、Sql Server7.0/2000数据库
Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver“).newInstance();
Stringurl=“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb“;
//mydb为数据库
String user=“sa“;
String password=““;
Connection conn=DriverManager.getConnection(url,user,password);
4、Sybase数据库
Class.forName(“com.sybase.jdbc.SybDriver“).newInstance();
String url =“ jdbc:sybase:Tds:localhost:5007/myDB“;//myDB为你的数据库名
Properties sysProps =System.getProperties();
SysProps.put(“user“,“userid“);
SysProps.put(“password“,“user_password“);
Connection conn=DriverManager.getConnection(url, SysProps);
5、Informix数据库
Class.forName(“com.informix.jdbc.IfxDriver“).newInstance();
String url = “jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;
user=testuser;password=testpassword“; //myDB为数据库名
Connection conn=DriverManager.getConnection(url);
6、MySQL数据库
Class.forName(“org.gjt.mm.mysql.Driver“).newInstance();
String url =“jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1“
//myDB为数据库名
Connection conn=DriverManager.getConnection(url);
7、PostgreSQL数据库
Class.forName(“org.postgresql.Driver“).newInstance();
String url =“jdbc:postgresql://localhost/myDB“ //myDB为数据库名
String user=“myuser“;
String password=“mypassword“;
Connection conn=DriverManager.getConnection(url,user,password);
8、access数据库直连用ODBC的
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“);
String url=“jdbc:odbc:Driver={MicroSoftAccess Driver (*.mdb)};DBQ=“+application.getRealPath(“/Data/ReportDemo.mdb“);
Connection conn =DriverManager.getConnection(url,““,“”);
Statement stmtNew=conn.createStatement() ;
- JDBC连接数据库大全
- JDBC连接数据库大全
- jdbc连接数据库大全
- jdbc连接数据库大全
- JDBC连接数据库大全
- JDBC连接数据库大全
- JDBC连接数据库大全
- JDBC连接数据库大全
- JDBC连接数据库大全
- jdbc连接数据库大全
- jdbc连接数据库大全
- jdbc连接数据库大全
- jdbc连接数据库大全
- JDBC连接数据库大全
- JDBC连接数据库大全
- Jdbc连接数据库大全
- JDBC连接数据库大全
- jdbc连接数据库大全(转载)
- UML图之二——类图
- Firefox去除youku,ku6,iqiyi,tudou视频前广告(黑屏)
- ios修改屏幕保护程序的一点想法
- 全面解析JDBC
- Cheatsheet: 2013 05.01 ~ 05.14
- Jdbc连接数据库大全
- 嵌入式学习之Nand Flash编程
- Python目录操作
- 强引用 软引用 弱引用 虚引用的区别
- 个人对微信的评价《微信的发展》
- Android 的网络编程(16)-网络多线程断点续传下载
- linux solaris自动挂载
- 字典树
- 修改编译生成的exe/dll名字