virtualcommunity.java

网上虚拟社区

	}
	
	public boolean addvirtual(String name,String password,double a,String Address,String Account){
		try {
			Connection conn = dbOperator.getConnection();
			PreparedStatement stat = conn
					.prepareStatement("SELECT * FROM Virtualperson WHERE Virtualname = ? and genere = ?");
			stat.setString(1, name);
			stat.setDouble(2, a);
			ResultSet result = stat.executeQuery();
			if (result.next()) {
//				System.out.println(result.next());
				System.out.println("The Name has already exist!");
				conn.close();
				return false;
			} else {
				stat =conn.prepareStatement("insert into Virtualperson(Password, Virtualname ,Address,Account,genere) values(?, ?,?,?,?)");
				stat.setString(1, password);
				stat.setString(2, name);
				stat.setString(3, Address);
				stat.setString(4, Account);
				stat.setDouble(5, a);
				stat.executeUpdate();
			}
			conn.close();
			if(a==1)
			      addOperator(name,"add", 0, name, "VeditionCompany");
			else if(a==0)
				  addOperator(name,"add", 0, name, "Virtualperson");
			else if(a==2)
				  addOperator(name,"add", 0, name, "EmpolderCompany");
			return true;
		} catch (SQLException ex) {
			System.out.println(ex);
			return false;
		}
	}
	public double findBalance(String No,String pin){
		try{
			double balance = thebank.findBalance(No, pin);
			if(balance<0) {
				System.out.println("No balance find!");	
				return -1;
			}
			else
				return balance;		
		}
		catch(Exception ex){
			System.out.println(ex);
			return -1;
		}
	}
	
	public Vector finddatabase(String table,int a,String name)throws SQLException{
		Connection conn = dbOperator.getConnection();
		try {
			String query = "select * from "+table; 
			if(a == 2){
				query += " where settled = 0";
			}
			else if(a == 3){
				query += " where settled = 1 and empolder =  ?";
			}
			else if(a == 0){
				query +=" where settled = 2 and needer = ?";
			}
			else if(a == 1){
				query +=" where settled = 0 and needer = ?";
			}
			else if(a == 5){
				query +=" where settled = 2 ";
			}
//			System.out.println(query);
			PreparedStatement stat = conn.prepareStatement(query);
			if(a==3||a == 0||a == 1){
			stat.setString(1, name);
			}
			ResultSet result = stat.executeQuery();
            Vector data = new Vector();
            if(a==4){
                while(result.next()){
                	 data.add(result.getString(2));
                     data.add(String.valueOf(result.getString(3)));
                     data.add(String.valueOf(result.getString(4)));
                     data.add(String.valueOf(result.getString(5)));
            	   
               }
            }
            else if(a == 2||a == 3){
            	while(result.next()){
               	 	data.add(result.getString(2));
               	 	data.add(result.getString(3));
               	 	data.add(result.getString(5));
               	 	data.add(String.valueOf(result.getString(4)));
               	 	data.add(result.getString(7));
            	}
            }
            else if(a == 0){
            	while(result.next()){
                  	 data.add(result.getString(2));
                     data.add(result.getString(3));
                     data.add(String.valueOf(result.getString(9)));
                     data.add(String.valueOf(result.getString(8)));
            	}
            }
            else if(a == 1){
            	while(result.next()){
                  	 data.add(result.getString(2));
                     data.add(result.getString(3));
                     data.add(String.valueOf(result.getString(4)));
                     data.add(result.getString(7));
                     data.add(String.valueOf(result.getString(6)));
            	}
            }
            else if(a == 5){
            	while(result.next()){
                  	 data.add(result.getString(2));
                     data.add(String.valueOf(result.getString(4)));
                     data.add(result.getString(5));
                     data.add(result.getString(7));
                     data.add(String.valueOf(result.getString(9)));
            	}
            }
            return data;

		} finally {
			conn.close();
		}
	}
	
	
	public boolean changepin(String No,String pin,String newpin){
		try{
           return  thebank.changepin(No, pin, newpin);
		}
		catch(Exception ex){
			System.out.println(ex);
			return false;
		}
	}
	
	public boolean withdraw(String No,String pin,double num){
		try{
           return  thebank.withdraw(No, pin, num);
		}
		catch(Exception ex){
			System.out.println(ex);
			return false;
		}
	}
	
	public boolean deposit(String No,String pin,double num){
		try{
           return  thebank.deposit(No, pin, num);
		}
		catch(Exception ex){
			System.out.println(ex);
			return false;
		}
	}
	
	public boolean deposit(String No,double num){
		try{
           return  thebank.deposit(No, num);
		}
		catch(Exception ex){
			System.out.println(ex);
			return false;
		}
	}
	
	public Virtualperson findperson(String name,String password) throws SQLException{
		Connection conn = dbOperator.getConnection();
		try {
			Virtualperson c = null;
//			System.out.println("here");
			String query = "select * from Virtualperson where Virtualname = ? and genere = 0";
			PreparedStatement stat = conn.prepareStatement(query);
			stat.setString(1, name);
			ResultSet result = stat.executeQuery();
			if (result.next() && password.equals(result.getString("Password"))){
				c = new Virtualperson(name,
						        result.getString("Address"),password,
						        result.getString("Account"));
				conn.close();
			    return c;
			}
			else
				return null;
		} finally {
			conn.close();
		}
	}
	
	
	public Virtualperson findVedition(String name,String password) throws SQLException{
		Connection conn = dbOperator.getConnection();
		try {
			VeditionCompany c = null;
			String query = "select * from Virtualperson where Virtualname = ? and genere = 1";
			PreparedStatement stat = conn.prepareStatement(query);
			stat.setString(1, name);
			ResultSet result = stat.executeQuery();
			if (result.next() && password.equals(result.getString("Password"))){
				c = new VeditionCompany(name,
						         result.getString("Address"),password,
						        result.getString("Account"),null);
		    return c;
		}
		else
			return null;
		} finally {
			conn.close();
		}
	}
	
	public Virtualperson findEmpolder(String name,String password) throws SQLException{
		Connection conn = dbOperator.getConnection();
		try {
			EmpolderCompany c = null;
			String query = "select * from Virtualperson where Virtualname = ? and genere = 2";
			PreparedStatement stat = conn.prepareStatement(query);
			stat.setString(1, name);
			ResultSet result = stat.executeQuery();
			if (result.next() && password.equals(result.getString("Password"))){
				c = new EmpolderCompany(name,
						        result.getString("Address"),password,
						        result.getString("Account"),null);
			    return c;
			}
			else
				return null;
		} finally {
			conn.close();
		}
	}
	
	public boolean findAccount(String Account,String pin){
		try{
		  return thebank.findAccount(Account,pin);
		}
		catch(Exception ex){
			System.out.println(ex);
			return false;
		}
		
	}
	
	public  void addOperator(String name ,String operator, double money,
			String object, String goods) {
		try {
			Connection conn = dbOperator.getConnection();
			PreparedStatement stat = conn
					.prepareStatement("insert into Operator values(?,?,?,?,?)");
			stat.setString(1, name);
			stat.setString(2, operator);
			stat.setDouble(3, money);
			stat.setString(4, object);
			stat.setString(5, goods);
			stat.executeUpdate();
			conn.close();
		} catch (SQLException ex) {
			System.out.println(ex);
		}
	}
}