📄 judge.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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="refresh" content="3; url=index.jsp"  />
<title>judge</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;
       }
     }
%>
   <%
 //  String str="index";
 //  if(((String)session.getAttribute("frompage")).compareTo(str)==0)
 //  {
	  Connection con=null;
      Statement sql=null;
      ResultSet rs=null;
	  String inputid=null;
	  String inputword=null;
	  String sqlString=null;
	  String input=null;
	  inputid=codeToString(request.getParameter("userid"));
	  inputword=codeToString(request.getParameter("password"));
	  input=codeToString(request.getParameter("select"));
	  sqlString="select * from admin where adminid = '"+inputid+"'";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=DriverManager.getConnection("jdbc:odbc:datebase","sa","123");
      sql=con.createStatement();
	  rs=sql.executeQuery(sqlString);
	  HttpSession mysession=request.getSession();
		if(!rs.next())
		{
		out.print("<table><tr><td>您输入的信息有错误</td></tr></table>");
		}
		else
		{		
			if(inputword.compareTo(rs.getString(2))!=0)
			out.print("<table><tr><td>您输入的密码有错误</td></tr></table>");
		
			else
			{
				session.setAttribute("admin",inputid);
				if(input.compareTo("book_go")!=0)
				{%>
				<script language="javascript">
				window.location="usergo.jsp";
				</script>
				<%}
			     else 
				 {%>
					<script language="javascript">
					window.location="bookgo.jsp";
					</script>
				<%}
			 }
		}
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -