mysql-connector-java-5.1.7-bin.jar(*主要文件http://dev.mysql.com/downloads/connector/j/5.1.html)
commons-dbutils-1.1.jar(QueryRunner所需包http://commons.apache.org/downloads/download_dbutils.cgi)
实例:
1.把所需包放到Tomcat的lib目录下.
2.修改context.xml(位于Tomcat的conf目录下)
在<Context>...<Context/>之间加入以下代码
<Resource name = "jdbc/mysqlds"//这个地方不能出错,我是因为在这里写为ava:/comp/env/jdbc/mysqlds,所以就出错了
auth = "Container"
type = "javax.sql.DataSource"
maxActive = "100"
maxIdle = "30"
maxWait = "10000"
username = "root"
password = "123456"
driverClassName = "com.mysql.jdbc.Driver"
url = "jdbc:mysql://127.0.0.1/angelsix"/>
3.JSP连接代码
新建JavaBean: DbConn.java
/********************************/
package com.angelsixth;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
public class DbConn {
public static QueryRunner getQueryRunner() {
// 数据源对象可以理解为连接池的管理者,通过他可以获取数据库的连接
DataSource ds = null;
try {
// 通过在context.xml文件,设定的数据源的名字,获取数据源对象
Context context = new InitialContext();
ds = (DataSource) context.lookup("java:/comp/env/jdbc/mysqlds");
} catch (Exception e) {
System.out.println("获取数据源时出错");
}
// DButils中核心类,生成对象时传递数据源对象
QueryRunner qr = new QueryRunner(ds);
return qr;
}
}
/********************************/
连接oracle基本上与mysql类似:
首先tomcat的context.xml的配置文件如下:其他的导包都和mysql一样
注意是oracleds不是oracles
<Resource name = "jdbc/oracleds"
auth = "Container"
type = "javax.sql.DataSource"
maxActive = "100"
maxIdle = "30"
maxWait = "10000"
username = "scott"
password = "tiger"
driverClassName = "oracle.jdbc.driver.OracleDriver"
url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL"/>
public static QueryRunner getRueryRunner(){
DataSource ds = null;
try {
Context context = new InitialContext();
System.out.println("iiii"+context);
// 通过在context.xml文件,设定的数据源对象的名字,获取数据源对象
ds = (DataSource) context.lookup("java:/comp/env/jdbc/oracleds");
} catch (Exception e) {
System.out.println("获取数据源时出错");
}
QueryRunner qr = new QueryRunner(ds);
return qr;
}
调用就是:
QueryRunner queryRunner = DbHelper.getRueryRunner();
String sql = "select * from CMS";
List list = new ArrayList();
try {
list = (List)queryRunner.query(sql, new BeanListHandler(Cms.class));
} catch (SQLException e) {
e.printStackTrace();
}
request.setAttribute("list", list);
request.getRequestDispatcher("/test20110906/success.jsp")
.forward(request, response);