java商品管理系统10

packagecom.DateSystem;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.LinkedList;importjava.util.List;importjavax.swing.JOptionPane;importcom.gui.*;publicclassGood_data{//根据商品名查询publicListGoodsfindGoods(Stringsql){ListGoodslist=newLinkedListGoods();Statementstat=null;ResultSetrs=null;//获取和数据库的连接Connectionconn=ConnectionDriver.getConnection();try{//生成Statement对象，封装SQL语句，执行查询stat=conn.createStatement();rs=stat.executeQuery(sql);//处理结果集中数据，读取每一条记录while(rs.next()){//intid=rs.getInt(1);Stringid=rs.getString(1);Stringname=rs.getString(2);Stringaddress=rs.getString(3);doublein_price=rs.getDouble(4);doubleout_price=rs.getDouble(5);intjinhuo=rs.getInt(6);intchuhuo=rs.getInt(7);intkucun=rs.getInt(8);Goodsd=newGoods();d.setName(name);d.setId(id);d.setAddress(address);d.setIn_price(in_price);d.setOut_price(out_price);d.setKucun(kucun);d.setJinhuo(jinhuo);d.setChuhuo(chuhuo);list.add(d);}}catch(SQLExceptione){e.printStackTrace();}finally{JDBcloss.close(rs,stat,conn);}returnlist;}//依靠商品号查询publicGoodsfindStudentById(Stringid){System.out.print(goods);//创建Data对象Goodsdata=newGoods();Statementstat=null;ResultSetrs=null;Connectionconn=ConnectionDriver.getConnection();Stringsql=select*fromresultwhereid='+id+';try{stat=conn.createStatement();//执行查询rs=stat.executeQuery(sql);//处理结果集if(rs.next()){//intid_id=rs.getInt(1);Stringid_id=rs.getString(1);Stringname=rs.getString(2);Stringaddress=rs.getString(3);doublein_price=rs.getDouble(4);doubleout_price=rs.getDouble(5);intjinhuo=rs.getInt(6);intchuhuo=rs.getInt(7);intkucun=rs.getInt(8);data.setId(id_id);data.setName(name);data.setAddress(address);data.setIn_price(in_price);data.setOut_price(out_price);data.setKucun(kucun);data.setJinhuo(jinhuo);data.setChuhuo(chuhuo);}}catch(SQLExceptione){e.printStackTrace();}returndata;}//对商品信息进行增加、修改、删除publicbooleanupdateStudent(Stringsql){booleanflag=false;Statementstat=null;Connectionconn=ConnectionDriver.getConnection();try{//生成Statement对象，向数据库发送sql指令stat=conn.createStatement();inti=stat.executeUpdate(sql);if(i0){flag=true;}}catch(SQLExceptione){e.printStackTrace();}finally{JDBcloss.close(stat,conn);}returnflag;}}