你是打算直接使用JDBC还是DAO框架(如Hibernate)
下面是使用JDBC连接Oracle数据库的代码:
public class DbConnection {
private static final String DBDRIVER = "oraclejdbcdriverOracleDriver";
private static final String DBURL = "jdbc:oracle:thin:@localhost:1521:DateBaseName";
private static final String DBUSER = "user";
private static final String DBPASS = "password";
private Connection conn = null;
public DbConnection() {
try {
ClassforName(DBDRIVER);// 加载驱动
thisconn = DriverManagergetConnection(DBURL, DBUSER, DBPASS);// 获得连接
} catch (Exception e) {
}
}
public Connection getConn() {
return conn;
}
public void setConn(Connection conn) {
thisconn = conn;
}
public Connection getConnection() {
return thisconn;
}
public void close() {
if (thisconn != null) {
try {
thisconnclose();
} catch (SQLException e) {
eprintStackTrace();
}
}
}
}
如果使用DAO,请参考DAO文档,但是那四个属性始终是需要的,你可以保留
给你一个能看懂的。
记得给兄我多加点分。谢谢了啊。
# 1、Oracle8/8i/9i数据库(thin模式)
# ClassforName("oraclejdbcdriverOracleDriver")newInstance();
# String url="jdbc:oracle:thin:@localhost:1521:orcl";
# //orcl为数据库的SID
# String user="test";
# String password="test";
# Connection conn= DriverManagergetConnection(url,user,password);
#
# 2、DB2数据库
# ClassforName("comibmdb2jdbcappDB2Driver ")newInstance();
# String url="jdbc:db2://localhost:5000/sample";
# //sample为你的数据库名
# String user="admin";
# String password="";
# Connection conn= DriverManagergetConnection(url,user,password);
#
# 3、Sql Server70/2000数据库
# ClassforName("commicrosoftjdbcsqlserverSQLServerDriver")newInstance();
# String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
# //mydb为数据库
# String user="sa";
# String password="";
# Connection conn= DriverManagergetConnection(url,user,password);
#
# 4、Sybase数据库
# ClassforName("comsybasejdbcSybDriver")newInstance();
# String url =" jdbc:sybase:Tds:localhost:5007/myDB";
# //myDB为你的数据库名
# Properties sysProps = SystemgetProperties();
# SysPropsput("user","userid");
# SysPropsput("password","user_password");
# Connection conn= DriverManagergetConnection(url, SysProps);
#
# 5、Informix数据库
# ClassforName("cominformixjdbcIfxDriver")newInstance(); String url =
# "jdbc:informix-sqli://123456789:1533/myDB:INFORMIXSERVER=myserver;
# user=testuser;password=testpassword";
# //myDB为数据库名
# Connection conn= DriverManagergetConnection(url);
#
# 6、MySQL数据库
# ClassforName("orggjtmmmysqlDriver")newInstance();
# String url ="jdbc:mysql://localhost/myDBuser=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
# //myDB为数据库名
# Connection conn= DriverManagergetConnection(url);
#
# 7、PostgreSQL数据库
# ClassforName("orgpostgresqlDriver")newInstance();
# String url ="jdbc:postgresql://localhost/myDB"
# //myDB为数据库名
# String user="myuser";
# String password="mypassword";
# Connection conn= DriverManagergetConnection(url,user,password);
用spring框架连接oracle数据库可以通过配置数据源的方式:
Spring 数据库连接配置
oracle为例来说明:
<bean id="dataSource" class="orgapachecommonsdbcpBasicDataSource" destroy-method="close">
<property name="driverClassName" value="oraclejdbcdriverOracleDriver" />
<property name="url" value="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=1921681101)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)(SERVER=DEDICATED)))" />
<property name="username" value="rootl" />
<property name="password" value="1234" />
</bean>
扩展其他数据库:
二 DB2
<bean id="dataSource" class="orgapachecommonsdbcpBasicDataSource" destroy-method="close">
<property name="driverClassName" value="comibmdb2jdbcappDB2Driver" />
<property name="url" value="jdbc:db2:thin:@localhost:5000/testDB" />
<property name="username" value="rootl" />
<property name="password" value="1234" />
</bean>
三 SQL Server
<bean id="dataSource" class="orgapachecommonsdbcpBasicDataSource" destroy-method="close">
<property name="driverClassName" value="commicrosoftjdbcsqlserverSQLServerDriver" />
<property name="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName = testDB" />
<property name="username" value="rootl" />
<property name="password" value="1234" />
</bean>
三 MySQL
<bean id="dataSource" class="orgapachecommonsdbcpBasicDataSource" destroy-method="close">
<property name="driverClassName" value="orgpostgresqlDriver" />
<property name="url" value="jdbc:postgresql://localhost/ testDB" />
<property name="username" value="rootl" />
<property name="password" value="1234" />
</bean>
orgapachecommonsdbcpBasicDataSource 需要commons-pooljar,commons-dbcp-122jar,commons-collections-32jar三个JAR包
("jdbc:oracle:thin:@localhost:1521/XE","hr","111")
//服务器地址:localhost,端口号:1521,数据库实例名字:XE
//用户名字和密码是自己建立的"hr" "111"
以上就是关于jdk版本安装的是jdk1.6.0_13 tomcat版本是tomcat6.0 oracle数据库安装的oracle10G jsp编程中如何连接oracl全部的内容,包括:jdk版本安装的是jdk1.6.0_13 tomcat版本是tomcat6.0 oracle数据库安装的oracle10G jsp编程中如何连接oracl、java 连接oracle、jsp,用spring框架连接oracle数据库等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)