📄 bookgoin.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" content="3; url=bookgo.jsp" />
<title>bookgoin</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;
}
}
%>
<%
if(session.getAttribute("admin")==null)
{ %>
<script language="javascript">
window.location="error.jsp";
</script>
<%
}
else
{
Connection con=null;
Statement sql=null;
String pages;
ResultSet rs=null;
String Bookid=codeToString(request.getParameter("Bookid"));
String Bookname=codeToString(request.getParameter("Bookname"));
String Bookauthor=codeToString(request.getParameter("Bookauthor"));
String Bookpub=codeToString(request.getParameter("Bookpub"));
String Bookpubdate=request.getParameter("Bookpubdate");
long Bookpages;
String Bookkeyword=codeToString(request.getParameter("Bookkeyword"));
String Bookindate=codeToString(request.getParameter("Bookindate"));
String Bookmemo=codeToString(request.getParameter("Bookmemo"));
/* out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
out.print();out.print("************");
*/
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 books(Bookid,Bookname,Bookauthor,Bookindate,Putup) values('"+Bookid+"','"+Bookname+"','"+Bookauthor+"','"+Bookindate+"','NO')";
if((Bookid.compareTo("")!=0)&&(Bookname.compareTo("")!=0)&&(Bookauthor.compareTo("")!=0)&&(Bookindate.compareTo("")!=0))
{
try
{
sql.executeUpdate(sqlString);
}
catch(Exception e)
{
errorfag=1;
out.print("检查书籍编号、书籍名称、书籍作者与登记日期等信息！");
}
sqlString="select * from books where Bookid='"+Bookid+"'";
try
{
rs=sql.executeQuery(sqlString);
}
catch(Exception e)
{
}
if(rs.next())
{
errorfag=2;
out.print("书籍编号冲突");
}
}
else
{
errorfag=1;
out.print("<table><tr><td>请将带*的部分填写完整！</td></tr></table>");
}
if(errorfag==0)
{
try
{
if(Bookpub.compareTo("")!=0)
{
sqlString="update books set Bookpub='"+Bookpub+"' where Bookid='"+Bookid+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("检查书籍出版日期信息！");
}
}
if(errorfag==0)
{
try
{
pages=codeToString(request.getParameter("Bookpages"));
if(pages.compareTo("")!=0)
{
Bookpages=Long.parseLong(request.getParameter("Bookpages"));
sqlString="update books set Bookpages='"+Bookpages+"' where Bookid='"+Bookid+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("检查书籍页码信息！");
}
}
if(errorfag==0)
{
try
{
if(Bookkeyword.compareTo("")!=0)
{
sqlString="update books set Bookkeyword='"+Bookkeyword+"' where Bookid='"+Bookid+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("检查书籍关键字信息！");
}
}
if(errorfag==0)
{
try
{
if(Bookmemo.compareTo("")!=0)
{
sqlString="update books set Bookmemo='"+Bookmemo+"' where Bookid='"+Bookid+"'";
sql.executeUpdate(sqlString);
}
}
catch(Exception e)
{
errorfag=1;
out.print("检查书籍备注信息！");
}
}
if(errorfag==1)
{
sqlString="delete from books where Bookid='"+Bookid+"'";
sql.executeUpdate(sqlString);
}
else
{
if(errorfag==0)
{
%>
<body>
<hr />
<p align="center">成功录入一本书籍信息！</p>
<p align="center"><form action="bookgo.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 + -