📄 test2.jsp

📁 一个功能简单的图书馆管理系统
💻 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">
<%@ page import="java.util.*"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" />
<title>无标题文档</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;
    //  ResultSet rs=null;
	  String pages;
	  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;//=Long.parseLong(request.getParameter("Bookpages"));
	  String Bookkeyword=codeToString(request.getParameter("Bookkeyword"));
	  String Bookindate=codeToString(request.getParameter("Bookindate"));
	  String Bookmemo=codeToString(request.getParameter("Bookmemo"));
	  String sqlString;
	  int errorfag=0;
/*	  out.println(Bookid);out.print("*******");	
	  out.println(Bookname);	out.print("*******");	
	  out.println(Bookauthor);	out.print("*******");	
	  out.println(Bookpub);	out.print("*******");	
	  out.println(Bookpubdate);	out.print("*******");	
	//  out.println("Bookpages="+Bookpages);	out.print("*******");	
	  out.println(Bookkeyword);	out.print("*******");	
	  out.println(Bookindate);out.print("*******");	
	  out.println(Bookmemo);	 out.print("*******");	
	  //sqlString="insert into books(Bookid,Bookname,Bookauthor,Bookpub,Bookpubdate,Bookindate,Putup) values('"+Bookid+"','"+Bookname+"','"+Bookauthor+"','"+Bookpub+"','"+Bookpubdate+"','"+Bookindate+"','NO')";
*/	  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=DriverManager.getConnection("jdbc:odbc:datebase","sa","123");
      sql=con.createStatement();
	  sqlString="insert into books(Bookid,Bookname,Bookauthor,Bookpub,Bookpubdate,Bookindate,Putup) values('"+Bookid+"','"+Bookname+"','"+Bookauthor+"','"+Bookpub+"','"+Bookpubdate+"','"+Bookindate+"','NO')";
	  try
	  {
	    sql.executeUpdate(sqlString);
		}
	  catch(Exception e)
	  {
	  errorfag=1;
	  out.print("检查书籍编号、书籍名称、书籍作者、书籍出版社、出版日期与登记日期等信息！");
	  }
	  if(errorfag!=1)
	  {
	 	 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!=1)
	  {
	  	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!=1)
	  {
	  	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)
	  {	  
	  %>
<body>
<hr />
</body>
</html>
<% } %>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -