📄 redata.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="law.user" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="law.parameter" %>
<%!
public String codeString(String s){
String str=s;
try{
byte b[]=str.getBytes("ISO-8859-1");
str=new String (b);
return str;
}catch(Exception e){return str;}
}
%>
<%!
public String formatString(String s){
//add format way here
return s;
}
%>
<html>
<head><title>redata</title></head>
<body>
<center>
<jsp:useBean id="log" class="law.user" scope="session"/>
<jsp:useBean id="redataPara" class="law.parameter" scope="session"/>
<%
if(log.getLogin().equals("true")){
String submit=request.getParameter("submit");
if(submit==null){
long num=0;
String strnum=request.getParameter("num");
if(strnum==null)strnum="";
if(strnum.equals(""))
strnum="无";
try{
num=Long.valueOf(strnum).longValue();
}catch(NumberFormatException e){
num=0;
}
if(num<1){
%>
<jsp:include page="head.txt"/>
<%
out.print("<font color=#FF0000>找不到您需要的资料，请与管理员联系。");
}
else
{
String time,id;
String data1,data2,data3,data4,data5,data6,data7,data8,data9,data10,
data11,data12,data13,data14,data15,data16,data17,data18,data19,data20,
data21,data22,data23;
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:law","","");
sql=con.createStatement();
String condition="SELECT * FROM data where num="+num;
rs=sql.executeQuery(condition);
if(rs.next()){
time=rs.getString("time");
id=rs.getString("id");
data1=rs.getString("data1");
data2=rs.getString("data2");
data3=rs.getString("data3");
data4=rs.getString("data4");
data5=rs.getString("data5");
data6=rs.getString("data6");
data7=rs.getString("data7");
data8=rs.getString("data8");
data9=rs.getString("data9");
data10=rs.getString("data10");
data11=rs.getString("data11");
data12=rs.getString("data12");
data13=rs.getString("data13");
data14=rs.getString("data14");
data15=rs.getString("data15");
data16=rs.getString("data16");
data17=rs.getString("data17");
data18=rs.getString("data18");
data19=rs.getString("data19");
data20=rs.getString("data20");
data21=rs.getString("data21");
data22=rs.getString("data22");
data23=rs.getString("data23");
%>
<center>
<table width=800>
<tr>
<td width=100 align=center></td>
<td width=100 align=center><a href="showitem.jsp">浏览资料</a></td>
<td width=100 align=center><a href="search.jsp">查询资料</a></td>
<td width=100 align=center><a href="insert.jsp">插入资料</a></td>
<td width=100 align=center><a href="redata.jsp?num= <%=num%> ">修改资料</a></td>
<td width=100 align=center><a href="delete.jsp?num= <%=num%> ">删除资料</a></td>
<td width=100 align=center><a href="logout.jsp">注销登录</a></td>
<td width=100 align=center></td>
</tr>
</table>
</center>
<center>
<b><font size="5">修改合同信息
</font></b>
<form action="redata.jsp" method="post" name="form">
<input type="hidden" name="num" value=<%=num%> >
<table border="1" width="800">
<tr><td><table width=800>
<td align="left" width=400>委托人（抵押人）姓名：<input type="text" name="data1" size=19 maxlength=19 value=<%=data1%> ></td>
<td align="left" width=400><input type="text" name="data2" size=4 maxlength=9 value=<%=data2%> >年
<input type="text" name="data3" size=2 maxlength=7 value=<%=data3%> >月
<input type="text" name="data4" size=2 maxlength=6 value=<%=data4%> >日出生</td>
</table></td></tr>
<tr><td><table width=800>
<td>
<p align="left" width=400>身份证号码：<input type="text" name="data5" size=32 maxlength=32 value=<%=data5%> ></td>
<td>
<p align="left" width=400>联系电话： <input type="text" name="data6" size=22 maxlength=22 value=<%=data6%> ></td>
</table></td></tr>
<tr><td><table width=800>
<td align="left" width=400>委托人（共有人）姓名：<input type="text" name="data7" size=19 maxlength=19 value=<%=data7%> ></td>
<td align="left" width=400><input type="text" name="data8" size=4 maxlength=9 value=<%=data8%> >年
<input type="text" name="data9" size=2 maxlength=7 value=<%=data9%> >月
<input type="text" name="data10" size=2 maxlength=6 value=<%=data10%> >日出生</td>
</table></td></tr>
<tr><td><table width=800>
<td>
<p align="left" width=400>身份证号码：<input type="text" name="data11" size=32 maxlength=32 value=<%=data11%> ></td>
<td>
<p align="left" width=400>联系电话： <input type="text" name="data12" size=22 maxlength=22 value=<%=data12%> ></td>
</table></td></tr>
<tr><td><table width=800>
<td align="left" width=400>受托人姓名：<input type="text" name="data13" size=29 maxlength=29 value=<%=data13%> ></td>
<td align="left" width=400>受托人单位：<input type="text" name="data14" size=23 maxlength=23 value=<%=data14%> ></td>
</table></td></tr>
<tr><td><table width=800>
<td>
<p align="left" width=400>身份证号码：<input type="text" name="data15" size=32 maxlength=32 value=<%=data15%> ></td>
<td>
<p align="left" width=400>联系电话： <input type="text" name="data16" size=22 maxlength=22 value=<%=data16%> ></td>
</table></td></tr>
<tr><td><table width=800>
<td>
<p align="left" width=800>抵押权人：中国民生银行<input type="text" name="data17" size=32 value=<%=data17%> ></td>
</table></td></tr>
<tr><td><table width=800>
<td align="left" width=400>合同编号：<input type="text" name="data21" size=19 maxlength=19 value=<%=data21%> ></td>
<td align="left" width=400>合同签订日期：<input type="text" name="data18" size=4 maxlength=9 value=<%=data18%> >年
<input type="text" name="data19" size=2 maxlength=7 value=<%=data19%> >月
<input type="text" name="data20" size=2 maxlength=6 value=<%=data20%> >日</td>
</table></td></tr>
<tr><td><table width=800>
<td align="left" width=400>抵押房产位置：北京市<input type="text" name="data22" size=10 maxlength=10 value=<%=data22%> >区</td>
<td align="left" width=400>抵押房产所有证号：<input type="text" name="data23" size=20 maxlength=20 value=<%=data23%> ></td>
</table></td></tr>
</table>
<input type="submit" name="submit" value="提交">
<input type="reset" name="reset" value="重置">
</form>
</center>
<%
}
else{
%>
<jsp:include page="head.txt"/>
<%
out.print("<font color=#FF0000>找不到您需要的资料，请与管理员联系。");
}
con.close();
}catch(SQLException e){
out.println(e);
}catch(ClassNotFoundException e){
out.println(e);
}
}
}
else{
submit=codeString(submit);
if(submit.equals("提交")){
long num=0;
String strnum=request.getParameter("num");
if(strnum==null)strnum="";
if(strnum.equals(""))
strnum="无";
try{
num=Long.valueOf(strnum).longValue();
}catch(NumberFormatException e){
num=0;
}
if(num<1){
%>
<jsp:include page="head.txt"/>
<%
out.print("<font color=#FF0000>找不到您需要的资料，请与管理员联系。");
}
else{
//check表单
String data1,data2,data3,data4,data5,data6,data7,data8,data9,data10,
data11,data12,data13,data14,data15,data16,data17,data18,data19,data20,
data21,data22,data23;
redataPara.setNum(num);
data1=request.getParameter("data1");
if(data1==null)data1="";
data1=codeString(data1);
data1=formatString(data1);
redataPara.setData1(data1);
data2=request.getParameter("data2");
if(data2==null)data2="";
data2=codeString(data2);
data2=formatString(data2);
redataPara.setData2(data2);
data3=request.getParameter("data3");
if(data3==null)data3="";
data3=codeString(data3);
data3=formatString(data3);
redataPara.setData3(data3);
data4=request.getParameter("data4");
if(data4==null)data4="";
data4=codeString(data4);
data4=formatString(data4);
redataPara.setData4(data4);
data5=request.getParameter("data5");
if(data5==null)data5="";
data5=codeString(data5);
data5=formatString(data5);
redataPara.setData5(data5);
data6=request.getParameter("data6");
if(data6==null)data6="";
data6=codeString(data6);
data6=formatString(data6);
redataPara.setData6(data6);
data7=request.getParameter("data7");
if(data7==null)data7="";
data7=codeString(data7);
data7=formatString(data7);
redataPara.setData7(data7);
data8=request.getParameter("data8");
if(data8==null)data8="";
data8=codeString(data8);
data8=formatString(data8);
redataPara.setData8(data8);
data9=request.getParameter("data9");
if(data9==null)data9="";
data9=codeString(data9);
data9=formatString(data9);
redataPara.setData9(data9);
data10=request.getParameter("data10");
if(data10==null)data10="";
data10=codeString(data10);
data10=formatString(data10);
redataPara.setData10(data10);
data11=request.getParameter("data11");
if(data11==null)data11="";
data11=codeString(data11);
data11=formatString(data11);
redataPara.setData11(data11);
data12=request.getParameter("data12");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -