00d2e8d8b0f9001d1b54d855449cfbc1

java做的个人通讯录 仅供初学者参考！

package Finance;

import java.sql.*;
import java.util.*;
import Finance.Bean;
import Finance.DBUtil;

public class DAO {
	/**
	 * 插入数据的方法
	 * @param item
	 * @param income
	 * @param count
	 * @param name
	 * @param time
	 * @return
	 */
	public boolean addBalance(String item,String income,double count,String name,String time) {
		ArrayList al=new ArrayList();
		DBUtil db=new DBUtil();
		try {
			java.sql.Connection con=db.getConnection();
		    String sql="insert into balance values(?,?,?,?,?)";
		    java.sql.PreparedStatement ps=con.prepareStatement(sql);
		    if(income == "支出") {
		    	income="0";
		    }
		    else {
		    	income="1";
		    }
		    ps.setString(1, item);
		    ps.setString(2, income);
		    ps.setDouble(3, count);
		    ps.setString(4, name);
		    ps.setString(5, time);
		   
		    int sult=ps.executeUpdate();
		    if(sult>0) {
		    	return true;
		    }
		    db.close(ps, con);
		}
		catch(java.sql.SQLException sqle) {
			 sqle.printStackTrace();
		}
		return false;
		
	}
	
	public ArrayList queryBalance(String name) {
		ArrayList al=new ArrayList();
		DBUtil db=new DBUtil();
		try {
			java.sql.Connection con=db.getConnection();
		    String sql="select * from balance where name=?";
		    java.sql.PreparedStatement ps=con.prepareStatement(sql);
		    ps.setString(1, name);
		    
		    java.sql.ResultSet rs=ps.executeQuery();
		    Bean gb=new Bean();
		    
		    while(rs.next()) {
		    	gb.setMItem(rs.getString(1));
		    	if(rs.getString("income") == "0") {
		    		gb.setMIncome("支出");
		    	}
		    	else {
		    		gb.setMIncome("收入");
		    	}
		    	
		    	gb.setMMoney(rs.getDouble(3));
		    	gb.setMName(rs.getString(4));
		    	gb.setMTime(rs.getString(5));
		    	al.add(gb.toString());
		    }
		    db.close(ps, rs, con);
		}
		
		catch(java.sql.SQLException sqle) {
			 sqle.printStackTrace();
		}
		return al;
	}

}