package dao;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import entry.HouseSource;
import util.DBConnector;
import util.Test;
import util.Transform;
public class HouseSourceDaoImplement implements HouseSourceDao {
DBConnector dbConnection = new DBConnector();
@Override
public boolean addInfo(String ESTATE_NAME, String ENTERPRISE_NAME, String PHONE, String BUILDING_NO,
Date RECEIVE_METERIAL_START_TIME, Date PURPOSE_REGISTER_START_TIME, Date PURPOSE_REGISTER_END_TIME,
int IDENTIFICATION_ID, String RECEIVE_METERIAL_ADDRESS, Date LOTTERY_TIME, Date SELECT_HOUSE_TIME,
String INFO_DESCRIPTION, Date RECEIVE_METERIAL_END_TIME, int HOUSE_AMOUNT) {
int row = 0;
Connection connection = null;
PreparedStatement statement = null;
try {
connection = dbConnection.connect();
// 预编译sql语句
String sql = "INSERT INTO `houselottery`.`tb_real_estate_info` "
+ "( ESTATE_NAME, ENTERPRISE_NAME, PHONE, BUILDING_NO,"
+ " RECEIVE_METERIAL_START_TIME, PURPOSE_REGISTER_START_TIME, " + "PURPOSE_REGISTER_END_TIME,"
+ " IDENTIFICATION_ID, RECEIVE_METERIAL_ADDRESS, LOTTERY_TIME, "
+ " SELECT_HOUSE_TIME, INFO_DESCRIPTION, RECEIVE_METERIAL_END_TIME, HOUSE_AMOUNT) "
+ "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
statement = connection.prepareStatement(sql);
statement.setString(1, ESTATE_NAME);
statement.setString(2, ENTERPRISE_NAME);
statement.setString(3, PHONE);
statement.setString(4, BUILDING_NO);
statement.setDate(5, RECEIVE_METERIAL_START_TIME);
statement.setDate(6, PURPOSE_REGISTER_START_TIME);
statement.setDate(7, PURPOSE_REGISTER_END_TIME);
statement.setInt(8, IDENTIFICATION_ID);
statement.setString(9, RECEIVE_METERIAL_ADDRESS);
statement.setDate(10, LOTTERY_TIME);
statement.setDate(11, SELECT_HOUSE_TIME);
statement.setString(12, INFO_DESCRIPTION);
statement.setDate(13, RECEIVE_METERIAL_END_TIME);
statement.setInt(14, HOUSE_AMOUNT);
row = statement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (connection != null) {
connection.close();
}
if (statement != null) {
statement.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
if (row > 0) {
return true;
} else
return false;
}
@Override
public boolean verifyInfo(int ESTATE_ID, String ESTATE_NAME, String ENTERPRISE_NAME, String PHONE,
String BUILDING_NO, Date RECEIVE_METERIAL_START_TIME, Date PURPOSE_REGISTER_START_TIME,
Date PURPOSE_REGISTER_END_TIME, int IDENTIFICATION_ID, String RECEIVE_METERIAL_ADDRESS, Date LOTTERY_TIME,
Date SELECT_HOUSE_TIME, String INFO_DESCRIPTION, Date RECEIVE_METERIAL_END_TIME, int HOUSE_AMOUNT) {
int row = 0;
Connection connection = null;
PreparedStatement statement = null;
try {
connection = dbConnection.connect();
// 预编译sql语句
String sql = "UPDATE `houselottery`.`tb_real_estate_info` SET" + " ESTATE_ID = ?," + " ESTATE_NAME = ?,"
+ " ENTERPRISE_NAME = ?," + " PHONE = ?," + " BUILDING_NO = ?,"
+ " RECEIVE_METERIAL_START_TIME = ?," + " PURPOSE_REGISTER_START_TIME = ?,"
+ " PURPOSE_REGISTER_END_TIME = ?," + " IDENTIFICATION_ID = ?," + "RECEIVE_METERIAL_ADDRESS = ?,"
+ " LOTTERY_TIME = ?," + " SELECT_HOUSE_TIME = ?," + " INFO_DESCRIPTION = ?, "
+ " RECEIVE_METERIAL_END_TIME = ?, HOUSE_AMOUNT = ? " + "WHERE ESTATE_ID = ?";
statement = connection.prepareStatement(sql);
statement.setInt(1, ESTATE_ID);
statement.setString(2, ENTERPRISE_NAME);
statement.setString(3, ENTERPRISE_NAME);
statement.setString(4, PHONE);
statement.setString(5, BUILDING_NO);
statement.setDate(6, RECEIVE_METERIAL_START_TIME);
statement.setDate(7, PURPOSE_REGISTER_START_TIME);
statement.setDate(8, PURPOSE_REGISTER_END_TIME);
statement.setInt(9, IDENTIFICATION_ID);
statement.setString(10, RECEIVE_METERIAL_ADDRESS);
statement.setDate(11, LOTTERY_TIME);
statement.setDate(12, SELECT_HOUSE_TIME);
statement.setString(13, INFO_DESCRIPTION);
statement.setDate(14, RECEIVE_METERIAL_END_TIME);
statement.setInt(15, HOUSE_AMOUNT);
statement.setInt(16, ESTATE_ID);
row = statement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (connection != null) {
connection.close();
}
if (statement != null) {
statement.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
if (row > 0) {
return true;
}
return false;
}
@Override
public boolean deleteInfo(String BUILDING_NO) {
int row = 0;
Connection connection = null;
PreparedStatement statement = null;
connection = dbConnection.connect();
try {
String sql = "DELETE FROM `houselottery`.`tb_real_estate_info` WHERE `BUILDING_NO` = '" + BUILDING_NO
+ "';";
statement = connection.prepareStatement(sql);
row = statement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
if (row > 0) {
return true;
} else
return false;
}
@Override
public List<HouseSource> selectInfoAll() {
List<HouseSource> houseSources = new ArrayList<>();
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
connection = dbConnection.connect();
String sql = "SELECT * FROM tb_real_estate_info";
try {
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
while (resultSet.next()) {
HouseSource houseSource = new HouseSource();
houseSource.setEATATE_ID(resultSet.getInt(1));
houseSource.setEATATE_NAME(resultSet.getString(2));
houseSource.setENTERPRISE_NAME(resultSet.getString(3));
houseSource.setPHONE(resultSet.getString(4));
houseSource.setBUILDING_NO(resultSet.getString(5));
houseSource.setRECEIVE_METERIAL_START_TIME(resultSet.getDate(6));
houseSource.setPURPOSE_REGISTER_START_TIME(resultSet.getDate(7));
houseSource.setPURPOSE_REGISTER_END_TIME(resultSet.getDate(8));
houseSource.setIDENTIFICATION_ID(resultSet.getInt(9));
houseSource.setRECEIVE_METERIAL_ADDRESS(resultSet.getString(10));
houseSource.setLOTIERY_TIME(resultSet.getDate(11));
houseSource.setSELECT_HOUSE_TIME(resultSet.getDate(12));
houseSource.setINFO_DESCRIPTION(resultSet.getString(13));
houseSource.setRECEIVE_METERIAL_END_TIME(resultSet.getDate(14));
houseSource.setHOUSE_AMOUNT(resultSet.getInt(15));
houseSources.add(houseSource);
}
} catch (SQLException e) {
e.printStackTrace();
}
return houseSources;
}
@Override
public boolean deleteInfo(int IDENTIFICATION_ID) {
int row = 0;
Connection connection = null;
PreparedStatement statement = null;
connection = dbConnection.connect();
try {
String sql = "DELETE FROM `houselottery`.`tb_real_estate_info` WHERE `IDENTIFICATION_ID` = '"
+ IDENTIFICATION_ID + "';";
statement = connection.prepareStatement(sql);
row = statement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
if (row > 0) {
return true;
} else
return false;
}
@Override
public HouseSource selectInfo(String BUDING_NO) {
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
connection = dbConnection.connect();
String sql = "SELECT * FROM tb_real_estate_info where BUDING_NO='" + BUDING_NO + "'";
HouseSource houseSource = new HouseSource();
try {
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
while (resultSet.next()) {
hous
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
动力节点Java毕设项目-《在线选房》 (209个子文件)
rndimg.aspx 3KB
rndimg.aspx 3KB
WebResource.axd 23KB
WebResource.axd 23KB
WebResource(1).axd 3KB
WebResource(1).axd 3KB
index1.css 33KB
main.css 25KB
main.css 24KB
main.css 24KB
main.css 23KB
main.css 23KB
layer.css 16KB
layer.css 16KB
layer.css 16KB
layer.css 16KB
layer.css 16KB
xiugaimima.css 9KB
footer.css 8KB
index.css 8KB
in.css 7KB
footer.css 7KB
footer.css 7KB
footer.css 7KB
footer.css 4KB
style.css 2KB
style.css 2KB
header.css 372B
header.css 372B
header.css 372B
header.css 372B
header.css 372B
摇号家庭公示.html 13KB
公示首页.html 10KB
摇号结果公示.html 10KB
选房结果公示.html 9KB
suc.html 275B
selectHouse.iml 1KB
main.iml 835B
mysql-connector-java-5.1.40-bin.jar 968KB
jstl-1.2.jar 405KB
standard-1.1.2.jar 384KB
HouseSourceDaoImplement.java 16KB
PurchaserDaoImplement.java 12KB
SellInfoManage.java 11KB
PurchaserServlet.java 8KB
StaffDaoImplement.java 6KB
LoginServlet.java 6KB
HouseSource.java 5KB
StaffServlet.java 5KB
HouseSourceServlet.java 5KB
HouseSourceDao.java 3KB
Purchaser.java 3KB
afterServlet.java 2KB
PurchaserDao.java 2KB
StaffDao.java 1KB
Staff.java 1KB
StaffDim.java 1KB
RegisterServlet.java 1KB
RandomPwd.java 1KB
MyUTF.java 943B
Test.java 769B
DBConnector.java 621B
Transform.java 558B
topimg07.jpg 69KB
topimg004.jpg 59KB
massage.jpg 56KB
topimg00.jpg 55KB
topimg00.jpg 55KB
topimg00.jpg 55KB
topimg001.jpg 55KB
topimg001.jpg 55KB
topimg001.jpg 55KB
topimg005.jpg 55KB
topimg003.jpg 54KB
topimg002.jpg 41KB
topimg002.jpg 41KB
topimg002.jpg 41KB
topimg07.jpg 34KB
topimg11.jpg 34KB
topimg1.jpg 34KB
topimg07.jpg 34KB
index_header.jpg 34KB
topimg07.jpg 34KB
index_header-bg.jpg 11KB
jquery-1.7.2.js 256KB
jquery-1.7.2.js 256KB
jquery.min.js 91KB
jquery.min.js 91KB
jquery.min.js 82KB
main.js 46KB
main.js 46KB
main.js 46KB
CA273860000409177190001.js 35KB
CA273860000409177190001.js 35KB
CA273860000409177190001.js 35KB
h.js 32KB
h.js 32KB
h.js 32KB
layer.js 22KB
共 209 条
- 1
- 2
- 3
资源评论
qwsrfss
- 粉丝: 1
- 资源: 32
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功