连接oracle数据库，tomcat的数据库连接池的配置

Posted on 2008-07-14 05:35 fcp 阅读(3970) 评论(0) 编辑收藏所属分类: Tomcat 、Oracle

1连接oracle,首先是要有驱动啦。这个网址可以下到
http://www.oracle.com/technology/global/cn/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html

下那个ojdbc6.jar。也可以在这下到http://www.blogjava.net/Files/fcp/ojdbc6.rar，
将这个文件加入你的项目中

2.就直接看代码了

String driver = "oracle.jdbc.driver.OracleDriver";

String url = "jdbc:oracle:thin:@localhost:1521:orcl";

String username = "scott";

String password = "tiger";

String sql = "insert into user(username, password) value(?,?)";

Class.forName(driver); //load oracle driver

Connection conn = DriverManager.getConnection(url, username, password); //get connection

PreparedStatement pstmt = conn.prepareStatement(sql);

pstmt.setString(1,"xxxxxxx");

pstmt.setString(2,"xxxxxxx");

pstmt.executeUpdate(); //execute sql

pstmt.close();

conn.close();

下面就是如何配置Tomcat的数据库连接池了

1，还是先下驱动ojdbc.jar，放在tomcat的lib文件夹下

2，修改tomcat/conf下的context.xml

<?xml version='1.0' encoding='utf-8'?>

<Resource name="jdbc/oracleds" auth="Container" type="javax.sql.DataSource"

maxActive="100" maxIdle="30" maxWait="10000" username="fcp" password="fcp"

driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:STUDB"/>

</Context>

按照自己具体的情况修改数据库程度URL还有用户名等

3修改servlet中的代码

String sql = "select * from stu";

Context context = new InitialContext();

DataSource ds = context.lookup("java:/comp/env/jdbc/oracleds"); //jdbc/oracleds was defined in context.xml, must be same

Connection conn = ds.getConnection(); //get connection

PreparedStatement pstmt = conn.prepareStatement(sql);

ResultSet result = pstmt.executeUpdate(); //execute sql

code for reading records

ds.close();

pstmt.close();

conn.close();


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: 连接oracle数据库，tomcat的数据库连接池的配置 Tomcat的安装和简单配置

我要去google