userinfo.java

用java实现的一个bbs的portal

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Jul 19, 2003
 * Time: 2:51:31 PM
 * To change this template use Options | File Templates.
 */
package Kernel;

import DBConnection.DBBridge;

import java.sql.ResultSet;
import java.text.SimpleDateFormat;


public class UserInfo {
    private String id;
    private String password;
    private String city;
    private String address;
    private String telephone;
    private String mobile;
    private String email;
    private String reputation;
    private String registerdate;
    private String lastvisitdate;
    private String visittimes;

    private static SimpleDateFormat TimeFormatStr = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");

    public UserInfo(){

    }

    public UserInfo(String id,String password,String city,String address,String telephone
                    ,String mobile,String email,String reputation,String registerdate,String lastvisitdate){
        this.id = id;
        this.password = password;
        this.city = city;
        this.address = address;
        this.telephone = telephone;
        this.mobile = mobile;
        this.email = email;
        this.reputation = reputation;
        this.registerdate = registerdate;
        this.lastvisitdate = lastvisitdate;
    }

    public boolean insertUserInfo(){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "INSERT INTO YONGHU " +
                    "(ID, PASSWORD, CITY, ADDRESS, TELEPHONE, MOBILE, EMAIL, REPUTATION,REGISTERDATE,LASTVISITDATE) " +
                    "VALUES ('"+id+"', '"+password+"', '"+city+"', '"+address+"', '"+telephone+"', '"+mobile+"', '"+email+"', '"+reputation+"', '"+registerdate+"', '"+lastvisitdate+"')";
            System.out.println(sql);
            //DBConnector.getInstance().stmt.execute(sql);
            bridge.getStmt().execute(sql);
            bridge.setConnectionSwitch("off");
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public boolean updateUserInfo(){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "update YONGHU set PASSWORD='"+password+"',CITY='"+city+"', ADDRESS='"+address
                    +"', TELEPHONE='"+telephone+"', MOBILE='"+mobile+"', EMAIL='"+email+"' where ID='"+id+"'" ;
            System.out.println(sql);
            //DBConnector.getInstance().stmt.execute(sql);
            bridge.getStmt().execute(sql);
            bridge.setConnectionSwitch("off");
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public  boolean updateLastVisit(String id,String lastvisit){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "update YONGHU set LASTVISITDATE = '"+lastvisit+"' where ID ='"+id+"'";
            //DBConnector.getInstance().stmt.execute(sql);
            bridge.getStmt().execute(sql);
            bridge.setConnectionSwitch("off");
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public  boolean addVisitTimes(String id){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "update YONGHU set VISITTIMES = VISITTIMES+1 where ID ='"+id+"'";
            //DBConnector.getInstance().stmt.execute(sql);
            bridge.getStmt().execute(sql);
            bridge.setConnectionSwitch("off");
            return true;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public  boolean login(String id,String password){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "select * from YONGHU WHERE id='"+id+"' and password='"+password+"'";
            ResultSet rs = bridge.getStmt().executeQuery(sql);
            bridge.setConnectionSwitch("off");
            return rs.next();
        }catch(Exception ex){
            ex.printStackTrace();
            comTool.ServerAdapterLog.error(ex.toString());
        }
        bridge.setConnectionSwitch("off");
        return false;
    }

    public  String getUserInfo(String userid){
        DBBridge bridge = new DBBridge();
        try{
            String sql = "select * from YONGHU WHERE id='"+userid+"'";
            ResultSet rs = bridge.getStmt().executeQuery(sql);
            bridge.setConnectionSwitch("off");
            if (rs.next()){
                password = rs.getString("PASSWORD");
                city = comTool.getChineseStr(rs.getString("CITY"));
                address = comTool.getChineseStr(rs.getString("ADDRESS"));
                telephone = comTool.getChineseStr(rs.getString("TELEPHONE"));
                mobile = comTool.getChineseStr(rs.getString("MOBILE"));
                email = comTool.getChineseStr(rs.getString("EMAIL"));
                reputation = rs.getString("REPUTATION");
                registerdate = rs.getString("REGISTERDATE");
                lastvisitdate = rs.getString("LASTVISITDATE");
                visittimes = rs.getString("VISITTIMES");
                String userinfo = city+"%"+address+"%"+telephone+"%"+mobile
                        +"%"+email+"%"+reputation+"%"+registerdate+"%"+lastvisitdate+"%"+visittimes+"%"+userid+"%"+password;
                return userinfo;
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }
        bridge.setConnectionSwitch("off");
        return null;
    }

     public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getTelephone() {
        return telephone;
    }

    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

    public String getMobile() {
        return mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getReputation() {
        return reputation;
    }

    public void setReputation(String reputation) {
        this.reputation = reputation;
    }

    public String getRegisterdate() {
        return registerdate;
    }

    public void setRegisterdate(String registerdate) {
        this.registerdate = registerdate;
    }

    public String getLastvisitdate() {
        return lastvisitdate;
    }

    public void setLastvisitdate(String lastvisitdate) {
        this.lastvisitdate = lastvisitdate;
    }

    public String getVisittimes() {
        return visittimes;
    }

    public void setVisittimes(String visittimes) {
        this.visittimes = visittimes;
    }

    public static void main(String[] args) {
        //System.out.println(UserInfo.login("letter","letter"));
    }

}