jsp数据更新代码

jsp数据更新代码

<%
String Aforder=(String)session.getAttribute("Aforder");
%>

  站点信息<% if(Aforder.equals("1")){ %> |  信息修改<% } %>

<%
if (request.getParameter("SiteName") != null)
{
String SiteName=new String(request.getParameter("SiteName").getBytes("iso-8859-1"));
String SiteUrl=new String(request.getParameter("SiteUrl").getBytes("iso-8859-1"));
String SiteTitle=new String(request.getParameter("SiteTitle").getBytes("iso-8859-1"));
String ftel=new String(request.getParameter("ftel").getBytes("iso-8859-1"));
String ffax=new String(request.getParameter("ffax").getBytes("iso-8859-1"));
String address=new String(request.getParameter("address").getBytes("iso-8859-1"));
String fcode=new String(request.getParameter("fcode").getBytes("iso-8859-1"));
String email=new String(request.getParameter("email").getBytes("iso-8859-1"));
String MetaKeywords=new String(request.getParameter("MetaKeywords").getBytes("iso-8859-1"));
String MetaDescription=new String(request.getParameter("MetaDescription").getBytes("iso-8859-1"));

Statement stmt_ConfigUpdate=conn.createStatement();
String Sql_U="update hl_SiteConfig set fSiteName='"+SiteName+"',fSiteUrl='"+SiteUrl+"',fSiteTitle='"+SiteTitle+"',ftel='"+ftel+"',ffax='"+ffax+"',address='"+address+"',email='"+email+"',fcode='"+fcode+"',fMetaKeywords='"+MetaKeywords+"',fMetaDescription='"+MetaDescription+"' where ID=1";
int gai=stmt_ConfigUpdate.executeUpdate(Sql_U);

stmt_ConfigUpdate.close();
 if (gai>0)
 {
  out.print("

["+ SiteName +"]网站配置修改成功

Statement stmt_SiteConfig=conn.createStatement();
String Sql="Select * from hl_SiteConfig";
ResultSet RsSiteConfig=stmt_SiteConfig.executeQuery(Sql);
RsSiteConfig.next();
%>