(以oralce为例,假设你应用的上下文根是/test,jndi是jdbc/test)
<Context path="/test" docBase="E:\test" >
<Resource name="jdbc/test" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/test">
<parameter>
<name>username</name>
<value>system</value>
</parameter>
<parameter>
<name>password</name>
<value>manager</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.0.27:1521:titan</value>
</parameter>
</ResourceParams>
</Context>
一、直连接数据库1 Java 连接 Oralce
[java] view plaincopy
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance()
String url="jdbc:oracle:thin:@localhost:1521:orcl"
Connection conn= DriverManager.getConnection(url,user,password)
2 Java 连接 MySQL
[java] view plaincopy
Class.forName("org.gjt.mm.mysql.Driver ").newInstance()
String URL = "jdbc:mysql://localhost/test"
Connection conn= DriverManager.getConnection(url,user,password)
3 Java 连接SQLServer
[java] view plaincopy
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance()
String URL =” jdbc:microsoft:sqlserver://localhost:1433DatabaseName=pubs"
Connection conn= DriverManager.getConnection(url,user,password)
4 Java 连接DB2
[java] view plaincopy
Class.forName(“com.ibm.db2.jdbc.app.DB2Driver ").newInstance()
String URL =”jdbc:db2://localhost:5000/sample"
Connection conn= DriverManager.getConnection(url,user,password)
5 Java 连接 Infomix
[java] view plaincopy
Class.forName("com.informix.jdbc.IfxDriver ").newInstance()
String URL =jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver
Connection conn= DriverManager.getConnection(url,user,password)
6 Java 连接 SyBase
[java] view plaincopy
Class.forName("com.sybase.jdbc.SybDriver").newInstance()
Properties sysProps = System.getProperties()
SysProps.put("user","userid")
SysProps.put("password","user_password")
Connection conn= DriverManager.getConnection(url, SysProps)
7 Java连接 PostgreSQL
[java] view plaincopy
Class.forName("org.postgresql.Driver").newInstance()
String url ="jdbc:postgresql://localhost/soft"
Connection conn= DriverManager.getConnection(url,user,password)
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)