Java swing 的一个多表操作的例子
惯例，开头先给师傅打个广告。java1234.com
多的不说，直接上代码和效果图。数据连接层代码
public int GoodsXinXi_Add(Connection conn ,GoodsJiChuXinXi yuangong){ int i=0; String sql="insert goods_jichuxinxi value(null,?,?,?,?,?)"; try{ PreparedStatement pstm=conn.prepareStatement(sql); pstm.setString(2, yuangong.getGoods_Name()); pstm.setInt(1, yuangong.getGoods_LeiBieID()); pstm.setString(3,String.valueOf(yuangong.getGoods_Color()) ); pstm.setString(4, yuangong.getGoods_GuiGe()); pstm.setString(5, String.valueOf(yuangong.getGoods_Date())); i=pstm.executeUpdate(); } catch(Exception e){ e.printStackTrace(); } return i; } public ResultSet GoodsXinXi_XinXiList(Connection conn, String str,String yuangong ) throws Exception{ String sql="select*from goods_jichuxinxi jichuxinxi,tb_goodsleibie goodsleibie where jichuxinxi.Goods_LeiBieID=goodsleibie.Goods_LeiBieID"; StringBuffer sb=new StringBuffer(sql); PreparedStatement pstm = null; try { if(!"".equals(str)&&!"".equals(yuangong)){ sb.append(" and "); sb.append(" "); sb.append( str); sb.append(" like '%"); sb.append(yuangong); sb.append("%'"); pstm=conn.prepareStatement(sb.toString()); // System.out.println(sb.toString()); } else{ pstm=conn.prepareStatement(sb.toString()); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return pstm.executeQuery(); } public ResultSet GoodsXinXi_XinXiList(Connection conn) throws Exception{ String sql="select*from tb_goodsleibie "; PreparedStatement pstm=null; pstm=conn.prepareStatement(sql); return pstm.executeQuery(); } public int UpdateTable(Connection conn,int row,GoodsJiChuXinXi xinxi) throws Exception{ int updateRow=0; String sql="update goods_jichuxinxi set Goods_LeiBieID=?,Goods_Name=?,Goods_Color=?,Goods_GuiGe=?,Goods_Date=? where Goods_JiChuID=?"; PreparedStatement pstm=null; pstm=conn.prepareStatement(sql); pstm.setInt(1, xinxi.getGoods_LeiBieID()); pstm.setString(2, xinxi.getGoods_Name()); pstm.setString(3, xinxi.getGoods_Color()); pstm.setString(4, xinxi.getGoods_GuiGe()); pstm.setString(5, String.valueOf(xinxi.getGoods_Date())); pstm.setInt(6, row); updateRow=pstm.executeUpdate(); return updateRow; } public int delectData(Connection conn, int rowIndex) throws Exception{ int updateRow=0; String sql="delete from tb_Client where ClientID=? "; PreparedStatement pstm=null; pstm=conn.prepareStatement(sql); pstm.setInt(1, rowIndex); updateRow=pstm.executeUpdate(); return updateRow; }
界面层代码
DBUtil dbutil = new DBUtil(); StringUtil stringutil = new StringUtil(); GoodsXinXiDao xinxidao = new GoodsXinXiDao(); /** Creates new form Goods_JiChuXinXiWeiHuFrm */ public Goods_JiChuXinXiWeiHuFrm() { initComponents(); this.setLocation(300, 50); String[] combox = { "", "编号", "类别名", "商品名" }; for (int i = 0; i < combox.length; i++) { this.JcomboxTiaoJian.addItem(combox[i]); } String tiaojian = this.JcomboxTiaoJian.getSelectedItem().toString(); String values = this.TiaoJianValueTxt.getText(); this.FillDataTable(tiaojian, values); this.selectType(); } public void selectType() { Connection conn = null; GoodsLeiBie leibieType = null; try { conn = dbutil.getcon(); GoodsXinXiDao goodsdao = new GoodsXinXiDao(); ResultSet rs = goodsdao.GoodsXinXi_XinXiList(conn); while (rs.next()) { leibieType = new GoodsLeiBie(); leibieType.setGoodsLeiBieID(rs.getInt("Goods_LeiBieID")); leibieType.setGoodName(rs.getString("Goods_LeiBieMing")); this.ComBoxTxt.addItem(leibieType); } //this.ShangPinLeiBieTxt.addItem(leibieType); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void FillDataTable(String tiaojian, String values) { Connection conn = null; Client data = null; DefaultTableModel dtm = (DefaultTableModel) data_Table.getModel(); dtm.setRowCount(0); try { conn = dbutil.getcon(); ResultSet rs = xinxidao .GoodsXinXi_XinXiList(conn, tiaojian, values); while (rs.next()) { Vector v = new Vector(); v.add(rs.getString("Goods_JiChuID")); v.add(rs.getString("Goods_Name")); v.add(rs.getString("Goods_LeiBieMing")); v.add(rs.getString("Goods_GuiGe")); v.add(rs.getString("Goods_Color")); v.add(rs.getString("Goods_Date")); dtm.addRow(v); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { dbutil.closeCon(conn); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } private void Jb_resetActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: Reset(); } private void Jb_deleteActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: int selectedRow = 0; String selected = ""; selected = this.BianHaoTxt.getText(); ; if ("".equals(selected)) { JOptionPane.showMessageDialog(null, "请先选中要删除的行！"); } else { Connection conn = null; selectedRow = Integer.parseInt(selected); try { conn = dbutil.getcon(); int count = xinxidao.delectData(conn, selectedRow); if (count != 0) { JOptionPane.showMessageDialog(null, "删除成功！"); String tiaojian = JcomboxTiaoJian.getSelectedItem() .toString(); String values = this.TiaoJianValueTxt.getText(); this.FillDataTable(tiaojian, values); Reset(); } else { JOptionPane.showMessageDialog(null, "删除失败！"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { dbutil.closeCon(conn); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } public void Reset() { this.BianHaoTxt.setText(""); this.NameTxt.setText(""); this.ComBoxTxt.setSelectedIndex(-1); this.GuiGeTxt.setText(""); this.TimeTxt.setText(""); } private void Jb_XiuGaiActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: String Id = this.BianHaoTxt.getText(); if ("".equals(Id)) { JOptionPane.showMessageDialog(null, "请选中要修改的行！"); } else { String userName = this.NameTxt.getText(); String ColorTxt = (String) this.ColorTxt.getText(); String GuiGeTxt = this.GuiGeTxt.getText(); String TimeTxt = this.TimeTxt.getText(); GoodsLeiBie bookType = (GoodsLeiBie) this.ComBoxTxt .getSelectedItem(); int bookTypeId = bookType.getGoodsLeiBieID(); SimpleDateFormat time1 = new SimpleDateFormat("yyyy-MM-dd"); GoodsJiChuXinXi xinxi = null; Timestamp ts; try { ts = new Timestamp(time1.parse(TimeTxt).getTime()); xinxi = new GoodsJiChuXinXi(userName, bookTypeId, GuiGeTxt, ColorTxt, ts); } catch (ParseException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } Connection conn = null; try { conn = dbutil.getcon(); int count = 0; count = xinxidao.UpdateTable(conn, Integer.parseInt(Id), xinxi); if (count != 0) { JOptionPane.showMessageDialog(null, "修改成功！"); Reset(); String tiaojian = JcomboxTiaoJian.getSelectedItem() .toString(); String values = this.TiaoJianValueTxt.getText(); this.FillDataTable(tiaojian, values); //this.reset(); } else { JOptionPane.showMessageDialog(null, "修改失败！"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { dbutil.closeCon(conn); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } private void data_TableMouseClicked(java.awt.event.MouseEvent evt) { // TODO add your handling code here: //this.reset(); int row = this.data_Table.getSelectedRow(); this.BianHaoTxt.setText((String) this.data_Table.getValueAt(row, 0)); this.NameTxt.setText((String) this.data_Table.getValueAt(row, 1)); //this.setText((String) this.data_Table.getValueAt(row, 2)); this.ColorTxt.setText((String) this.data_Table.getValueAt(row, 3)); this.GuiGeTxt.setText((String) this.data_Table.getValueAt(row, 4)); //SimpleDateFormat time1 = new SimpleDateFormat("yyyy-MM-dd"); String time = (String) this.data_Table.getValueAt(row, 5); this.TimeTxt.setText(time); String bookTypeName = (String) data_Table.getValueAt(row, 2); int n = this.ComBoxTxt.getItemCount(); for (int i = 0; i < n; i++) { GoodsLeiBie item = (GoodsLeiBie) this.ComBoxTxt.getItemAt(i); if (item.getGoodName().equals(bookTypeName)) { this.ComBoxTxt.setSelectedIndex(i); } } } private void Jb_SearchActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: String tiaojian = JcomboxTiaoJian.getSelectedItem().toString(); String values = this.TiaoJianValueTxt.getText(); int i = 0; String subtiaojian = null; if ("编号".equals(tiaojian)) { i = 1; } else if ("类别名".equals(tiaojian)) { i = 2; } else if ("商品名".equals(tiaojian)) { i = 3; } switch (i) { case 1: subtiaojian = "Goods_JiChuID"; break; case 2: subtiaojian = "Goods_LeiBieMing"; break; case 3: subtiaojian = "Goods_Name"; } try { this.FillDataTable(subtiaojian, values); this.JcomboxTiaoJian.setSelectedItem(""); this.TiaoJianValueTxt.setText(""); } catch (Exception e) { e.printStackTrace(); } finally { } }
效果图
