//查询
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt){
String t_goodsName=this.s_goodsNameTxt.getText();
Goods goods=new Goods();
goods.setGoodsName(t_goodsName);
this.fillTable(goods);
}
//下拉框
private void fillGoodsType(String type){
Connection con=null;
GoodsType goodsType=null;
try{
con=dbUtil.getCon();
ResultSet rs=goodsTypeDao.list(con,new GoodsType());
if("search".equals(type)){
goodsType=new GoodsType();
goodsType.setGoodsTypeName("请选择");
goodsType.setId(-1);
this.s_goodsJcb.addItem(goodsType);
}
while(rs.next()){
goodsType=new GoodsType();
goodsType.setGoodsTypeName(rs.getString("goodsTypeName"));
goodsType.setId(rs.getInt("id"));
if("search".equals(type)){
this.s_goodsJcb.addItem(goodsType);
}else if("modify".equals(type)){
}
}
}catch (Exception e){
e.printStackTrace();
}finally {
try{
dbUtil.closeCon(con);
}catch (Exception e){
e.printStackTrace();
}
}
}
//表
private void fillTable(Goods goods){
DefaultTableModel dtm=(DefaultTableModel) jTable1.getModel();
dtm.setRowCount(0);
Connection con=null;
try{
con=dbUtil.getCon();
ResultSet rs=goodsDao.list(con,goods);
while(rs.next()){
Vector v=new Vector();
v.add(rs.getInt("id"));
v.add(rs.getString("goodsName"));
v.add(rs.getFloat("price"));
v.add(rs.getString("goodsDesc"));
dtm.addRow(v);
}
}catch (Exception e){
e.printStackTrace();
}finally {
try{
dbUtil.closeCon(con);
}catch (Exception e){
e.printStackTrace();
}
}
}
//鼠标点击表格事件
private void jTable1MousePressed(java.awt.event.MouseEvent evt){
int row=jTable1.getSelectedRow();
this.idTxt.setText((Integer)jTable1.getValueAt(row,0)+"");
this.goodsNameTxt.setText((String)jTable1.getValueAt(row,1));
this.priceTxt.setText((Float)jTable1.getValueAt(row,2)+"");
this.goodsDescTxt.setText((String)jTable1.getValueAt(row,3));
}
//鼠标单击后,修改
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt){
String id=this.idTxt.getText();
if(StringUtil.isEmpty(id)){
JOptionPane.showMessageDialog(null,"请选择要修改的记录");
return;
}
String goodsName=this.goodsNameTxt.getText();
String price=this.priceTxt.getText();
String goodsDesc=this.goodsDescTxt.getText();
if(StringUtil.isEmpty(goodsName)){
JOptionPane.showMessageDialog(null,"商品名称不能为空");
return;
}
if(StringUtil.isEmpty(price)){
JOptionPane.showMessageDialog(null,"商品价钱不能为空");
return;
}
if(StringUtil.isEmpty(goodsDesc)){
JOptionPane.showMessageDialog(null,"商品描述不能为空");
return;
}
Goods goods=new Goods(Integer.parseInt(id),goodsName, Float.parseFloat(price),goodsDesc);
Connection con=null;
try{
con=dbUtil.getCon();
int modifyNum=goodsDao.update(con,goods);
if(modifyNum==1){
JOptionPane.showMessageDialog(null,"修改成功");
this.resetValue();
this.fillTable(new Goods());
}else{
JOptionPane.showMessageDialog(null,"修改失败");
}
}catch (Exception e){
e.printStackTrace();
}finally {
try{
dbUtil.closeCon(con);
}catch (Exception e){
e.printStackTrace();
}
}
}
//鼠标单击后删除
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt){
String id=idTxt.getText();
if(StringUtil.isEmpty(id)){
JOptionPane.showMessageDialog(null,"请选择要删除的记录");
return;
}
int n=JOptionPane.showConfirmDialog(null,"Are you 确定delete this记录?");
if(n==0){
Connection con=null;
try{
con=dbUtil.getCon();
int deleteNum=goodsDao.delete(con,id);
if(deleteNum==1){
JOptionPane.showMessageDialog(null,"删除成功");
this.resetValue();
this.fillTable(new Goods());
}else{
JOptionPane.showMessageDialog(null,"删除失败");
}
}catch (Exception e){
e.printStackTrace();
}finally {
try{
dbUtil.closeCon(con);
}catch (Exception e){
e.printStackTrace();
}
}
}
}
//修改后重置
private void resetValue(){
this.idTxt.setText("");
this.goodsNameTxt.setText("");
this.goodsDescTxt.setText("");
}
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
private void jButton2ActionPerformed(ActionEvent evt){
this.resetValue();
}
//商品添加
private void jButton1ActionPerformed(ActionEvent evt){
String goodsName=this.goodsNameTxt.getText();
String price=this.priceTxt.getText();
String goodsDesc=this.goodsDecTxt.getText();
if(StringUtil.isEmpty(goodsName)){
JOptionPane.showMessageDialog(null,"商品类别名称不能为空");
return;
}
if(StringUtil.isEmpty(price)){
JOptionPane.showMessageDialog(null,"商品价格不能为空");
return;
}
GoodsType goodsType=(GoodsType)goodsTypeJcb.getSelectedItem();
int goodsTypeId=goodsType.getId();
Goods goods=new Goods(goodsName,Float.parseFloat(price),goodsDesc);
Connection con=null;
try{
con=dbUtil.getCon();
int addNum=goodsDao.add(con,goods);
if(addNum==1){
JOptionPane.showMessageDialog(null,"商品添加成功");
resetValue();
}else{
JOptionPane.showMessageDialog(null,"商品添加失败");
}
}catch (Exception e){
e.printStackTrace();
JOptionPane.showMessageDialog(null,"商品添加失败");
}finally {
try{
dbUtil.closeCon(con);
}catch (Exception e){
e.printStackTrace();
}
}
}
/**
* 重置表单
*/
private void resetValue(){
this.goodsNameTxt.setText("");
this.priceTxt.setText("");
this.goodsDecTxt.setText("");
if(this.goodsTypeJcb.getItemCount()>0){
this.goodsTypeJcb.setSelectedIndex(0);
}
}
//初始化商品类别下拉框
private void fillGoodsType(){
Connection con=null;
GoodsType goodsType=null;
try{
con=dbUtil.getCon();
ResultSet rs=goodsTypeDao.list(con,new GoodsType());
while(rs.next()){
goodsType=new GoodsType();
goodsType.setId(rs.getInt("id"));
goodsType.setGoodsTypeName(rs.getString("goodsTypeName"));
this.goodsTypeJcb.addItem(goodsType);
}
}catch (Exception e){
e.printStackTrace();
}finally {
}
}
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273