timemaker.java

仿校内网站

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package myTools;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Calendar;

/**
 *
 * @author Administrator
 */
public class TimeMaker {
    public static String getTime(){
        Calendar calCurrent=Calendar.getInstance(); 
        calCurrent.add(Calendar.HOUR_OF_DAY, 8);
        int intDay=calCurrent.get(Calendar.DATE); 
        int intMonth=calCurrent.get(Calendar.MONTH)+1; 
        int intYear=calCurrent.get(Calendar.YEAR); 
        int inthour = calCurrent.get(Calendar.HOUR_OF_DAY);
        int intmin = calCurrent.get(Calendar.MINUTE);
        int intsec = calCurrent.get(Calendar.SECOND);
        return intYear+"-"+intMonth+"-"+intDay+"-"+inthour+"-"+intmin+"-"+intsec;
    }
    
    public static ArrayList<String> getFriends(String last_visit){
        ArrayList<String> friends = new ArrayList<String>();
        if(last_visit == null){
            System.out.println("NO FRIENDS VISIT");
        }else{
            int number = last_visit.length()/5;
            System.out.println("Friends has " + number);
            while(number > 0){
                friends.add(last_visit.substring(number*5-4, number*5));
                number--;
            }
        }
        return friends;
    }
	
	public static void makeVisitor(String visitor_id, String host_id){
                System.out.println(visitor_id + "   " + host_id);
		DataBase db = new DataBase();
                db.connectToDB();
		ResultSet rs = null;
		String sql = "select last_visit from users where user_id = " + host_id;
		rs = db.executeQuery(sql);
		String last_visit = "";
                try{
		if(rs.next()){
			last_visit = rs.getString(1);
		}
                }catch(Exception ee){
                    System.out.println("*********************************");
                    System.out.println("MAKE FRIENDS ERRORs");
                }
                System.out.println(last_visit);
                if(last_visit != null){
                    if(!last_visit.contains(new StringBuffer(visitor_id))){
			if(last_visit.length() == 15){
				last_visit = last_visit.substring(5, 14);
			}
			last_visit += ("_" + visitor_id);
			sql = "update users set last_visit = '" + last_visit + "' where user_id = " + host_id;
			db.executeUpdate(sql);	
                    }
                }else{
                    last_visit = ("_" + visitor_id);
                    sql = "update users set last_visit = '" + last_visit + "' where user_id = " + host_id;
                    System.out.println(sql);
                    db.executeUpdate(sql);	
                }
		db.close();
	}
        public static void makeFriends(String user1_id, String user2_id, String time){
            DataBase db = new DataBase();
            db.connectToDB();
            ResultSet rs = null;
            String sql = "select * from users where user_id = " + user1_id;
            String sql2 = "select * from users where user_id = " + user2_id;
            rs = db.executeQuery(sql);
            try{
                if(rs == null){
                    sql = "update users set friends = '" + ("_" + user2_id) + "' where user_id = " + user1_id;
                    System.out.println(sql);
                }else{
                    if(rs.next()){
                        String temp = rs.getString("friends");
                        if(temp == null){ temp = "";}
                        sql = "update users set friends = '" + (temp + "_" + user2_id) + "' where user_id = " + user1_id;
                        System.out.println(sql);
                    }
                }
                db.executeUpdate(sql);
            }catch(Exception eeeee){
                System.out.println("Make Friend Error");
            }
            rs = db.executeQuery(sql2);
            try{
                if(rs == null){
                    sql2 = "update users set friends  = '" + ("_" + user1_id) + "' where user_id = " + user2_id;
                    System.out.println(sql2);
                }else{
                    if(rs.next()){
                        String temp = rs.getString("friends");
                        if(temp == null){ temp = "";}
                        sql2 = "update users set friends = '" + (temp + "_" + user1_id) + "' where user_id = " + user2_id;
                        System.out.println(sql2);
                    }
                }
                db.executeUpdate(sql2);
            }catch(Exception eeeeeee){
                System.out.println("Make Friends Error");
            }
        }
        
        public static String getError(String id){
            if(id != null){
                if(id.equals("1")){
                    return "Can't message to yourself";
                }else if(id.equals("2")){
                    return "Can't make friend with yourself";
                }else if(id.equals("3")){
                    return "Not Right to Delete the Message";
                }
            }
            return "Undefined Error";
        }
}