usermanager.java

来自「jsp和servlet开发的bbs」· Java 代码 · 共 60 行

package bbs.ahut.javabean;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;

import bbs.ahut.db.DbConSql;

public class UserManager {
		DbConSql db=new DbConSql();
		public boolean add(UserBean user){
			    String sql="insert into users(userno,password,username,email,createTime,beforeTime) values('"+user.getUserno()+"','"+user.getPassword()+"','"+user.getUsername()+"','"+user.getEmail()+"','"+user.getDate()+"','"+user.getDate()+"')";
			    String sql2="select * from users where userno='"+user.getUserno()+"'";
			  
			    try {
					if(db.getQuery(sql2).next()){
						return false;
					}else{	 
					    db.insert(sql);
					}
				} catch (SQLException e) {
					e.printStackTrace();
				}
			  
				
	    return true;
			 
		} 
	
		
		public UserBean findUser(UserBean user){
		    String sql="select * from users where userno='"+user.getUserno()+"' and password='"+user.getPassword()+"'";
		    UserBean user1=new UserBean();
		    ResultSet rs;
		    try {
		        rs=db.getQuery(sql);
				if(!rs.next()){
					return null;
				}else{
					user1.setUserno(rs.getString("userno"));
					user1.setUsername(rs.getString("username"));
					user1.setBefdate(rs.getString("beforeTime"));
					user1.setDate(rs.getString("createTime"));
					user1.setFaTie(rs.getInt("zhuTie"));
					user1.setHuiTie(rs.getInt("huiTie"));
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
	        return user1;
	    }
		
		public void updateBeforeTime(UserBean user){
			SimpleDateFormat formatter=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");   
			String beforeTime=formatter.format(new Date()); 
			String sql="update users  set beforeTime='"+beforeTime+"' where userno='"+user.getUserno()+"'";
			db.update(sql);
		}
}