12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- <%@ page contentType="text/html; charset=UTF-8" language="java"%>
- <%@ page import="java.util.*"%>
- <%@ page
- import="com.sysmodel.datamodel.xmlmodel.ModelFactory,
- com.sysmodel.datamodel.xmlmodel.impl.MdpModuleImpl,
- com.sysmodel.datamodel.xmlmodel.able.SysModel,
- com.sysmodel.datamodel.xmlmodel.impl.MdpClassImpl"%>
- <%@ page import = "com.persistence.service.SysPersistence"%>
- <%@ page import = "com.persistence.service.PersistenceFactory"%>
- <HTML>
- <HEAD>
- <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <TITLE></TITLE>
- <link rel="stylesheet" href="../../../styles/style.css"
- type="text/css"></link>
- <link rel="stylesheet" href="../../../styles/css.css"
- type="text/css"></link>
- </HEAD>
- <body class="tundra">
- <%
-
- String excute = request.getParameter("excute") == null ? "" : request.getParameter("excute");
- if(!excute.equals("")){
- String sql = request.getParameter("sqlstring");
- out.print(sql);
- SysModel sysmodel = ModelFactory.getSysmodel();
- SysPersistence persistence = PersistenceFactory.getInstance(sysmodel);
- int i = persistence.executeUpdateSQL(99,sql);
- out.print("成功执行了" + i + "条记录");
-
- }
- %>
- <form name="form1" method="post" action="excuteSql.jsp">
- <div id="total">
- <div class="whiteborder">
- <div class="titback">
- <div class="floatleft"><img src="../../../images/index/arrow1.gif" alt="1"
- width="20" height="24" /></div>
- <div class="dropshadow"> 数据库维护</div>
- <div class="clear"></div>
- </div>
- <div class="report">
- <table height="70%" align="center">
- <tr>
- <td>执行的操作</td>
- <td><textarea name="sqlstring" rows="20" cols="120"></textarea></td>
- </tr>
- <tr>
- <td colspan="2" align="center"><input type="submit" name="excute" value="执行"> <input type="reset" value="取消"></td>
- </tr>
- </table>
- </div>
- </div>
- </div>
- </form>
- </BODY>
- </HTML>
|