📄 areainfoehdaoimp.java
字号:
package imis_hous.com.impl;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import imis_hous.com.db.DBClose;
import imis_hous.com.bean.AreaInfoEH;
import imis_hous.com.dao.AreaInfoEHDAO;
import imis_hous.com.pub.interfaces.PageCount;
import cmis.database.DBPoolManager;
public class AreaInfoEHDAOImp implements AreaInfoEHDAO, PageCount {
public AreaInfoEHDAOImp() {
}
public int totalRecord = 0;
public int record_per_page = 15;
public int getAllRecords() {
return totalRecord;
}
public int getAllPages() {
return (totalRecord + record_per_page - 1) / record_per_page;
}
public boolean add(AreaInfoEH area) {
boolean flag = false;
DBPoolManager dbpool = new DBPoolManager();
Connection conn = null;
Statement stmt = null;
DBClose dbclose = new DBClose();
String sql = "insert into area_info(AreaNu,AreaName,AreaAddr,AreaSize,AreaStatus,AreaIs,UsedBy,UsedFor,AreaKind,OterAu,AreaIdNo,AreaFrom,EndDate,ReMark,Memo) "
+ "values('"
+ area.getAreaNu()
+ "','"
+ area.getAreaName()
+ "','"
+ area.getAreaAddr()
+ "',"
+ area.getAreaSize()
+ ","
+ area.getAreaStatus()
+ ","
+ area.getAreaIs()
+ ",'"
+ area.getUsedBy()
+ "','"
+ area.getUsedFor()
+ "','"
+ area.getAreaKind()
+ "','"
+ area.getOterAu()
+ "','"
+ area.getAreaIdNo()
+ "','"
+ area.getAreaFrom()
+ "', to_date('"
+ area.getValiDate()
+ "','yyyy-mm-dd'), "
+ area.getReMark() + ",'" + area.getMemo() + "')";
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement();
//System.out.print(sql);
int i = stmt.executeUpdate(sql);
flag = i > 0 ? true : false;
dbpool.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
dbpool.rollback();
} finally {
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
// TODO Auto-generated method stub
return flag;
}
public boolean delete(String areaNu) {
boolean flag = false;
DBPoolManager dbpool = new DBPoolManager();
Connection conn = null;
Statement stmt = null;
DBClose dbclose = new DBClose();
String sql = "delete from area_info where AreaNu='" + areaNu + "'";
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement();
int i = stmt.executeUpdate(sql);
flag = i > 0 ? true : false;
dbpool.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
dbpool.rollback();
} finally {
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
// TODO Auto-generated method stub
return flag;
}
public List getSelect(String areaNu) {
// TODO Auto-generated method stub
DBPoolManager dbpool = new DBPoolManager();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
AreaInfoEH area = null;
DBClose dbclose = new DBClose();
List L_AreaInfoEH = new ArrayList();
String sql = "select * from area_info where 1=1";
if (areaNu.length() != 0) {
sql += " and areaNu='" + areaNu + "'";
}
// sql = "select * from area_info where AreaNu='" + name + "'";
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
area = new AreaInfoEH();
area.setAreaNu(rs.getString("AreaNu"));
area.setAreaName(rs.getString("AreaName"));
area.setAreaAddr(rs.getString("AreaAddr"));
area.setAreaSize(rs.getFloat("AreaSize"));
area.setAreaStatus(rs.getInt("AreaStatus"));
area.setAreaIs(rs.getInt("AreaIs"));
area.setReMark(rs.getInt("ReMark"));
area.setMemo(rs.getString("Memo"));
area.setUsedBy(rs.getString("UsedBy"));
area.setUsedFor(rs.getString("UsedFor"));
area.setAreaKind(rs.getString("AreaKind"));
area.setOterAu(rs.getString("OterAu"));
area.setAreaIdNo(rs.getString("AreaIdNo"));
area.setAreaFrom(rs.getString("AreaFrom"));
area.setValiDate(rs.getDate("EndDate"));
L_AreaInfoEH.add(area);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
} finally {
dbclose.CloseResultSet(rs);
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
return L_AreaInfoEH;
}
public boolean update(AreaInfoEH area) {
boolean flag = false;
DBPoolManager dbpool = new DBPoolManager();
Connection conn = null;
Statement stmt = null;
DBClose dbclose = new DBClose();
String sql = "update area_info set AreaNu='" + area.getAreaNu()
+ "',AreaName='" + area.getAreaName() + "',AreaAddr='"
+ area.getAreaAddr() + "',AreaSize=" + area.getAreaSize()
+ ",AreaStatus=" + area.getAreaStatus() + ",AreaIs="
+ area.getAreaIs() + ",ReMark=" + area.getReMark() + ",Memo='"
+ area.getMemo()
+ "',UsedBy='"+ area.getUsedBy()
+ "',UsedFor='"+ area.getUsedFor()
+ "',AreaKind='"+ area.getAreaKind()
+ "',OterAu='"+ area.getOterAu()
+ "',AreaIdNo='"+ area.getAreaIdNo()
+ "',AreaFrom='"+ area.getAreaFrom()
+ "',EndDate=to_date('" + area.getValiDate() + "','yyyy-mm-dd')"
+ " where areaNu = '" + area.getAreaNu()
+ "'";
//System.out.print(area.getValiDate());
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement();
int i = stmt.executeUpdate(sql);
flag = i > 0 ? true : false;
dbpool.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
dbpool.rollback();
} finally {
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
// TODO Auto-generated method stub
return flag;
}
public List pageCount(int page) {
// TODO Auto-generated method stub
String sql = "select * from area_info";
List list = new ArrayList();
DBPoolManager dbpool = new DBPoolManager();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
DBClose dbclose = new DBClose();
AreaInfoEH area = null;
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
rs.last();
totalRecord = rs.getRow();
int startRow = (page - 1) * record_per_page + 1;
rs.absolute(startRow);
int i = 0;
while (i < record_per_page && !rs.isAfterLast()) {
area = new AreaInfoEH();
area.setAreaNu(rs.getString("areaNu"));
area.setAreaName(rs.getString("areaName"));
area.setAreaAddr(rs.getString("areaAddr"));
area.setAreaStatus(rs.getInt("areaStatus"));
area.setAreaSize(rs.getFloat("areaSize"));
area.setAreaIs(rs.getInt("areaIs"));
area.setMemo(rs.getString("memo"));
area.setUsedBy(rs.getString("UsedBy"));
area.setUsedFor(rs.getString("UsedFor"));
area.setAreaKind(rs.getString("AreaKind"));
area.setOterAu(rs.getString("OterAu"));
area.setAreaIdNo(rs.getString("AreaIdNo"));
area.setAreaFrom(rs.getString("AreaFrom"));
area.setValiDate(rs.getDate("EndDate"));
list.add(area);
i++;
rs.next();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
} finally {
dbclose.CloseResultSet(rs);
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
return list;
}
public AreaInfoEH getSelectByAreaNu(String areaNu) {
// TODO Auto-generated method stub
String sql = "select * from area_info where areaNu='" + areaNu + "'";
DBPoolManager dbpool = new DBPoolManager();
Statement stmt = null;
ResultSet rs = null;
AreaInfoEH area = null;
DBClose dbclose = new DBClose();
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement();
rs = stmt.executeQuery(sql);
if (rs.next()) {
area = new AreaInfoEH();
area.setAreaNu(rs.getString("AreaNu"));
area.setAreaName(rs.getString("AreaName"));
area.setAreaAddr(rs.getString("AreaAddr"));
area.setAreaSize(rs.getFloat("AreaSize"));
area.setAreaStatus(rs.getInt("AreaStatus"));
area.setAreaIs(rs.getInt("AreaIs"));
area.setMemo(rs.getString("Memo"));
area.setUsedBy(rs.getString("UsedBy"));
area.setUsedFor(rs.getString("UsedFor"));
area.setAreaKind(rs.getString("AreaKind"));
area.setOterAu(rs.getString("OterAu"));
area.setAreaIdNo(rs.getString("AreaIdNo"));
area.setAreaFrom(rs.getString("AreaFrom"));
area.setValiDate(rs.getDate("EndDate"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
} finally {
dbclose.CloseResultSet(rs);
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
return area;
}
public List pageCount(int page, String AreaName, int AreaStatus) {
// TODO Auto-generated method stub
String sql = "select * from area_info where 1=1 ";
if (!AreaName.equals("-1")) {
sql += " and AreaNu='" + AreaName + "'";
}
if (AreaStatus != 0) {
sql += " and AreaStatus=" +AreaStatus;
}
sql+="order by AreaName";
List list = new ArrayList();
DBPoolManager dbpool = new DBPoolManager();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
DBClose dbclose = new DBClose();
AreaInfoEH area = null;
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
// rs.last();
// totalRecord = rs.getRow();
// int startRow = (page - 1) * record_per_page + 1;
// rs.absolute(startRow);
// while (i < record_per_page && !rs.isAfterLast()) {
while (rs.next()) {
area = new AreaInfoEH();
area.setAreaNu(rs.getString("AreaNu"));
area.setAreaName(rs.getString("AreaName"));
area.setAreaAddr(rs.getString("AreaAddr"));
area.setAreaSize(rs.getFloat("AreaSize"));
area.setAreaStatus(rs.getInt("AreaStatus"));
area.setAreaIs(rs.getInt("AreaIs"));
area.setReMark(rs.getInt("ReMark"));
area.setMemo(rs.getString("Memo"));
area.setUsedBy(rs.getString("UsedBy"));
area.setUsedFor(rs.getString("UsedFor"));
area.setAreaKind(rs.getString("AreaKind"));
area.setOterAu(rs.getString("OterAu"));
area.setAreaIdNo(rs.getString("AreaIdNo"));
area.setAreaFrom(rs.getString("AreaFrom"));
area.setValiDate(rs.getDate("EndDate"));
list.add(area);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
} finally {
dbclose.CloseResultSet(rs);
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
return list;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -