resin版本:resin-3.0.17
mysql 驱动版本:mysql-connector-java-3.1.12-bin
jdk版本:j2sdk1.4.2_07
配置方法:
1.找到resin安装目录下/conf:
打开resin.conf
找到如下地方:更改相应参数
<!--
- Sample database pool configuration
-
- The JDBC name is java:comp/env/jdbc/test
-
-->
<database>
<jndi-name>jdbc/test</jndi-name>
<driver type="com.mysql.jdbc.Driver">
<url>jdbc:mysql://localhost:3306/test</url>
<user>root</user>
<password>123456</password>
</driver>
<prepared-statement-cache-size>8</prepared-statement-cache-size>
<max-connections>20</max-connections>
<max-idle-time>30s</max-idle-time>
</database>
2.把mysql-connector-java-3.1.12-bin复制到resin安装目录/lib下
3.重启resin
4.写测试程序:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.Connection"%>
<%@page import="javax.naming.Context"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%
Connection conn = null;
DataSource ds = null;
ResultSet rs =null;
Statement stmt = null;
Context initCtx = new InitialContext();
ds =(DataSource)initCtx.lookup("java:comp/env/jdbc/test");
if(ds!=null){
out.println("已经获得DataSource!");
out.println("<br>");
conn = ds.getConnection();
try{
stmt = conn.createStatement();
String sql ="select * from images";
rs = stmt.executeQuery(sql);
out.println("以下是从数据库中读取出来的数据:<br>");
while(rs.next()){
out.println("<br>");
out.println(rs.getString("name"));
}
}catch(Exception ex){
ex.printStackTrace();
}finally{
conn.close();
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
}
}
%>