<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>人口普查系统</title>
</head>
<body>
<p align="center"><font size="30" color="red">人口普查系统</font></p>
<center>
<hr>
<form name="form" action="Create.jsp">
<b>信息登记</b>
<input type="submit" value="进入">
</form>
<br>
<form name="form1" action="Update.jsp">
<b>信息修改</b>
<input type="submit" value="进入">
</form>
<br>
<form name="form2" action="Delete.jsp">
<b>信息删除</b>
<input type="submit" value="进入">
</form>
<br>
<form name="form3" action="Search.jsp">
<b>查询信息</b>
<input type="submit" value="进入">
</form>
<br>
<form name="form4" action="Show.jsp">
<b>显示信息</b>
<input type="submit" value="进入">
</form>
<br>
</center>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Delete Confirm</title>
</head>
<body>
<%
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
boolean a=false;
Connection conn=null;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace( );
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
String name=(String)request.getParameter("name");
String str="delete from house where 户主姓名=?";
PreparedStatement ptmt=conn.prepareStatement(str);
ptmt.setString(1,name);
ptmt.execute( );
out.print("<script language='javaScript'> alert('删除成功！');</script>");
response.setHeader("refresh", "0;url=Main.jsp");
%>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>删除人口</title>
</head>
<body>
<center>
<p align="center"><font size="30" color="red">户口删除</font></p>
<form action="MediumDelete.jsp">
<table align="center" border="1",width="50%">
<tr><th>请输入户主姓名</th><td><input type="text" name="name"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="删除" ></td></tr>
</table>
</form>
</center>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
Connection conn=null;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
String household=(String)request.getParameter("household");
String housetype=(String)request.getParameter("housetype");
String area=(String)request.getParameter("area");
String count=(String)request.getParameter("count");
String name=(String)request.getParameter("name");
String ID=(String)request.getParameter("ID");
String sex=(String)request.getParameter("sex");
String nation=(String)request.getParameter("nation");
String education=(String)request.getParameter("education");
String str="insert into house (户别,住房类型,本户现住房面积,本户现住房间数,户主姓名,身份证号码,性别,民族,受教育程度) values (?,?,?,?,?,?,?,?,?)";
PreparedStatement ptmt=conn.prepareStatement(str);
ptmt.setString(1,household);
ptmt.setString(2,housetype);
ptmt.setString(3,area);
ptmt.setString(4,count);
ptmt.setString(5,name);
ptmt.setString(6,ID);
ptmt.setString(7,sex);
ptmt.setString(8,nation);
ptmt.setString(9,education);
ptmt.execute( );
response.setHeader("refresh", "0;url=Show.jsp");
%>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>信息登记</title>
<script language="javascript">
function myFunction( )
{
if(isNaN(form.count.value)||form.count.value=="")
{
alert("输入错误!只能输入数字！");
form1.course.focus();
return false;
}
else if(form.count.value<0||form.count.value>99999)
{
alert("输入数字不正确!");
form1.course.focus();
return false;
}
if(isNaN(form.area.value)||form.area.value=="")
{
alert("输入错误!只能输入数字！");
form1.course.focus();
return false;
}
else if(form.count.value<0||form.count.value>99999)
{
alert("输入数字不正确!");
form1.course.focus();
return false;
}
if(form.ID.value==""||form.ID.value.length!=18)
{
alert("输入的身份证号错误！");
form1.course.focus();
return false;
}
else
{
for(i=0;i<form.ID.value.length;i++)
{
if(i<form.ID.value.length-1)
{
if(form.ID.value.charAt(i)<'0'||form.ID.value.charAt(i)>'9')
{
alert("输入的身份证号错误！不能为字母！");
form1.course.focus();
return false;
}
}
if(i==form.ID.value.length-1)
{
if((form.ID.value.charAt(i)<'0'||form.ID.value.charAt(i)>'9')&&form.ID.value.charAt(i)!='X')
{
alert("最后一位输入错误！");
form1.course.focus();
return false;
}
}
}
}
var Fname=document.getElementById("form");
alert("登记成功！");
form.action="Createmysql.jsp";
form.submit( );
}
</script>
</head>
<body>
<p align="center"><font size="30" color="red">人口信息登记表</font></p>
<center>
<hr>
<form name="form">
<table align="center" border="1",width="50%">
<tr><th>户别</th><td><input type="radio" name="household" value="家庭户" checked>家庭户
<input type="radio" name="household" value="集体户">集体户</td></tr>
<tr><th>住房类型</th><td><input type="radio" name="housetype" value="家庭住宅" checked>家庭住宅
<input type="radio" name="housetype" value="集体住所">集体住所
<input type="radio" name="housetype" value="工作地住所">工作地住所
<input type="radio" name="housetype" value="其他住宅">其他住宅
<input type="radio" name="housetype" value="无住宅">无住宅</td></tr>
<tr><th>本户现住房面积</th><td><input type="number" name="area">平方米</td></tr>
<tr><th>本户现住房间数</th><td><input type="number" name="count">间</td></tr>
<tr><th>户主姓名</th><td><input type="text" name="name"></td></tr>
<tr><th>身份证号码</th><td><input type="text" name="ID"></td></tr>
<tr><th>性别</th><td><input type="radio" name="sex" value="男" checked>男
<input type="radio" name="sex" value="女">女</td></tr>
<tr><th>民族</th><td><input type="text" name="nation"></td></tr>
<tr><th>受教育程度</th><td>
<select name="education">
<option>请选择</option>
<option value="研究生" selected>研究生</option>
<option value="大学本科">大学本科</option>
<option value="大学专科">大学专科</option>
<option value="高中">高中</option>
<option value="初中">初中</option>
<option value="小学">小学</option>
<option value="未上过学">未上过学</option>
</select>
</td></tr>
<tr><td colspan="2" align="center"><input type="button" value="提交" onClick="myFunction( )"></td></tr>
</table>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>MiddleDelete</title>
<script language='javaScript'>
function check( )
{
var a=confirm('是否删除？');
if(a==true)
{
var Fname=document.getElementById("form");
form.action="Deletemysql.jsp";
form.submit( );
return true;
}
if(a==false)
{
return false;
}
}
</script>
</head>
<body>
<p align="center"><font size="30" color="red">户口明示</font></p>
<hr>
<form name="form">
<table border="1" align="center">
<tr>
<th>户别</th>
<th>住房类型</th>
<th>本户现住房面积</th>
<th>本户显著房间数</th>
<th>户主姓名</th>
<th>身份证号码</th>
<th>性别</th>
<th>民族</th>
<th>受教育程度</th>
</tr>
<%
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
Connection conn=null;
boolean a=false;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
String str="select * from house where 户主姓名=?";
String name1=(String)request.getParameter("name");
PreparedStatement ptmt=conn.prepareStatement(str);
ptmt.setString(1,name1);
ResultSet rs = ptmt.executeQuery( );
while(rs.next())
{
a=true;
out.println("<tr><td>"+rs.getString("户别")+"</td>");
out.println("<td>"+rs.getString("住房类型")+"</td>");
out.println("<td>"+rs.getString("本户现住房面积")+"</td>");
out.println("<td>"+rs.getString("本户现住房间数")+"</td>");
out.println("<td><input name="+"\""+"name"+"\""+"value="+"\""+rs.getString("户主姓名")+"\""+"></td>");
out.println("<td>"+rs.getString("身份证号码")+"</td>");
out.println("<td>"+rs.getString("性别")+"</td>");
out.println("<td>"+rs.getString("民族")+"</td>");
out.println("<td>"+rs.getString("受教育程度")+"</td></tr>");
}
if(a==false)
{
out.print("<script language='javaScript'> alert('该户主信息不存在！');</script>");
response.setHeader("refresh", "0;url=Main.jsp");
}
out.println("<tr><td colspan='9' align='center'>"+"<input type='button' value='删除' onClick='check( )'>"+"</td></tr>");
%>
</table>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title> </title>
</head>
<body>
<%
String household=(String)request.getParameter("household");
String housetype=(String)request.getParameter("housetype");
String area=(String)request.getParameter("area");
String count=(String)request.getParameter("count");
String name=(String)request.getParameter("name");
String ID=(String)request.getParameter("ID");
String sex=(String)request.getParameter("sex");
String nation=(String)request.getParameter("nation");
String education=(String)request.getParameter("education");
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
Connection conn=null;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
String str1="Update house set 户别=?,住房类型=?,本户现住房面积=?,本户现住房间数=?,户主姓名=?,身份证号码=?,性别=?,民族=?,受教育程度=? where 户主姓名=?";
PreparedStatement ptmt1=conn.prepareStatement(str1);
ptmt1.setString(1,household);
ptmt1.setString(2,housetype);
ptmt1.setString(3,area);
ptmt1.setString(4,count);
ptmt1.setString(5,name);
ptmt1.setString(6,ID);
ptmt1.setString(7,sex);
ptmt1.setString(8,nation);
ptmt1.setString(9,education);
ptmt1.setString(10,name);
ptmt1.execute( );
response.setHeader("refresh", "0;url=Show.jsp");
%>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>查询系统</title>
</head>
<body>
<center>
<p align="center"><font size="30" color="red">户主查找</font></p>
<form action="Searchmysql.jsp">
<table align="center" border="1",width="50%">
<tr><th>请输入内容</th><td><input type="text" name="name"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="查询"></td></tr>
</table>
</form>
</center>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>查询</title>
</head>
<body>
<p align="center"><font size="30" color="red">查找结果</font></p>
<hr>
<table border="1" align="center">
<tr>
<th>户主姓名</th>
<th>性别</th>
<th>民族</th>
<th>受教育程度</th>
</tr>
<%
int i,j,k=0,l=0,t=0,h=0;
String name=(String)request.getParameter("name");
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
boolean a=false;
Connection conn=null;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from house");
while(rs.next())
{
rs.getString("户主姓名");
rs.getString("性别");
rs.getString("民族");
rs.getString("受教育程度");
for(j=0;j<name.length();j++)
{
for(i=0;i<rs.getString("户主姓名").length( );i++)
{
if(rs.getString("户主姓名").charAt(i)==name.charAt(j))
{
k=1;
break;
}
}
if(k==1){l=1;h=1;break;}
}
if(l==0)
{
for(j=0;j<name.length();j++)
{
for(i=0;i<rs.getString("性别").length( );i++)
{
if(rs.getString("性别").charAt(i)==name.charAt(j))
{
k=1;
break;
}
}
if(k==1){l=1;h=2;break;}
}
}
if(l==0)
{
for(j=0;j<name.length();j++)
{
for(i=0;i<rs.getString("民族").length( );i++)
{
if(rs.getString("民族").charAt(i)==name.charAt(j))
{
k=1;
break;
}
}
if(k==1){l=1;h=3;break;}
}
}
if(l==0)
{
for(j=0;j<name.length();j++)
{
for(i=0;i<rs.getString("受教育程度").length( );i++)
{
if(rs.getString("受教育程度").charAt(i)==name.charAt(j))
{
k=1;
break;
}
}
if(k==1){l=1;h=4;break;}
}
}
if(l==1)
{
out.println("<form action="+"\""+"Showpersonal.jsp"+"\""+">"+"<tr><td><input name="+"\""+"name"+"\""+"value="+"\""+rs.getString("户主姓名")+"\""+">"+"<input type="+"\""+"submit"+"\""+"value="+"\""+rs.getString("户主姓名")+"\""+">"+"</td>");
out.println("<td>"+rs.getString("性别")+"</td>");
out.println("<td>"+rs.getString("民族")+"</td>");
out.println("<td>"+rs.getString("受教育程度")+"</td></tr></form>");
l=0;
k=0;
t=1;
}
}
if(t==0)
{
out.print("<script language='javaScript'> alert('查找失败！');</script>");
response.setHeader("refresh", "0;url=Main.jsp");
}
if(t==1)
{
out.print("<script language='javaScript'> alert('查找成功！');</script>");
}
%>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>户口明示</title>
</head>
<body>
<p align="center"><font size="30" color="red">户口明示</font></p>
<hr>
<table border="1" align="center">
<tr>
<th>户别</th>
<th>住房类型</th>
<th>本户现住房面积</th>
<th>本户显著房间数</th>
<th>户主姓名</th>
<th>身份证号码</th>
<th>性别</th>
<th>民族</th>
<th>受教育程度</th>
</tr>
<%
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
Connection conn=null;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from house");
while(rs.next())
{
out.println("<tr><td>"+rs.getString("户别")+"</td>");
out.println("<td>"+rs.getString("住房类型")+"</td>");
out.println("<td>"+rs.getString("本户现住房面积")+"</td>");
out.println("<td>"+rs.getString("本户现住房间数")+"</td>");
out.println("<td>"+rs.getString("户主姓名")+"</td>");
out.println("<td>"+rs.getString("身份证号码")+"</td>");
out.println("<td>"+rs.getString("性别")+"</td>");
out.println("<td>"+rs.getString("民族")+"</td>");
out.println("<td>"+rs.getString("受教育程度")+"</td></tr>");
}
%>
</table>
<br>
<form name="form1" action="Main.jsp">
<center><input type="submit" value="主界面"></center>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<p align="center"><font size="30" color="red">个人信息</font></p>
<hr>
<table border="1" align="center">
<tr>
<th>户别</th>
<th>住房类型</th>
<th>本户现住房面积</th>
<th>本户显著房间数</th>
<th>户主姓名</th>
<th>身份证号码</th>
<th>性别</th>
<th>民族</th>
<th>受教育程度</th>
</tr>
<%
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
Connection conn=null;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
String str="select * from house where 户主姓名=?";
String name=(String)request.getParameter("name");
PreparedStatement ptmt=conn.prepareStatement(str);
ptmt.setString(1,name);
ResultSet rs = ptmt.executeQuery( );
while(rs.next())
{
out.println("<tr><td>"+rs.getString("户别")+"</td>");
out.println("<td>"+rs.getString("住房类型")+"</td>");
out.println("<td>"+rs.getString("本户现住房面积")+"</td>");
out.println("<td>"+rs.getString("本户现住房间数")+"</td>");
out.println("<td>"+rs.getString("户主姓名")+"</td>");
out.println("<td>"+rs.getString("身份证号码")+"</td>");
out.println("<td>"+rs.getString("性别")+"</td>");
out.println("<td>"+rs.getString("民族")+"</td>");
out.println("<td>"+rs.getString("受教育程度")+"</td></tr>");
}
%>
</table>
<br>
<form name="form1" action="Main.jsp">
<center><input type="submit" value="主界面"></center>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>修改系统</title>
</head>
<body>
<center>
<p align="center"><font size="30" color="red">修改户口</font></p>
<form action="Updatemysql.jsp">
<table align="center" border="1",width="50%">
<tr><th>请输入户主姓名</th><td><input type="text" name="name"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="修改"></td></tr>
</table>
</form>
</center>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>户主修改</title>
<script language="javascript">
function myFunction( )
{
if(form.sex.value==""||(form.sex.value!="男"&&form.sex.value!="女"))
{
alert("输入的性别有误！");
form.course.focus();
return false;
}
if(form.education.value==""||(form.education.value!="研究生"&&form.education.value!="大学本科"&&form.education.value!="大学专科"&&form.education.value!="高中"&&form.education.value!="初中"&&form.education.value!="小学"&&form.education.value!="未上过学"))
{
alert("输入的受教育程度有误！");
form.course.focus();
return false;
}
if(form.ID.value==""||form.ID.value.length!=18)
{
alert("输入的身份证号错误！");
form.course.focus();
return false;
}
else
{
for(i=0;i<form.ID.value.length;i++)
{
if(i<form.ID.value.length-1)
{
if(form.ID.value.charAt(i)<'0'||form.ID.value.charAt(i)>'9')
{
alert("输入的身份证号错误！不能为字母！");
form.course.focus();
return false;
}
}
if(i==form.ID.value.length-1)
{
if((form.ID.value.charAt(i)<'0'||form.ID.value.charAt(i)>'9')&&form.ID.value.charAt(i)!='X')
{
alert("最后一位输入错误！");
form.course.focus();
return false;
}
}
}
}
var Fname=document.getElementById("form");
alert("修改成功！");
form.action="Save.jsp";
form.submit( );
}
</script>
</head>
<body>
<p align="center"><font size="30" color="red">户主修改</font></p>
<hr>
<form name="form" >
<table border="1" align="center" width="50%">
<tr>
<th>户别</th>
<th>住房类型</th>
<th>本户现住房面积</th>
<th>本户显著房间数</th>
<th>户主姓名</th>
<th>身份证号码</th>
<th>性别</th>
<th>民族</th>
<th>受教育程度</th>
</tr>
<%
final String URL="jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC";
final String Name="root";
final String Password="woshinidie668";
boolean a=false;
Connection conn=null;
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载驱动成功");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
System.out.print("Error!");
}
try
{
conn=DriverManager.getConnection(URL,Name,Password);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("数据库链接失败！");
}
String str="select * from house where 户主姓名=?";
String name1=(String)request.getParameter("name");
PreparedStatement ptmt=conn.prepareStatement(str);
ptmt.setString(1,name1);
ResultSet rs = ptmt.executeQuery( );
while(rs.next())
{
a=true;
out.println("<tr><td><input name="+"\""+"household"+"\""+"value="+"\""+rs.getString("户别")+"\""+"></td>");
out.println("<td><input name="+"\""+"housetype"+"\""+"value="+"\""+rs.getString("住房类型")+"\""+"></td>");
out.println("<td><input name="+"\""+"area"+"\""+"value="+"\""+rs.getString("本户现住房面积")+"\""+"></td>");
out.println("<td><input name="+"\""+"count"+"\""+"value="+"\""+rs.getString("本户现住房间数")+"\""+"></td>");
out.println("<td><input name="+"\""+"name"+"\""+"value="+"\""+rs.getString("户主姓名")+"\""+"></td>");
out.println("<td><input name="+"\""+"ID"+"\""+"value="+"\""+rs.getString("身份证号码")+"\""+"></td>");
out.println("<td><input name="+"\""+"sex"+"\""+"value="+"\""+rs.getString("性别")+"\""+"></td>");
out.println("<td><input name="+"\""+"nation"+"\""+"value="+"\""+rs.getString("民族")+"\""+"></td>");
out.println("<td><input name="+"\""+"education"+"\""+"value="+"\""+rs.getString("受教育程度")+"\""+"></td></tr>");
}
if(a==false)
{
out.print("<script language='javaScript'> alert('该户主信息不存在！');</script>");
response.setHeader("refresh", "0;url=Main.jsp");
}
%>
<tr><td colspan="9" align="center"><input type="button" value="提交" onClick="myFunction( )"></td></td>
</table>
</form>
</body>
</html>
浙公网安备 33010602011771号