课设第三天,至今天所完成的模块有,后台管理主界面,仓库管理模块,收入支出模块。
今天早上主要去把我仓库管理模块里的表修改了一下,把对应数据库操作的代码也修改了一下,成功修改了之后,将其给负责后台主界面的小马让其进行合并。
public class StoreHouseDAO implements iStoreHouseDAO{
public int insert(StoreHouse stu) {
try {
String sql = "insert into goods(GoodsId,GoodsName,Price,Storage,Provider,BuyDate)"
+ " values('"+stu.getGoods_ID()+"','"
+ stu.getGoods_Name()
+ "', " + stu.getGoods_Price()
+ ", "+stu.getGoods_Storage()+",'"+stu.getGoods_Provider()+"','"+ stu.getGoods_BuyDate()
+ "' )";
System.out.println(sql);
DBUtil db = new DBUtil();
db.openConnection();
ResultSet rst = db.getInsertObjectIDs(sql);
db.close(rst);
db.close();
return 1;
} catch (Exception e) {
e.printStackTrace();
}
return 0;
}
public int update(StoreHouse stu) {
int rtn=0;
try {
String sql = "update goods set " +" GoodsName ='"
+ stu.getGoods_Name() + "', " + " Price = "
+ stu.getGoods_Price() + ","+" Storage =" +stu.getGoods_Storage()+","
+" Provider= '"+stu.getGoods_Provider() +"',"+ "BuyDate = '"
+ stu.getGoods_BuyDate()+"' ";
sql += " where GoodsId = " + stu.getGoods_ID();
System.out.println(sql);
DBUtil db = new DBUtil();
db.openConnection();
rtn =db.execCommand(sql);
db.close();
} catch (Exception e) {
e.printStackTrace();
}
return rtn;
}
public int delete(String ID) {
int rtn=0;
try{
String sql = "delete from goods ";
sql += " where GoodsId= " + ID;
DBUtil db = new DBUtil();
db.openConnection();
rtn=db.execCommand(sql);
db.close();
} catch (Exception e) {
e.printStackTrace();
}
return rtn;
}
public List<StoreHouse> select(String condt) {
List<StoreHouse> shList = null;
shList=new LinkedList<StoreHouse>();
try {
String sql = "select GoodsId, GoodsName, Price, Storage, Provider, BuyDate from goods ";
condt.trim();
if(!condt.isEmpty())
sql+= " where " + condt;
DBUtil db = new DBUtil();
if(!db.openConnection()){
System.out.print("fail to connect database");
return null;
}
ResultSet rst = db.execQuery(sql);
if (rst!=null) {
while(rst.next()){
StoreHouse stu=new StoreHouse();
stu.setGoods_ID(rst.getString("GoodsId"));
stu.setGoods_Name(rst.getString("GoodsName"));
stu.setGoods_Price(rst.getDouble("Price"));
stu.setGoods_Storage(rst.getInt("Storage"));
stu.setGoods_Provider(rst.getString("Provider"));
stu.setGoods_BuyDate(rst.getString("BuyDate"));
shList.add(stu);
}
}
db.close(rst);
db.close();
} catch (Exception e) {
e.printStackTrace();
}
finally{
}
return shList;
}
}
以上就是数据库操作的java代码,注意一点就是如果属性是字符串的话,在写语句是要加上‘ ’,有些不注意这里的容易出现错误,功能执行不下去。
后来主要是给一名组员进行讲解他要做的模块,让其理解自己所编写的那些层次。真的体会到你会不会,通过给别人的讲解表述出来,可以真的看出你掌握理解了没有。
最后对明天早上要开始进行的员工模块进行构思,表和界面等。