各种数据库连接技术,欢迎讨论
1.jdbc联接数据库;
(1)可以使用资源文件配置数据库信息
(2)可以使用初始化参数配置数据库信息
2.DataSource+JNDI
需要配置data;source信息
这个我不太明白,望指教
3.Hibernate等ORM技术
4.Tomcat中直接配置
疑问:2.JNDI的配置只需在web.xml配置就醒行了吗
4.用的多吗,在程序中怎样调用
[解决办法]
http://topic.csdn.net/t/20021005/16/1073737.html
http://topic.csdn.net/t/20030105/14/1328229.html
JDNI 没用过，到现在为止用过的是ibatis,最基本的jdbc，DataSource
上面是JDNI的两个贴，自己看看吧，希望有帮助
[解决办法]
1. MySQL(http://www.mysql.com)
Class.forName( "org.gjt.mm.mysql.Driver " );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName ", sUsr, sPwd );
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
Class.forName( "org.postgresql.Driver " );
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName ", sUsr, sPwd );
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
Class.forName( "oracle.jdbc.driver.OracleDriver " );
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL ", sUsr, sPwd );
4. Sybase(http://jtds.sourceforge.net)jconn2.jar
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver " );
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638 ", sUsr, sPwd );
//(Default-Username/Password: "dba "/ "sql ")
5. Microsoft SQLServer(http://jtds.sourceforge.net)
Class.forName( "net.sourceforge.jtds.jdbc.Driver " );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master ", sUsr, sPwd );
6. Microsoft SQLServer(http://www.microsoft.com)
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver " );
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master ", sUsr, sPwd );
7. ODBC
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver " );
Connection cn = DriverManager.getConnection( "jdbc:odbc: " + sDsn, sUsr, sPwd );
8.DB2(新添加)
Class.forName( "com.ibm.db2.jdbc.net.DB2Driver ");
String url= "jdbc:db2://192.9.200.108:6789/SAMPLE "
cn = DriverManager.getConnection( url, sUsr, sPwd );
9.Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10
JDBC Name: jTDS
URL: http://jtds.sourceforge.net/
Version: 0.5.1
Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291
语法:
Class.forName( "net.sourceforge.jtds.jdbc.Driver ");
Connection con = DriverManager.getConnection( "jdbc:jtds:sqlserver://host:port/database ", "user ", "password ");
or
Connection con = DriverManager.getConnection( "jdbc:jtds:sybase://host:port/database ", "user ", "password ");
10.Postgresql
JDBC Name: PostgreSQL JDBC
URL: http://jdbc.postgresql.org/
Version: 7.3.3 build 110
Download URL: http://jdbc.postgresql.org/download.html
语法:
Class.forName( "org.postgresql.Driver ");
Connection con=DriverManager.getConnection( "jdbc:postgresql://host:port/database ", "user ", "password ");
11.IBM AS400主机在用的JDBC语法
有装V4R4以上版本的Client Access Express
可以在C:\Program Files\IBM\Client Access\jt400\lib
找到 driver 档案 jt400.zip，并更改扩展名成为 jt400.jar
语法:
java.sql.DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ());
Class.forName( "com.ibm.as400.access.AS400JDBCConnection ");
con = DriverManager.getConnection( "jdbc:as400://IP ", "user ", "password ");
12.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 ";
Lib：jdbcdrv.zip <br> <br> Class.forName( "com.sybase.jdbc.SybDriver " )
url= "jdbc:sybase:Tds:127.0.0.1:2638/asademo ";
SybConnection connection= (SybConnection)DriverManager.getConnection(url, "dba ", "sql ");
13.SAP DB
Class.forName ( "com.sap.dbtech.jdbc.DriverSapDB ");
java.sql.Connection connection = java.sql.DriverManager.getConnection ( "jdbc:sapdb:// " + host + "/ " + database_name,user_name, password)
14.InterBase
String url = "jdbc:interbase://localhost/e:/testbed/database/employee.gdb ";
Class.forName( "interbase.interclient.Driver ");
//Driver d = new interbase.interclient.Driver (); /* this will also work if you do not want the line above */
Connection conn = DriverManager.getConnection( url, "sysdba ", "masterkey " );
15.HSqlDB
url: http://hsqldb.sourceforge.net/
driver: org.hsqldb.jdbcDriver
连接方式有4种，分别为：
con-str（内存）: jdbc:hsqldb.
con-str（本地）: jdbc:hsqldb:/path/to/the/db/dir
con-str（http）: jdbc:hsqldb:http://dbsrv
con-str（hsql）: jdbc:hsqldb:hsql://dbsrv
JDBC的
[解决办法]
DataSource+JNDI 各种WEB服务器配置方法不一样的 说下TOMCAT的吧
1、把数据库JDBC驱动拷贝到%TOMCAT_HOME%/common/lib（必须）和%TOMCAT_HOME%/webapps/yourweb/WEB-INF/lib下这一步大家都知道，不然tomcat无法与数据库连接。
2、修改%TOMCAT_HOME%/conf/server.xml文件,在 <GlobalNamingResources> </GlobalNamingResources> 之间
添加以下内容：
<Resource
name= "jdbc/quickstart "
type= "javax.sql.DataSource "
password= "123456 "
driverClassName= "com.microsoft.jdbc.sqlserver.SQLServerDriver "
maxIdle= "2 "
maxWait= "5000 "
username= "sa "
url= "jdbc:microsoft:sqlserver://localhost;DatabaseName=quickstart "
maxActive= "4 "/>
要是使用ADMIN模块的话直接在里面datasouce
3在%TOMCAT_HOME%/conf/Catalina/localhost下新建一个与你web文件夹同名的xml文件这一步非常重要,如果没有这步就会出错,会出现
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class ' ' for connect URL 'null '
<?xml version= "1.0 " encoding= "UTF-8 "?>
<Context>
<Resource
name= "jdbc/quickstart "
type= "javax.sql.DataSource "
password= "123456 "
driverClassName= "com.microsoft.jdbc.sqlserver.SQLServerDriver "
maxIdle= "2 "
maxWait= "5000 "
username= "sa "
url= "jdbc:microsoft:sqlserver://localhost;DatabaseName=quickstart "
maxActive= "4 "/>
对于TOMCAT5.5使用这个方法
5.0的conf/Catalina/localhost已经存在同名的XML了只需要加入
<ResourceLink global= "jdbc/**** " name= "jdbc/**** " type= "javax.sql.DataSourcer "/>
6.0的conf不存在Catalina/localhost 我是自己建立的这两个文件夹加入的同名XML内容和5.5的一样
网上很多人都说要在 WEB。XML里面加入
<resource-ref>
<description> sqlserverDB Connection </description>
<res-ref-name> jdbc/quickstart </res-ref-name>
<res-type> javax.sql.DataSource </res-type>
<res-auth> Container </res-auth>
</resource-ref>
不过我没加过