905e815ac586001d1397f68d816f33bb

一个相对比较简单的留言簿！功能还比较齐全！

package com.pure35.database;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.pure35.vo.UserVo;
import com.pure35.database.DBConn;

public class UserDao {
	  static Connection con = null;
	  PreparedStatement ps = null;
	  ResultSet rs = null;
	  String sql = "";
	  UserVo uservo;
	  
	  //登陆时验证用户和密码,返回真和假
	 public boolean login (String sql)
	  {
		 boolean isLogin = false;
		try {
			con =  DBConn.getConnection();
			ps = con.prepareStatement(sql);		
			rs = ps.executeQuery();
			while(rs.next())
		     {
		    	 if(rs.getInt("mycount")==1)
		    	 {
		    		 isLogin = true ;
		    	 }	    	 
		     }
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
				DBConn.closeConnection();	
		}
		
		return isLogin;
	  }
//	处理用户更新操作
	 public void UpdateUser(String sql){		
		try {
			con =  DBConn.getConnection();
			ps = con.prepareStatement(sql);
			ps.executeUpdate();	
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}finally{
				DBConn.closeConnection();	
		}
	 }
	 //处理用户查询操作
	 public List queryUser(String sql ){
			
		 List list=new ArrayList();
		 try {
				con =  DBConn.getConnection();
				ps = con.prepareStatement(sql);		
				rs = ps.executeQuery();
				while(rs.next())
			     {
			    	uservo=new UserVo();
			    	String userName=rs.getString("username");
			    	String password=rs.getString("password");
			    	String sex=rs.getString("sex");
			    	String favor=rs.getString("favor");
			    	String qq=rs.getString("qq");
			    	String email=rs.getString("email");
			    	Date udate=rs.getDate("udate");	
			    	list.add(uservo);
			     }
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}	 
		 
		 return list;
	 }
	 
	 
}