jdbcaccountdao.java

来自「达内IT培训Java DAO 源码 是学习Java用DAO方式连接数据库编程的」· Java 代码 · 共 77 行

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import service.Account;

public class JdbcAccountDao implements AccountDao {
	

	public void deposit(long id, double amount) {
		Connection con=null;
		PreparedStatement ps=null;
		try {
			con=JdbcUtil.getConnection();
			String sql="update account set balance=balance+? where id=?";
			ps=con.prepareStatement(sql);
			ps.setDouble(1, amount);
			ps.setLong(2, id);			
			ps.executeUpdate();			
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException(e);
		}finally{
			JdbcUtil.close(null, ps, con);
		}

	}
	public void withdraw(long id, double amount) {
		Connection con=null;

	}

	public List<Account> findByName(String name) {
		Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		try {
			con=JdbcUtil.getConnection();
			String sql="select * from account where name=?";
			ps=con.prepareStatement(sql);
			ps.setString(1, name);
			rs=ps.executeQuery();	
			
			List<Account> list=new ArrayList<Account>();
			
			while(rs.next()){
				long id=rs.getLong(1);
				String name1=rs.getString(2);
				double balance=rs.getDouble(3);
				list.add(new Account(id,name,balance));
			}
			
			return list;
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException(e);
		}finally{
			JdbcUtil.close(null, ps, con);
		}
	}

	public Account findByPk(long id) {
		return null;

	}

	public long newAccount(String name, double amount) {
		// TODO Auto-generated method stub
		return 0;
	}

}