📄 login.jsp
字号:
<%@ page contentType="text/html;charset=iso8859_1"%>
<%@ page session = "true" %>
<%@ page import = "java.sql.*"%>
<%@ page import = "javax.swing.JOptionPane"%>
<html>
<head>
</head>
<body>
<%
String name = request.getParameter("name");
String pwd = request.getParameter("password");
String type = request.getParameter("radiobutton");
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/jsp?user=root&password=123456&useUnicode=true&characterEncoding=iso8859_1");
Statement stmt = con.createStatement();
ResultSet rs;
//String riri = "rad_stu";
//String ri2 = "rad_admin";
if(type.equals("rad_stu"))
{
String mysq = "select student_id from student where student_id ='" + name +"' and student_password = " + pwd;
rs = stmt.executeQuery(mysq);
int i = 0;
String id = "";
while(rs.next())
{
id = rs.getString(1);//out.print(rs.getString(1));
i = 1;
}
if(i !=1)
{
out.println("密码错误stu");
//out.println(type);
%>
<jsp:forward page = "index.jsp" />
<%
}
else{
//session.setAttribute("student_id", myid);
session.setAttribute("student_id", id);
%>
<jsp:forward page = "student.jsp"/>
<%
} }
else if(type.equals("rad_admin"))
{
String mysq = "select admin_name from admin where admin_name ='" + name +"' and admin_password = '" + pwd +"'";
rs = stmt.executeQuery(mysq);
int i = 0;
String id = "";
while(rs.next())
{
id = rs.getString(1);//out.print(rs.getString(1));
i = 1;
}
if(i !=1)
{
out.println("密码错误");
%>
<jsp:forward page = "index.jsp" />
<%
}
//session.setAttribute("student_id", myid);
session.setAttribute("admin_id", id);
%>
<jsp:forward page = "admin.jsp"/>
<%
}
else
{
out.print(type);
}
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -