MySql5数据源配置

本文介绍了如何配置MySQL5数据源,包括下载MySQL Connector/J,部署jar文件,编写JSP测试页面进行数据库连接测试,以及在Struts框架中使用DBCP数据连接池的步骤,最后展示了如何在Action中获取并关闭数据库连接。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

1>mysql5驱动下载:

http://dev.mysql.com/downloads/ 下Drivers and Connectors子栏中的MySQL Connector/J 5.0 ;

将mysql-connector-java-5.0.0-beta-bin.jar部署到/WEB-INF/lib下,

2>数据库连接测试

写一个测试页TestConnect.jsp

 4>

写一个jsp测试页TestConnect.jsp


<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" %>
<%@page  import="org.gjt.mm.mysql.Driver" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
  <head>
    <title>My JSP 'TestConnect.jsp' starting page</title>
   
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
   
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
 
  <body>
    This is my JSP page. <br>

     <table border=1 cellspacing=0 width=100%>
     <tr><th>登录名</th><th>昵称</th><th>密码</th></tr>
<%
    String url=
      "jdbc:mysql://localhost:3306/"+
      "trial?user=root&password=mysql";
    Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
    Connection con=DriverManager.getConnection(url);
    Statement state = con.createStatement();
    String sql="SELECT * FROM user ;";
    ResultSet rs=state.executeQuery(sql);
    String _id,_nm,_pw;
    while(rs.next()){
    _id=rs.getString("userid");
    _nm=rs.getString("username");
    _pw=rs.getString("password");
   
 %>
<tr>
<td><%=_id%></td>
<td><%=_nm%></td>
<td><%=_pw%></td>
<tr>
<%
}
%>  
</table>

  </body>
</html>

3>决定使用dbcp在struts下配置数据连接池,

他需要下载3个包:

http://apache.justdn.org/jakarta/commons/dbcp/binaries/commons-dbcp-1.2.1.zip

 http://archive.apache.org/dist/jakarta/commons/pool/commons-pool-current-src.zip

http://mirror.vmmatrix.net/apache/jakarta/commons/collections/binaries/commons-collections-3.1.zip

解压后分别将commons-dbcp-1.2.1.jar,commons-pool-1.2.jar和commons-collections-3.1.jar全部拷贝到/WEB-INF/lib目录下

4>编辑struts-comfig.xml,添加data-sou

<!-- MYSQL -->
  <data-source type="org.apache.commons.dbcp.BasicDataSource" key="DB_trial">
    <set-property
      property="driverClassName"
      value="org.gjt.mm.mysql.Driver" />
    <set-property
      property="url"
      value="jdbc:mysql://localhost:3306/trial" />
    <set-property
      property="username"
      value="root" />
    <set-property
      property="password"
      value="mysql" />
    <set-property
      property="maxActive"
      value="10" />
    <set-property
      property="maxWait"
      value="500" />
    <set-property
      property="defaultAutoCommit"
      value="false" />
    <set-property
      property="defaultReadOnly"
      value="false" />

</data-source>

5>编写测试代码

........

public ActionForward
       execute(ActionMapping mapping,
               ActionForm form,
               HttpServletRequest request,
               HttpServletResponse response) throws Exception
{
javax.sql.DataSource dataSource;
java.sql.Connection myConnection;
try {
  dataSource = getDataSource(request,"DB_trial");
  myConnection = dataSource.getConnection();
  // do what you wish with myConnection

    Statement state = myConnection.createStatement();
    String sql="SELECT * FROM user ;";
    ResultSet rs=state.executeQuery(sql);

.......

 } catch (SQLException sqle) {
    getServlet().log("Connection.process", sqle);
} finally {
    //enclose this in a finally block to make
    //sure the connection is closed
    try {
       myConnection.close();
    } catch (SQLException e) {
       getServlet().log("Connection.close", e);
    }
   }
}

........

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值