f0b28eb89c36001c169685e1409e1f47

是一个网上手机超市

package hall;

import java.util.*;
import java.sql.*;
import java.text.*;
public class Eshop {
    private DBWrapper myConnection = null;
    
    /**
     * class Library constructor
     */
    public Eshop() throws Exception {
    	myConnection = DBWrapper.Instance();
    }

    public boolean checkUserName(String inName)
    throws Exception{
    	boolean flag = false;
    	ResultSet r = null;
    	String sqlQuery = "select * from customers where name='" + inName + "'" ;
    		
		r = myConnection.runQuery( sqlQuery );
		if (!r.next()) {
		    flag = false;
		}		
		else{
			flag = true;
		}
		return flag;
    }
    public boolean checkUser( String inName, String password) 
	throws Exception {
	
		String sqlQuery = "select * from customers where name='" + inName + "' and password='" + password + "'" ;
		boolean flag = false;
		ResultSet r = null;
		
		r = myConnection.runQuery( sqlQuery );
		if (!r.next()) {
		    flag = false;
		}		
		else{
			flag = true;
		}
		return flag;
    }
    public boolean addUser(User inUser){
    	try{    		
    		//String sql="insert into customers values('aaaa','wwww','[e-mail]','man','88454235','ghytyht','hj',5)";
    		String sql = "INSERT INTO customers VALUES ('" + inUser.getName() + "','" 
    			+ inUser.getPassword() + "','" + inUser.getEmail() + "','" + 
    			inUser.getSex() + "','" + inUser.getPhone() + "','" + inUser.getMobilePhone() 
    			+ "','" + inUser.getAddress() + "',"  + inUser.getAge() + ")";
    		//System.out.println(sql);
    		myConnection.runUpdate(sql);
    		return true;
    	}catch(Exception e){
    	
    		System.out.println(e.getMessage());
    		return false;
    	}
    	
    }
  //test
   /* public  static void main(String args[]){
		try{Eshop buyer = new Eshop();
		User tuser = new User("bbbbb","wwww","[e-mail]","","88454235","ghytyht","sdfsg",23);
		if(!buyer.checkUserName("bbbbb")){
			System.out.println("before");
			buyer.addUser(tuser);
		}
	}	catch(Exception e){
		System.out.println(e.getMessage());
		
	}

    }*/
    
}