?? managerdao.java
字號(hào):
package com.dao;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder;
import com.ibatis.common.resources.Resources;
import java.io.Reader;
import com.actionForm.ManagerForm;
import java.sql.*;
import java.util.List;
import com.ibatis.common.util.PaginatedList;
public class ManagerDao {
public SqlMapClient sqlMap;
public void getSqlMapClient() {
try {
String resource = "DataAccess.xml";
Reader reader = Resources.getResourceAsReader(resource);
XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder();
sqlMap = xmlBuilder.buildSqlMap(reader);
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException("Error initializing SqlConfig. Cause: " +
e);
}
}
//添加操作員的方法
public boolean insertManager(ManagerForm managerForm) {
try {
sqlMap.insert("insertManager", managerForm);
return true;
} catch (SQLException ex) {
return false;
}
}
//操作員分頁查詢
public PaginatedList selectManagerList() {
PaginatedList list = null;
try {
sqlMap.startTransaction();
list = sqlMap.queryForPaginatedList("selectManager", null,13);
sqlMap.commitTransaction();
} catch (SQLException ex) {
}
return list;
}
//操作員全部查詢
public List selectManager() {
List list = null;
try {
sqlMap.startTransaction();
list = sqlMap.queryForList("selectManager",null);
sqlMap.commitTransaction();
} catch (SQLException ex) {
}
return list;
}
//以操作員為條件查詢的方法
public ManagerForm selectManager(ManagerForm managerForm) {
ManagerForm form = null;
try {
sqlMap.startTransaction();
form = (ManagerForm) sqlMap.queryForObject("selectManager",managerForm);
sqlMap.commitTransaction();
} catch (SQLException ex) {
}
return form;
}
//以操作員賬號(hào)為條件修改操作員的密碼和權(quán)限
public boolean updateManager(ManagerForm managerForm) {
try {
sqlMap.update("updateManager", managerForm);
return true;
} catch (SQLException ex) {
return false;
}
}
//以操作員賬號(hào)為條件刪除操作員
public boolean deleteManager(ManagerForm managerForm) {
try {
sqlMap.delete("deleteManager", managerForm);
return true;
} catch (SQLException ex) {
return false;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -