logincheck.jsp

学生学籍管理系统sql 学生学籍管理系统sql

<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="UTF-8"%>
<%@page  import="com.record.connectionDataBase.ConnectionDataBase,java.sql.Connection,java.sql.ResultSet"%>
<%
	String name,password;
	name=request.getParameter("name").trim();
	password=request.getParameter("password").trim();
	//out.print(name+""+password);
	ConnectionDataBase connectionDataBase=new ConnectionDataBase();
	Connection conn=connectionDataBase.getConn();
	String sql="select * from admin where name='"+name+"'";
	try {
		ResultSet rs=conn.createStatement().executeQuery(sql);
		response.setCharacterEncoding("text/html charset=gb2312");
	if(rs.next())
	{
		String type=rs.getString("type");
		String user=rs.getString("name").trim();
			if(password.equals(rs.getString("password"))){
				session.setAttribute("admin","ok");
				response.sendRedirect("frmMain.jsp?type="+type+"&user="+user);
				return;
			}
			else
			{
				response.sendRedirect("error.jsp?info=1");
			}
	}
	else
	{
		response.sendRedirect("error.jsp?info=2");
	}
	} catch (Exception e) {
		
	}
	
	
 %>