锘??xml version="1.0" encoding="utf-8" standalone="yes"?>
<%String title="<SPAN class='large'>浜轟簨綆$悊鏁版嵁鎻愪氦</SPAN>";%>
<%@ include file="../include/connHeader.jsp"%>
<%
聽(tīng)//鍙栬緭鍏ュ?br />聽(tīng)String PKID=request.getParameter("PKID");//涓婚敭
聽(tīng)String NAME=request.getParameter("NAME");//濮撳悕
聽(tīng)String SEX=request.getParameter("SEX");//鎬у埆
聽(tīng)String AGE=request.getParameter("AGE");//鍑虹敓騫存湀
聽(tīng)String strTel=request.getParameter("aaa");//鑱旂郴鐢?shù)璇?br />聽(tīng)String ADDR=request.getParameter("ADDR");//鍦板潃
聽(tīng)
聽(tīng)String url="../src/appRSGLInMod.jsp";//璺寵漿欏甸潰
聽(tīng)String sql="";
聽(tīng)//鎻愪氦鍒版暟鎹簱
聽(tīng)if(PKID==null||PKID.equals("")){
聽(tīng)聽(tīng)PKID=Tool.getSeqId("TBRSGL",1,9999,conn);
聽(tīng)聽(tīng)sql="insert into TBRSGL(PKID,NAME,SEX,tel,AGE,ADDR)"
聽(tīng)聽(tīng)+ "values("+PKID+",'"+NAME+"','"+SEX+"','"+strTel+"','"+AGE+"','"+ADDR+"')";
聽(tīng)聽(tīng)
聽(tīng)}else{
聽(tīng)聽(tīng)sql="update tbrsgl set name='"+NAME+"',sex='"+SEX+"',age='"+AGE+"',"+
聽(tīng)聽(tīng)"tel='"+strTel+"',ADD='"+ADDR+"' where pkid=+PKID";
聽(tīng)聽(tīng)url+="?PKID="+PKID;//璺寵漿欏甸潰
聽(tīng)}
聽(tīng)System.out.println(sql);
聽(tīng)JDBC.executeUpdate(sql);
%>
<script language="JavaScript">
alert('浣犳垚鍔熸彁浜や簡(jiǎn)浜轟簨綆$悊鏁版嵁錛?);
window.location="<%=url%>";
</script>
<%@ include file="../include/connHeader.jsp"%>
榪欐璇彞閲屾湁涓や釜閿欒錛屽ソ璞¢兘鏄敱<%@ include file="../include/connHeader.jsp"%>榪欏彞寮曞彂鐨勯敊璇紝璇峰ぇ瀹跺府鎴戞敼涓嬪晩錛佽阿璋簡(jiǎn)錛屾垜鏄釜鑿滈笩錛岃嚜瀛﹁繖涓墠娌″嚑澶╋紒