2016-06-15-课程设计日志

课设第三天，至今天所完成的模块有，后台管理主界面，仓库管理模块，收入支出模块。

今天早上主要去把我仓库管理模块里的表修改了一下，把对应数据库操作的代码也修改了一下，成功修改了之后，将其给负责后台主界面的小马让其进行合并。

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代码，注意一点就是如果属性是字符串的话，在写语句是要加上‘ ’，有些不注意这里的容易出现错误，功能执行不下去。

后来主要是给一名组员进行讲解他要做的模块，让其理解自己所编写的那些层次。真的体会到你会不会，通过给别人的讲解表述出来，可以真的看出你掌握理解了没有。

最后对明天早上要开始进行的员工模块进行构思，表和界面等。