adminlogindaoimpl.java

struts2+spring+Hibernate整合的一个网站案例

package myitem.dao.impl;
import myitem.dao.*;
import myitem.db.*;
import myitem.vo.*;
import java.sql.*;
import java.util.*;
import java.util.Date;

public class AdminLoginDAOImpl implements AdminLoginDAO {
	
	public boolean login(AdminLogin adminlogin) throws Exception
	{
		boolean flag = false ;
		String sql = "SELECT adminname,adminpassword,updegree,lasttime,now,id,lasttimee FROM adminlogin WHERE adminname=? and adminpassword=?" ;
		PreparedStatement pstmt = null ;
		ConnectionDatabase dbc = null ;
		dbc = new ConnectionDatabase() ;
		String sql1="update adminlogin set lasttime=?,lasttimee=?,updegree=? where id=? ";
		
		try
		{
			pstmt = dbc.getConn().prepareStatement(sql) ;
			pstmt.setString(1,adminlogin.getAdminname());
			pstmt.setString(2,adminlogin.getAdminpassword());
			ResultSet rs = pstmt.executeQuery() ;
			if(rs.next())
			{
				flag = true ;
				adminlogin.setAdminname(rs.getString(1));
				adminlogin.setAdminpassword(rs.getString(1));
				adminlogin.setUpdegree(rs.getInt(3));
				adminlogin.setLasttime(rs.getString(4));
				adminlogin.setNow(rs.getBoolean(5));
				adminlogin.setId(rs.getInt(6));
				adminlogin.setLasttimee(rs.getString(7));
				
			
				try
				{
					pstmt = dbc.getConn().prepareStatement(sql1);
					pstmt.setDate(1,new java.sql.Date(System.currentTimeMillis()));
					pstmt.setTime(2,new Time(System.currentTimeMillis()));
					pstmt.setInt(3, adminlogin.getUpdegree()+1);
					pstmt.setInt(4, adminlogin.getId());
					pstmt.executeUpdate();
				}
				catch(Exception e)
				{
					
				}
			}
			rs.close() ;
			pstmt.close();
		}
		catch (Exception e)
		{
			throw new Exception("操作出现错误！！！");
		}
		finally
		{
			dbc.close() ;
		}
		
		return flag ;
		
		
	}
}