// 增加进货单
public void add(purchaseList list) {
try {
Connection con = initDB();
Statement stmt = con.createStatement();
String query =
"insert into purchaseList(purch_id,purch_date,purch_totalPrice,unitId,acc_id) values ('"
+ list.getPurch_id()
+ "','"
+ list.getPurch_date()
+ "','"
+ list.getPurch_totalPrice()
+ "','"
+ list.getUnit_id()
+ "','"
+ list.getAcc_id()
+ "')";
stmt.execute(query);
// 关闭命令对象连接
stmt.close();
// 关闭数据库连接
con.close();
} catch (SQLException e) {
System.out.println("添加数据失败！");
e.printStackTrace();
}
}
public void update(purchaseList list) {
try {
Connection con = initDB();
// 创建SQL命令对象
Statement stmt = con.createStatement();
// 创建SQL命令字符串
String query =
"update purchaseList set purch_date='"
+ list.getPurch_date()
+ "',purch_totalPrice='"
+ list.getPurch_totalPrice()
+ "',unitId='"
+ list.getUnit_id()
+ "',acc_id='"
+ list.getAcc_id()
+ "' where purch_id ='"
+ list.getPurch_id()
+ "'";
// 执行SQL语句
stmt.execute(query);
// 关闭命令对象连接
stmt.close();
// 关闭数据库连接
con.close();
} catch (Exception e) {
System.out.println("更新数据失败！");
e.printStackTrace();
}
}
/* SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
Date date1 = new Date(2014-1900,6-1,25);
String day1=sdf.format(date1);
就是这样获取*/
public ArrayList<purchaseList> findByPurch_dates(String day1, String day2) {
purchaseList list;
ArrayList<purchaseList> showList = new ArrayList<purchaseList>();
try {
Connection con = initDB();
// 创建SQL命令对象
Statement stmt = con.createStatement();
// 创建SQL命令字符串
String query =
"select * from purchaseList where purch_date between'" + day1 + "'and'" + day2 + "'";
// 执行SQL语句
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
list = new purchaseList();
list.setPurch_id(rs.getString("purch_id"));
list.setPurch_date(rs.getString("purch_date"));
list.setPurch_totalPrice(rs.getFloat("purch_totalPrice"));
list.setUnit_id(rs.getString("unitId"));
list.setAcc_id(rs.getString("acc_id"));
showList.add(list);
list = null;
}
// 关闭记录集
rs.close();
// 关闭命令对象连接
stmt.close();
// 关闭数据库连接
con.close();
} catch (SQLException e) {
System.out.println("查找数据失败！");
e.printStackTrace();
}
return showList;
}
public purchaseList findByPurch_id(String purch_id) {
purch_id.trim();
purchaseList purh = new purchaseList();
try {
Connection con = initDB();
// 创建SQL命令对象
Statement stmt = con.createStatement();
// 创建SQL命令字符串
String query = "select * from purchaseList where purch_id ='" + purch_id + "'";
// 执行SQL语句
ResultSet rs = stmt.executeQuery(query);
rs.next();
purh.setPurch_id(rs.getString("purch_id"));
purh.setPurch_date(rs.getString("purch_date"));
purh.setPurch_totalPrice(rs.getFloat("purch_totalPrice"));
purh.setUnit_id(rs.getString("unitId"));
purh.setAcc_id(rs.getString("acc_id"));
// 关闭记录集
rs.close();
// 关闭命令对象连接
stmt.close();
// 关闭数据库连接
con.close();
} catch (SQLException e) {
System.out.println("查找数据失败！");
e.printStackTrace();
}
return purh;
}