templatesave.jsp

sms开发主要用于短信平台开发与应用45445倒萨啊打12221答案的第

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.util.*,java.sql.*,DBstep.iDBManager2000.*" %>
<%
String mRecordID=request.getParameter("RecordID");
String mFileName=new String(request.getParameter("FileName").getBytes("8859_1"));
String mDescript=new String(request.getParameter("Descript").getBytes("8859_1"));

DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
if (DbaObj.OpenConnection())
{
  java.sql.PreparedStatement prestmt=null;
  String mSql="Update Template_File Set FileName = '"+ mFileName +"',Descript = '"+ mDescript +"' Where RecordID='"+ mRecordID +"'";

  prestmt =DbaObj.Conn.prepareStatement(mSql);
  DbaObj.Conn.setAutoCommit(true) ;
  prestmt.execute();
  DbaObj.Conn.commit();
  prestmt.close();
}
DbaObj.CloseConnection();

response.sendRedirect("TemplateList.jsp");
%>