?? accountdao.java
字號:
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();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -