9018d6f2108a001d1082e5a5850663ce

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

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 boolean updateUser( UserVo user,int i){		
			
			if(i==1)
				sql="insert into user(username,password,sex,favor,qq,email,udate) values(?,?,?,?,?,?,now())";
			else if(i==2)
			{
				sql="update user set username=?,password=?,sexfavor=?,qq=?,email=?,udate=?";
			}
			 try {
					con =  DBConn.getConnection();
					ps = con.prepareStatement(sql);
					ps.setString(1, user.getUserName());
					ps.setString(2, user.getPassword());
					ps.setString(3, user.getSex());
					ps.setString(4, user.getFavor());
					ps.setString(5, user.getQq());
					ps.setString(6, user.getEmail());
					//ps.setDate(7, (java.sql.Date) user.getUdate());					
					ps.executeUpdate();	
					
				} catch (ClassNotFoundException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
					return false;
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
					return false;
				}finally{
						DBConn.closeConnection();	
				}
				return true;
			 }
//	处理用户更新操作
	 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();	
		}
	 }
	 //处理用户查询操作
	 @SuppressWarnings("deprecation")
	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");
			    	String date = rs.getTimestamp("udate").toLocaleString();
			    
			    	//Date udate=rs.getDate("udate");
			    	uservo.setEmail(email);
			    	uservo.setFavor(favor);
			    	uservo.setPassword(password);
			    	uservo.setQq(qq);
			    	uservo.setSex(sex);
			    	uservo.setUserdate(date);
			    	//uservo.setUdate(udate);
			    	uservo.setUserName(userName);
			    	list.add(uservo);
			     }
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally{
				DBConn.closeConnection();	
			}
		 
		 return list;
	 }
	 public boolean updatePassword(UserVo uservo){		
			String sql="update user set password = ? where username=?";
			boolean isUpdate=false;
			try {
				con =  DBConn.getConnection();
				ps = con.prepareStatement(sql);
				ps.setString(1,uservo.getPassword());
				ps.setString(2,uservo.getUserName());
				
				ps.executeUpdate();
			    isUpdate = 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 isUpdate;
		
		}
	 public static void main(String args[])
	 {
		 UserDao userDao = new UserDao();
		 String sql = "select * from user";
		 List list = new ArrayList();
	 }
}