- <html>
- <head>
- <title>
- 保存脚本
- </title>
- <style type="text/css">
- body{
- margin:0px;
- background-image:url(images/login_02.jpg);
- background-repeat:repeat-x;
- font:14px Tahoma;
- color:#023951;
- }
- input{
- width:122px;
- height:20px;
- border:1px solid #023951;
- color:#035C83;
- line-height:20px;
- }
- </style>
- </head>
- <%@ page language="java" contentType="text/html; charset=gb2312"
- import = "java.sql.*,com.codestudio.util.*" %>
- <body>
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td background="images/bg.jpg" width="353"><img src="images/default/banner.jpg" width="353" height="40" /></td>
- </tr>
- </table>
- <table border="1" width="400">
- <% String tare = request.getParameter( "textfield3" );
- String tare2 = request.getParameter( "textfield2" );
- SQLManager myMan = SQLManager.getInstance();
- Connection myConn= myMan.requestConnection();
- Statement stmt = myConn.createStatement();
- stmt.executeUpdate("update sale_plan set Sale_Script='" +tare + "' where Sale_Plan_Id ="+tare2);
- ResultSet myResultSet= stmt.executeQuery("select * from SALE_PLAN where Sale_Plan_Id ="+tare2);
- if (myResultSet != null)
- {
- while (myResultSet.next())
- {
- String cust_id=myResultSet.getString("Sale_Plan_Id");
- String plan_id=myResultSet.getString("Sale_Plan_Name");
- String state =myResultSet.getString("Sale_Script");
- %>
- <tr>
- <td><%=cust_id %></td>
- <td><%=plan_id %></td>
- <td><%=state %></td>
- </tr>
- <%
- }
- }
- stmt.close();
- myMan.returnConnection(myConn);
- %>
- <h1>保存成功</h1>
- </table>
- </body>
- </html>