📄 login.jsp

📁 一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现

💻 JSP

字号:

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>登录</title>
</head>
<body>
<jsp:useBean id="dbcon" scope="page" class="bb.Dbcon" />
<%
  String username1=request.getParameter("username");
  String password=request.getParameter("password");
  String Error=new String();
  String password2;
  ResultSet rest=null;
  
  //dbcon.conn();
  String sql="select password from tpb.account where password='"+username1+"'";
  rest=dbcon.executeQuery(sql);
  rest.next();
  password2=rest.getString("password");
  String demp1=rest.getString("depm");
  if(password.equals(password2))
  if (demp1.equals("1"))
%>
<jsp:forward page="stock.jsp"/>
<%
  //;else if(demp1.equals("2"))
%>
<jsp:forward page="sell.jsp"/>
<%
 // ;else if(demp1.equals("3"))
%> 
<jsp:forward page="staffer.jsp"/>
<%
  //;else if(demp1.equals("4"))
%> 
<jsp:forward page="finance.jsp"/>
<%
  //;
  rest.close();
  rs.close();
  stmt.close();
  dbcon.close();
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -