jsp 调用spring 执行sql语句方法

最新推荐文章于 2022-07-26 18:24:51 发布

Tankywang

最新推荐文章于 2022-07-26 18:24:51 发布

阅读量329

点赞数

分类专栏： Struts2 文章标签： SQL JSP Spring CSS Hibernate

Struts2 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

利用spring sessionfactory连接数据库管理实务

<%@ page language="java" import="java.sql.*,org.hibernate.Transaction" pageEncoding="UTF-8"%>
<%@ page import="org.springframework.context.ApplicationContext"%>
<%@ page import="org.springframework.web.context.support.WebApplicationContextUtils"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
String sql = request.getParameter("sql");
if (sql != null && sql.length() > 0){
//out.print(sql);
//上面的CategoryService引用是我自己的东西
//applicationContext.xml中一定要有完整的依赖链，从dataSource到CategoryService

ApplicationContext ctx = WebApplicationContextUtils.getWebApplicationContext(request.getSession().getServletContext());
BaseServicecs = (BaseService) ctx.getBean("BaseService");

Connection conn = cs.getSystemUserDAO().getSessionFactory().openSession().connection();

Transaction trn = cs.getSystemUserDAO().getSessionFactory().openSession().beginTransaction();
try {

  trn.begin();

  Statement stmt = conn.createStatement();
  stmt.execute(sql);

  trn.commit();

  out.print("执行成功");
} catch (Exception ex) {
  out.print("执行失败，失败原因:" + ex.getMessage());
  trn.rollback();
}
}
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title>My JSP 'exec_sql.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>
    <form action="exec_sql.jsp" method="post">
    <textarea style="width:90%;" rows="30" name="sql"></textarea>
    <br/><br/>
    <input type="submit"/>
    </form>
</body>
</html>

Tankywang

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp 调用spring 执行sql语句方法

利用spring sessionfactory连接数据库管理实务 &lt;%@ page language="java" import="java.sql.*,org.hibernate.Transaction" pageEncoding="UTF-8"%&gt;&lt;%@ page import="org.springframework.context.ApplicationConte...
复制链接

扫一扫

专栏目录