📄 answerzhuce.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<%!//处理中文字符串的函数
public String codeToString(String str)
{
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<% //接受客护端提交的数据
String name=codeToString(request.getParameter("name"));
if(name==null)
name="";
String number=codeToString(request.getParameter("number"));
if(number==null)
number="";
String sex=codeToString(request.getParameter("sex"));
if(sex==null)
sex="";
String password=codeToString(request.getParameter("password"));
if(password==null)
password="";
String checkbox[]=request.getParameterValues("hobby");
String hobby="";
for(int i=0;i<checkbox.length;i++)
checkbox[i]=codeToString(checkbox[i])+"、";
for(int i=0;i<checkbox.length;i++)
hobby+=checkbox[i];
String zhuanye=codeToString(request.getParameter("zhuanye"));
if(zhuanye==null)
zhuanye="";
String y=codeToString(request.getParameter("year"));
String m=codeToString(request.getParameter("month"));
String d=codeToString(request.getParameter("day"));
String birthday=""+y+m+d;
if(birthday==null)
birthday="";
String telephone=request.getParameter("telephone");
if(telephone==null)
telephone="";
String geyan=codeToString(request.getParameter("geyan"));
if(geyan==null)
geyan="";
%>
<%//构造添加记录SQL语句
Connection con;
Statement sql;
ResultSet rs;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:yonghu");
sql=con.createStatement();
String sqlString="insert into yonghu1 values"+"("+"'"+name+"','"+number+"','"+sex+"','"+password+"','"+hobby+"','"+zhuanye+"','"+birthday+"','"+telephone+"','"+geyan+"')";
sql.executeUpdate(sqlString);
con.close();
}
catch(SQLException e)
{out.print(e.toString());}
%>
<head>
<title>用户注册程序</title>
</head>
<body background="background.jpg">
<br>
<br>
<hr>
<br>
<br>
<p width="100%" align="center"><font size=6 color=red>用户注册程序</font>
<br>
<p align=center>
<a href="main.jsp">点激此处进入登录页面</a>
</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -