人口普查系统：
菜单：
<%@ page language="java" contentType="text /html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<pre>
<table align="center" width="450">
<tr>
<h2>人口普查系统</h2>
<hr>
<tr align="center"><a href="add.jsp">信息登记</a></tr>
<br>
<tr align="center"><a href="Jupdate.jsp">信息修改</a></tr>
<br>
<tr align="center"><a href="Jdelete.jsp">信息删除</a></tr>
<br>
<tr align="center"><a href="Jliulan.jsp">信息浏览</a></tr>
<br>
<tr align="center"><a href="Jcha.jsp">信息查询</a></tr>
</table>
</pre>
</body>
</html>
添加表格;
<%@ page language="java" contentType="text /html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8d">
<title>Insert title here</title>
</head>
<body>
<form action="addmysql.jsp" method="post" onsubmit="return chech(this)">
<table align="center" width="450">
<tr>
<td align="center" >
<h2>添加个人信息信息</h2>
<hr>
</td>
</tr>
<tr>
<td align="right">户别：</td>
<td>
<input type="radio" name="hubie" value="家庭户" checked="checked">家庭户
<input type="radio" name="hubie" value="集体户">集体户
</td>
</tr>
<tr>
<td align="right">住房类型：</td>
<td>
<input type="radio" name="zhufang" value="家庭住宅" checked="checked">家庭住宅
<input type="radio" name="zhufang" value="集体住所">集体住所
<input type="radio" name="zhufang" value="工作地住所">工作地住所
<input type="radio" name="zhufang" value="其他住宅">其他住宅
<input type="radio" name="zhufang" value="无住宅">无住宅
</td>
</tr>
<tr>
<td align="right">本户现住房面积：</td>
<td><input type="text" name="nows"/></td>
</tr>
<tr>
<td align="right">本户现住房间数：</td>
<td><input type="text" name="nowsnum"/></td>
</tr>
<tr>
<td align="right">户主姓名：</td>
<td><input type="text" name="name"/></td>
</tr>
<tr>
<td align="right">身份证号：</td>
<td><input type="text" name="num" maxlength="13"/></td>
</tr>
<tr>
<td align="right">性别：</td>
<td>
<input type="radio" name="sex" value="男" checked="checked">男
<input type="radio" name="sex" value="女">女
</td>
</tr>
<tr>
<td align="right">民族：</td>
<td><input type="text" name="min"/></td>
</tr>
<tr>
文化程度
<select name="edu" size="3" align="right">
<option>研究生</option>
<option>大学本科</option>
<option>大学专科</option>
<option>高中</option>
<option>初中</option>
<option>小学</option>
<option>未上过学</option>
</select>
</tr>
<tr>
<td align="center" colspan="2">
<input type="submit" value="提交">
</td>
</tr>
</table>
</form>
</body>
</html>
写到mysql：
<%@ page language="java" contentType="text/ html; charset=UTF-8"
pageEncoding="UTF-8" import = "java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%request.setCharacterEncoding("UTF-8"); %>
<%
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8";
String username = "root";
String password="123456";
Connection a = DriverManager.getConnection(url,username,password);
if(a != null){
out.println("数据库连接成功！");
}
String hubie=request.getParameter("hubie");
String zhufang=request.getParameter("zhufang");
String nows=request.getParameter("nows");
String nowsnum=request.getParameter("nowsnum");
String name=request.getParameter("name");
String num=request.getParameter("num");
String sex=request.getParameter("sex");
String min=request.getParameter("min");
String edu=request.getParameter("edu");
String sql="insert into renkou(户别,住房类型,本户现住房面积,本户现住房间数,户主姓名,身份证号码,性别,民族,受教育程度)values(?,?,?,?,?,?,?,?,?)";
PreparedStatement b=a.prepareStatement(sql);
b.setString(1,hubie);
b.setString(2,zhufang);
b.setString(3,nows);
b.setString(4,nowsnum);
b.setString(5,name);
b.setString(6,num);
b.setString(7,sex);
b.setString(8,min);
b.setString(9,edu);
int row=b.executeUpdate();
if(row>0)
{
out.println("添加成功");
}
b.close();
a.close();
%>
</body>
</html>