📄 usergoin11.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" />
<meta http-equiv="refresh" content="3; url=usergo.jsp" />
<title>usergoin</title>
</head>
<%!
public String codeToString(String str)
{
String s=str;
try
{
byte temp[]=s.getBytes("ISO_8859_1");
s=new String (temp);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%
Connection con=null;
Statement sql=null;
String pages;
String Readerno=codeToString(request.getParameter("Readerno"));
String Readername=codeToString(request.getParameter("Readername"));
String Readersex=codeToString(request.getParameter("Readersex"));
String Readerdep=codeToString(request.getParameter("Readerdep"));
String Address=codeToString(request.getParameter("Address"));
String Readertel=codeToString(request.getParameter("Readertel"));
String Email=codeToString(request.getParameter("Email"));
String Checkdate=codeToString(request.getParameter("Checkdate"));
String Readermemo=codeToString(request.getParameter("Readermemo"));
String sqlString;
int errorfag=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:datebase","sa","123");
sql=con.createStatement();
sqlString="insert into readers(Readerno,Readername,Readersex,Checkdate) values('"+Readerno+"','"+Readername+"','"+Readersex+"','"+Checkdate+"')";
try
{
sql.executeUpdate(sqlString);
}
catch(Exception e)
{
errorfag=1;
out.print("<table><tr><td>请检查读者编号、读者姓名、读者性别、登记时间等必须填写的信息！</td></tr></table>");
}
if(errorfag!=1)
{
try
{
if(Readerdep.compareTo("")!=0)
{
sqlString="update reader set Readerdep='"+Readerdep+"' where Readerno='"+Readerno+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("<table><tr><td>请检查工作单位栏信息！</td></tr></table>");
}
}
if(errorfag!=1)
{
try
{
if(Address.compareTo("")!=0)
{
sqlString="update reader set Address='"+Address+"' where Readerno='"+Readerno+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("<table><tr><td>请检查家庭地址栏信息！</td></tr></table>");
}
}
if(errorfag!=1)
{
try
{
if(Readertel.compareTo("")!=0)
{
sqlString="update reader set Readertel='"+Readertel+"' where Readerno='"+Readerno+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("<table><tr><td>请检查电话号码栏信息！</td></tr></table>");
}
if(errorfag!=1)
{
try
{
if(Email.compareTo("")!=0)
{
sqlString="update reader set Email='"+Email+"' where Readerno='"+Readerno+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("<table><tr><td>请检查电子邮件地址栏信息！</td></tr></table>");
}
}
if(errorfag!=1)
{
try
{
if(Readermemo.compareTo("")!=0)
{
sqlString="update reader set Readermemo='"+Readermemo+"' where Readerno='"+Readerno+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("<table><tr><td>检查备注栏信息！</td></tr></table>");
}
}
if(errorfag!=1)
{
%>
<body>
<hr />
<p align="center">成功录入一用户信息！</p>
<p align="center">3秒后将自动返回</p>
<p align="center"><form action="usergo.jsp" method="get"><table align="center" width="10%"><tr><td align="center"><input name="input1" type="submit" value="确定" /></td></tr></table></form></p>
</body>
</html>
<%}%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -