src/bean/Login.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package bean;

import java.sql.*;
import java.util.ArrayList;

import form.MessageForm;



public class Login {

	Connection conn = null;
	Connection conn1 = null;
	Statement st = null;
	ResultSet rs = null;
	Statement st1 = null;
	ResultSet rs1 = null;
	boolean bool = false;
	ArrayList arr =null;
	
	/**
	 * 登陆
	 * @param name
	 * @param pwd
	 * @return
	 */
	public MessageForm getLogin(String name,String pwd,String type){
	
		String sql = "";

		MessageForm messageForm = new MessageForm();
		 try{
			 
			 	if("0".equals(type))//0,管理员，1学生，2教师
			 		sql = "select * from admin where loginname='"+name+"' and loginpwd='"+pwd+"'";
			 	else if("1".equals(type))
			 		sql = "select * from student where loginname='"+name+"' and loginpwd='"+pwd+"'";
			 	else if("2".equals(type))
			 		sql = "select * from teacher where loginname='"+name+"' and loginpwd='"+pwd+"'";
				
	            conn = DBConn.getConn(); 
	            st=conn.createStatement();
	            rs=st.executeQuery(sql);
	            
	            if(rs.next()){
	            	
	            	messageForm.setUsersId(rs.getString("id"));
	            	messageForm.setUsername(rs.getString("username"));
	            	messageForm.setLogo(type);	 	  //0,管理员，1学生，2教师
	            	return messageForm;
	            }else{
	            	return null;
	            }
	            
	            
	        }catch(Exception ex){
	            ex.printStackTrace();
	            return null;
	        }finally{
	        	try{