package com.allanlxf.jdbc.orm.dao;

import java.sql.*;
import java.util.*;
import com.allanlxf.jdbc.core.Account;

import com.allanlxf.jdbc.util.ConnectionFactory;
import com.allanlxf.jdbc.util.JdbcUtil;

public class AccountDao
{
    public void insert(Account account)
    {
        Connection con = null;
        PreparedStatement ps = null;
        con = ConnectionFactory.getConnection();
        String sql = "insert into sd0703_account(id, no, pwd,owner, balance, cdate)";
        sql += " values(?,?,?,?,?,?)";
        
        account.setId(IdGenerator.nextId());
        ps = con.prepareStatement(sql);
        
        int index = 1;
        ps.setInt(index++, account.getId());
        ps.setString(index++, account.getNo());
        ps.setString(index++, account.getPassword());
        ps.setString(index++, account.getOwner());
        ps.setDouble(index++, account.getBalance());
        ps.setDate(index++, account.getCreateDate());
        
        ps.executeUpdate();
    }    
}