register.jsp

JSP+ORACLE网站开发实例（下）.rar

              <OPTION>请在以下列表中选择</OPTION>
			  <OPTION value=北京市  <%=selected(rs.getString("area"),"北京市")%>>北京市 
                    <OPTION value=天津市 <%=selected(rs.getString("area"),"天津市")%>>天津市 
                    <OPTION value=上海市 <%=selected(rs.getString("area"),"上海市")%>>上海市 
                    <OPTION value=重庆市 <%=selected(rs.getString("area"),"重庆市")%>>重庆市 
                    <OPTION value=安徽省 <%=selected(rs.getString("area"),"安徽省")%>>安徽省 
                    <OPTION value=福建省 <%=selected(rs.getString("area"),"福建省")%>>福建省 
                    <OPTION value=甘肃省 <%=selected(rs.getString("area"),"甘肃省")%>>甘肃省 
                    <OPTION value=广东省 <%=selected(rs.getString("area"),"广东省")%>>广东省 
                    <OPTION value=四川省 <%=selected(rs.getString("area"),"四川省")%>>四川省 
                    <OPTION value=贵州省 <%=selected(rs.getString("area"),"贵州省")%>>贵州省 
                    <OPTION value=湖北省 <%=selected(rs.getString("area"),"湖北省")%>>湖北省 
                    <OPTION value=湖南省 <%=selected(rs.getString("area"),"湖南省")%>>湖南省 
                    <OPTION value=吉林省 <%=selected(rs.getString("area"),"吉林省")%>>吉林省 
                    <OPTION value=江苏省 <%=selected(rs.getString("area"),"江苏省")%>>江苏省 
                    <OPTION value=江西省 <%=selected(rs.getString("area"),"江西省")%>>江西省 
                    <OPTION value=辽宁省 <%=selected(rs.getString("area"),"辽宁省")%>>辽宁省 
                    <OPTION value=青海省 <%=selected(rs.getString("area"),"青海省")%>>青海省 
                    <OPTION value=山东省 <%=selected(rs.getString("area"),"山东省")%>>山东省 
                    <OPTION value=山西省 <%=selected(rs.getString("area"),"山西省")%>>山西省 
                    <OPTION value=陕西省 <%=selected(rs.getString("area"),"陕西省")%>>陕西省 
                    <OPTION value=云南省 <%=selected(rs.getString("area"),"云南省")%>>云南省 
                    <OPTION value=浙江省 <%=selected(rs.getString("area"),"浙江省")%>>浙江省 
                    <OPTION value=黑龙江省 <%=selected(rs.getString("area"),"黑龙江省")%>>黑龙江省 
                    
</SELECT></B>
            </td>                 
          </tr>
          <tr>
            <td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
              &nbsp;成立日期:<input type="text" name="fdate" size="10" maxLength=10 value="<%=replacenull(rs.getString("fdate"))%>">
            </td>                 
          </tr>
          <tr>
          
            <td width="100%" height="28" valign="bottom">
              &nbsp;注册资金;<input type="text" name="fund" size="6" maxLength=6 value="<%=replacenull(rs.getString("fund"))%>">万人民币</td>                 
          </tr>
          <tr>
            <td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
              &nbsp;通讯地址:<input type="text" name="address" size="30" maxLength=40 value="<%=replacenull(rs.getString("address"))%>">
            </td>                 
          </tr>
          <tr>
            <td width="100%" height="28" valign="bottom">
              &nbsp;邮政编码;<input type="text" name="zip" size="6" size="6" maxLength=6 value="<%=replacenull(rs.getString("zip"))%>">
            </td>                 
          </tr>
          <tr>
            <td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
              <p align="left">&nbsp;联系人:&nbsp; <input type="text" name="pname" size="20" maxLength=20 value="<%=replacenull(rs.getString("pname"))%>">    
              </p></td>                 
          </tr>
          <tr>
            <td width="100%" height="28" valign="bottom">
              &nbsp;联系电话:<input type="text" name="phone" size="20" maxLength=40 value="<%=replacenull(rs.getString("phone"))%>">
            </td>                 
          </tr>
          <tr>
            <td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
              <p align="left">&nbsp;传真号码:<input type="text" name="fax" size="20" maxLength=40 value="<%=replacenull(rs.getString("fax"))%>">
              </p></td>                 
          </tr>
          <tr>
            <td width="100%" height="28" valign="bottom">
              &nbsp;电子信箱:<input type="text" name="email" size="20" maxLength=40 value="<%=replacenull(rs.getString("email"))%>">
            </td>                 
          </tr>
          <tr>
          <td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
           &nbsp;公司网站:<input type="text" name="http" size="20" maxLength=40  value="<%=replacenull(rs.getString("http"))%>">
            </td>                 
          </tr>
          <tr>
            <td width="100%" valign="top">
              <p align="center"><br>
              公司简介:<br>
              <br>
              			   
   <textarea rows="9" name="jianj" cols="62" style="background-color: #F3F3F3; color: #000060"><%=replacenull(rs.getString("jianj"))%></textarea>    
              </p>
              <p align="center"><input type="button" value="确 定"    <%if(rs.getString("cname")!=null){ %>onClick="checkmod()"<%}else{%>onClick="check()"<%}%>>
              <br>
              <br>
              </p></td>
          </tr>
        </table>
        </div>
      </td>
  <center>
      <td width="1" height="325" valign="top" bgcolor="#00006A"></td>
      <td width="122" height="325" valign="top" bgcolor="#F3F3F3">　</td>
    </tr>
    <tr>
      <td width="778" height="1" valign="top" colspan="5" bgcolor="#53BEB0"> 
        <p align="center"> </td>
    </tr>
    <tr>
      <td width="778" height="3" valign="top" colspan="5">
      <p align="center">
      </td>
    </tr>
    <tr>
      <td width="778" height="7" valign="top" colspan="5">
      <p align="center"><script language="javascript" src="../inc/copyright.js"></script>
      </td>
    </tr>
    <tr>
      <td width="778" height="3" valign="top" colspan="5">
      </td>
    </tr>
  </table>
  </center>
</div>
</form>
				  <% }%>
</body>

</html>
<% 
request.setCharacterEncoding("GB2312");
String pname =request.getParameter("pname");
if(pname!=null){

String cxz =request.getParameter("cxz");
String area =request.getParameter("area");
String fdate =request.getParameter("fdate");
String fund =request.getParameter("fund");
String cname =request.getParameter("cname");
String address =request.getParameter("address");
String zip =request.getParameter("zip");
String phone =request.getParameter("phone");
String fax =request.getParameter("fax");
String email =request.getParameter("email");
String http =request.getParameter("http");
String jianj =request.getParameter("jianj");
String trade =request.getParameter("trade");

if(fund==null){
	fund="未知";
}
if(cname==null){
	cname=rs.getString("cname");
}
if(fax==null){
	fax="未知";
}
if(http==null){
	http="http://";
}
stmt.executeUpdate("update scott.company set trade='"+trade+"',cxz='"+cxz+"',area='"+area+"',fdate='"+fdate+"' ,cname='"+cname+"',fund='"+fund+"' ,pname='"+pname+"' ,address='"+address+"',zip='"+zip+"',phone='"+phone+"',fax='"+fax+"',email='"+email+"',jianj='"+jianj+"',http='"+http+"'  where uname='"+uname+"'");
out.print("<SCRIPT language=JavaScript>alert('修改成功！');");
out.print("javascript:document.location='main.jsp';</SCRIPT>");
}%>