📄 usergoin.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"));
/* out.print(Readerno);out.print("************");
out.print(Readername);out.print("************");
out.print(Readersex);out.print("************");
out.print(Readerdep);out.print("************");
out.print(Address);out.print("************");
out.print(Readertel);out.print("************");
out.print(Email);out.print("************");
out.print(Checkdate);out.print("************");
out.print(Readermemo);out.print("************");
out.print("************");
*/
String sqlString;
int errorfag=0;
int rs;
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+"')";
if((Readerno.compareTo("")!=0)&&(Readername.compareTo("")!=0)&&(Readersex.compareTo("")!=0)&&(Checkdate.compareTo("")!=0))
{
try
{
rs=sql.executeUpdate(sqlString);out.println(rs);
}
catch(Exception e)
{
errorfag=1;out.print(e);
out.print("<table><tr><td>请检查读者编号、读者姓名、读者性别、登记时间等必须填写的信息！</td></tr></table>");
}
}
else
{
errorfag=1;
out.print("<table><tr><td>请将带*的部分填写填写完整！</td></tr></table>");
}
if(errorfag!=1)
{
try
{
if(Readerdep.compareTo("")!=0)
{
sqlString="update readers 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 readers 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 readers 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 readers 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 readers 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"><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 + -