accountdao.java

distrubit account system for bank,

package Database;
import java.io.*;
import java.sql.*;
import java.text.*;
import java.util.Date;
import java.util.*;

/**
 *@author 黄素鹏 此类用来查询计划,添加计划,删除计划,清除计划;
 */
public class AccountDAO  {
	/**
	 *创建数据库连接的参数
	 */
	private static Statement statement;
	/**
	 *数据库连接参数
	 */
	private Connection connect;
	/**
	 *定义一个DAO类
	 */
	private DAO data;
	/**
	 *@param name用户名称. 用户id是唯一生产的, balance是系统自动生成的  
	 *添加帐户 
	 */
	public AccountValObj AddAcounts(String name) {
		Random random = new Random();
		float balance = Math.abs(random.nextInt())% 10000000/100f;
		String id = String.valueOf(random.nextInt());
		String url = "insert into accounts values('" + id + "', "
		+ "'" + name + "', '" + balance + "')";
		data = DAOFactory.getDAO();
		data.add(url);
		data.disconnection();
		AccountValObj vo = new AccountValObj(id, name, balance);
		return vo;
	}
	/**
	 *@param name用户名称. 用户id, balance是存款余额  
	 *添加帐户 
	 */
	public AccountValObj AddAcounts(String id, String name, float balance) {
		String url = "insert into accounts values('" + id + "', "
		+ "'" + name + "', '" + balance + "')";
		data = DAOFactory.getDAO();
		data.add(url);
		data.disconnection();
		AccountValObj vo = new AccountValObj(id, name, balance);
		return vo;
	}
	/**
	 *@param id, 根据用户的id删除帐户的信息 
	 */
	public void deleteAccounts(String id) {
		String url = "delete * from accounts where id = '" + id + "'";
		data = DAOFactory.getDAO();
		data.delete(url);
		data.disconnection();
	}
	/**
	 *@param id 根据用户的id获取用户帐户的信息. 
	 *查询帐户
	 */
	public AccountValObj getAccountById(String id) {         
		AccountValObj vo = null;
		String url = "select * from accounts where id = '" + id + "'";
		data = DAOFactory.getDAO();
		ResultSet result = data.query(url);
		try {
			 while (result.next()) {
			     vo = new AccountValObj(result.getString("id"), result.getString("name"), result.getFloat("balance"));
			 }
		} catch (SQLException e) {
			System.out.println("查询出错"+e.getMessage());
			e.printStackTrace();
		}	
		return vo;
	}
	/**
	 *@param id用户id, name用户名称, balance用户存款额. 
	 *更新帐户 
	 */
	public void uptadeAccount(String id, String name, float balance) {
		String url = "update accounts set name = '"+name+"', balance = '"+balance+"'where id = '" + id + "'";
		data = DAOFactory.getDAO();
		data.update(url);
		data.disconnection();
	}
}