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