studentlogindao.java

中应用程序的访问权限对Java Web Console 中应用程序的访问权限 成功登录 Web 控制台后,可能无法自动访问在该控制台中注册的所有应用程序。通常,必须安装应用程序,才能让所有的用户在控制

package edu.yinhe.mis.model;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import edu.yinhe.mis.dto.StudentLoginDTO;
import edu.yinhe.mis.vo.StudentLoginVO;
import edu.yinhe.system.model.BaseDAO;

/**
 * 
 * @author 姜敏
 *
 */

public class StudentLoginDAO  extends BaseDAO {

	public Object Permissionlist(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	public Object delete(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return false;
	}

	public Object find() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	public Object findAll() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}


	public Object findById(Object arg0) throws SQLException {
		String SQL= "" ;
		StudentLoginVO slvo=null;
		PreparedStatement ps=null;
		ResultSet rs = null;
		
		StudentLoginDTO sldto=(StudentLoginDTO)arg0;
			SQL="SELECT *  FROM STUDENTLOGIN WHERE stu_no=? and class_no=? and password=?";
			ps=conn.prepareStatement(SQL);
			ps.setInt(1,sldto.getStuNo() );
			ps.setString(2,sldto.getClassNo() );
			ps.setString(3,sldto.getPassword() );
			
			rs=ps.executeQuery();
			while(rs.next()){
				slvo = new StudentLoginVO();
				slvo.setId(rs.getInt("id"));
				slvo.setClassNo(rs.getString("class_no"));
				slvo.setSutNo(rs.getInt("stu_no"));
				slvo.setPassword(rs.getString("password"));
				
			}
			if(ps!=null){
			ps.close();
			SQL=null;}
				
		return slvo;
		
	}

	public int getCount(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return 0;
	}

	public Object getMaxId(String arg0) throws SQLException {
		// TODO Auto-generated method stub
		return 0;
	}

	public Object insert(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return false;
	}


	public Object findAll(Object arg0) throws SQLException {
		
		return arg0;
		}
	
	
	
	/**
	 * 修改密码
	 */
	public Object update(Object arg0) throws SQLException {
		StudentLoginDTO sldto=(StudentLoginDTO)arg0;
		String SQL= "" ;
		PreparedStatement ps=null;
		boolean flag =false;
		
		
			SQL="UPDATE studentlogin SET PASSWORD=? WHERE stu_no=?";
			ps=conn.prepareStatement(SQL);
			ps.setString(1,sldto.getPassword());
			ps.setInt(2,sldto.getId());
			int i = ps.executeUpdate();
			if(i!=-1)
			{
				flag=true;
			}
			if(ps!=null)
			ps.close();
			SQL=null;
	return flag;
	}



}