MySql5数据源配置

最新推荐文章于 2022-08-18 00:36:26 发布

原创最新推荐文章于 2022-08-18 00:36:26 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #stylesheet #string #import #jsp #jdbc

基于struts的一个web-project(试验) 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了如何配置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

写一个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">

    
</head>

<body>
    This is my JSP page. <br>

</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

<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);
    }
   }
}

........