?? empdao.java
字號:
package com.yiboit.hhs.daos;
import java.sql.SQLException;
import java.util.List;
import javax.sql.DataSource;
import com.yiboit.hhs.EmpBean;
import com.yiboit.hhs.db.BaseDAO;
public class EmpDAO extends BaseDAO {
private static final String QUERY = "select emp_id as empId"
+ ", emp_name as empName, emp_sex as empSex"
+ ", dept_id as deptId, salary " + " from emp where emp_id = ?";
private String empId;
private EmpBean empBean;
public EmpBean getEmpBean() {
return empBean;
}
public void setEmpId(String empId) {
this.empId = empId;
}
public EmpDAO(DataSource ds) throws SQLException {
super(ds);
}
@Override
public void databaseAccess() throws SQLException {
try {
empBean = (EmpBean) sqlUtil.selectStrictSingle(QUERY,
new Object[] { empId }, EmpBean.class);
} finally {
sqlUtil.close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -