struts连接数据库

最新推荐文章于 2021-12-08 23:21:54 发布

goby2008

最新推荐文章于 2021-12-08 23:21:54 发布

阅读量1.7k

点赞数 1

分类专栏： struts 文章标签： struts 数据库 import null swt jdbc

本文链接：https://blog.csdn.net/goby2008/article/details/764495

版权

struts 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

struts连接数据库 <script language="javascript" type="text/javascript">document.title="struts连接数据库 - "+document.title</script>

struts-config.xml添加

在<struts-config>里面加上

    
    <data-sources>
        <data-source key="org.apache.struts.action.DATA_SOURCE" type="org.apache.struts.util.GenericDataSource">
            <set-property property="password" value="shiwtshiwt" />
            <set-property property="minCount" value="" />
            <set-property property="maxCount" value="" />
            <set-property property="user" value="swt" />
            <set-property property="driverClass" value="org.gjt.mm.mysql.Driver" />
            <set-property property="description" value="" />
            <set-property property="url" value="jdbc:mysql://localhost:3306/smsgroup?autoReconnect=true" />
            <set-property property="readOnly" value="false" />
            <set-property property="autoCommit" value="false" />
            <set-property property="loginTimeout" value="" />
        </data-source>
    </data-sources>

在你的Action类的excute即可执行以下连接数据库代码

import javax.servlet.ServletContext;
import javax.sql.*;

Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   String tel = "tel";
   ServletContext context = this.servlet.getServletContext();
   DataSource dataSource = (DataSource)context.getAttribute("org.apache.struts.action.DATA_SOURCE");

   try {
    conn = dataSource.getConnection();
    stmt = conn.createStatement();
    //rs = stmt.executeQuery("select * from user where age = 24");
    rs = stmt.executeQuery("select * from c_13760827783 where id = 6");
    if( rs.next() ){
     tel = rs.getString("name");
     System.out.print(tel);
    }
   }catch (SQLException e) {
    System.err.println(e.getMessage());
   }