WebRoot/fangchan/fangchan_add.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
String sql="";
int row=0;
String fcm=(String)request.getParameter("fcm");
String hx=(String)request.getParameter("hx");
String mj=(String)request.getParameter("mj");
String sj=(String)request.getParameter("sj");
String dz=(String)request.getParameter("dz");
String kfs=(String)request.getParameter("kfs");
String lxdh=(String)request.getParameter("lxdh");
String kpsj=(String)request.getParameter("kpsj");
String wy=(String)request.getParameter("wy");
String lxid=(String)request.getParameter("lxid");
sql="insert into fangchan(fcm,hx,mj,sj,dz,kfs,lxdh,kpsj,wy,lxid) values('"+fcm+"','"+hx+"','"+mj+"','"+sj+"','"+dz+"','"+kfs+"','"+lxdh+"','"+kpsj+"','"+wy+"','"+lxid+"')";
try{
row=db.executeUpdate(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('房产添加成功');");
out.println("window.location='fangchanadd.jsp'");
out.println("</script>");
}else{
out.println("<script>");
out.println("alert('房产添加失败');");
out.println("window.location='fangchanadd.jsp'");
out.println("</script>");
}
db.close();
%>