⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 check.jsp

📁 JSP+SQL2005 MVC模式 下载后改DB.java类的SQL密码就可用。
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.ResultSet,com.model.javabean.SubSingle,com.model.javabean.Single,java.util.ArrayList" %>
<jsp:directive.page import="javax.swing.JOptionPane"/>
<jsp:useBean id="mydb" class="com.model.javabean.DB"/>
<%
 session.setMaxInactiveInterval(3600);
 String user = request.getParameter("user");
 String password = request.getParameter("password");
 String sql="select * from yonghu where 昵称='"+user+"'";
 String k,kk;
 ResultSet rs = mydb.Read(sql);
 if(rs.next()){
	  k=rs.getString("昵称");
	  kk=rs.getString("密码");
	   if(password.equals(kk))
    	   {
    	  request.setAttribute("user",user);
    	   String sql1="select * from tb_type order by type_order";
   ResultSet gs=mydb.Read(sql1);
   ArrayList typelist=new ArrayList();
   if(gs.next()){
	   gs.previous();
       while(gs.next()){
           Single idtype=new Single();
    	   idtype.setId(gs.getInt("id"));
           idtype.setMaster(gs.getString("type_master"));
    	   idtype.setTitle(gs.getString("type_title"));
    	   idtype.setAmount(gs.getInt("type_amount"));
    	   idtype.setNum(gs.getInt("type_num"));
    	   typelist.add(idtype);
       }
       mydb.closed();
       session.setAttribute("typelist",typelist);
   }
   else
	   session.setAttribute("typelist",null);
    	   
    	   %><jsp:forward page="/zhuye.jsp"/>
    	   <% }
    	   else
    	   {
    	   
          
    	    out.print("<script language = javascript>alert('用户名和密码不正确!');window.location.href='index.jsp';</script>");
    	    
    	   }
	  
       }
   else{
	   out.print("<script language = javascript>alert('用户名和密码不正确!');window.location.href='index.jsp';</script>");
 }

%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    
  </head>
  
  <body>
   <br>
  </body>
</html>

⌨️ 快捷键说明

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