veditioncompany.java

网上虚拟社区

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class VeditionCompany extends Virtualperson{
	
	public VeditionCompany(String name,String address,String password,String account,String pin){
		super(name, address, password,account, pin);
	}
	public synchronized void addSoftware(String name,String describe,Double price){
		try{
		    Connection conn = dbOperator.getConnection();
			PreparedStatement stat = conn.prepareStatement("SELECT * FROM Software WHERE itsname = ?and needer = ? ");
			stat.setString(1, name);
			stat.setString(2, this.GetName());
			ResultSet result = stat.executeQuery();
			if(result.next()){
				System.out.println("The Software has already exist!");
			}
			else{
				String query = "insert into Software( itsname, describe , price , needer) values ( ?, ?,?,?)";
				stat =conn.prepareStatement(query);
				stat.setString(1, name);	
				stat.setString(2, describe);
				stat.setDouble(3, price);	
				stat.setString(4, this.GetName());
				stat.executeUpdate();
			}
			conn.close();
			addOperator("add",price,"Software",name);
		}
		catch(SQLException ex){
			System.out.println(ex);
		}
	}
	
	public synchronized String settle(String name){
		try{
		    Connection conn = dbOperator.getConnection();
			PreparedStatement stat = conn.prepareStatement("SELECT * FROM Software WHERE itsname = ? and needer = ? and settled = 0");
			stat.setString(1, name);
			stat.setString(2, this.GetName());
			ResultSet result = stat.executeQuery();
			if(!result.next()){
				System.out.println("This Software is not exsit!");
				return null;
			}
			String query = "UPDATE Software"
					+ " SET settled = 1"
					+ " WHERE ID  = ?";
			stat =conn.prepareStatement(query);
			stat.setDouble(1, result.getDouble("ID"));
			stat.executeUpdate();
			String empolder = result.getString("empolder");
			conn.close();
			addOperator("settle",result.getDouble("price"),empolder,name);
			return empolder;
		}
		catch(SQLException ex){
			System.out.println(ex);
			return null;
		}
	}
	
	public synchronized boolean add() {
		try {
			Connection conn = dbOperator.getConnection();
			PreparedStatement stat = conn
					.prepareStatement("SELECT * FROM Virtualperson WHERE Virtualname = ?");
			stat.setString(1, this.GetName());
			ResultSet result = stat.executeQuery();
			if (!result.next()) {
				System.out.println("The Name has already exist!");
				return false;
			} else {
				stat =conn.prepareStatement("insert into Virtualperson(Password, Virtualname ,Address,Account,genere) values(?, ?,?,?,1)");
				stat.setString(1, this.GetPassword());
				stat.setString(2, this.GetName());
				stat.setString(3, this.GetAddress());
				stat.setString(4, this.GetAccount());
			    stat.executeUpdate();
			}
			conn.close();
			addOperator("add", 0, this.GetName(), "VeditionCompany");
			return true;
		} catch (SQLException ex) {
			System.out.println(ex);
			return false;
		}
	}
}