?? basedao.java
字號:
package com.acccp.fan.db;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
public class Basedao {
private static DataSource ds=null;
//private Connection conn=null;
public Basedao() {
}
//一加載類時 靜態塊就會執行
static {
try {
Context context=new InitialContext();
ds=(DataSource) context.lookup("java:comp/env/jdbc/addressBook");
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//全查 無參
public List getAllNoteBook(String sql,ResultSetHandler rsh) throws SQLException{
QueryRunner qr=new QueryRunner(ds);
List list=(List) qr.query(sql, rsh);
return list;
}
//帶參數查詢
protected List getNoteBookById(String sql,Object [] args,ResultSetHandler rsh) throws SQLException{
QueryRunner qr=new QueryRunner(ds);
List list=(List) qr.query(sql, args, rsh);
return list;
}
//增刪改
protected void execute(String sql,Object []args , ResultSetHandler rsh) throws SQLException{
PreparedStatement ps=ds.getConnection().prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1,args[i] );
}
ps.executeUpdate();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -