/*
* cgd.java
*
* Created on __DATE__, __TIME__
*/
package com.ui;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.event.KeyEvent;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.SwingConstants;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.table.TableColumn;
import com.util.DBO;
import com.util.StaticMethod;
/**
*
* @author __USER__
*/
public class cgd extends javax.swing.JInternalFrame {
/** Creates new form cgd */
public cgd() {
initComponents();
cgdid.setVisible(false);
this.Action();
}
public void Action() {
/**查询所有采购单信息的方法**/
String[] headtitle = { "采购单编号", "单号", "供应商", "标题", "说明", "商品", "数量",
"采购时间" };//采购单表格的标题
Object[][] tabledata = null;
String sql = "select * from cgd order by cgdid";//要查询的采购单的sql语句
DBO db = new DBO();
ResultSet rs = null;
try {
int i = 0;
rs = db.query(sql);//执行查询方法
while (rs.next()) {
i++;
}
tabledata = new Object[i][15];
rs = db.query(sql);
int m = 0;
rs = db.query(sql);
//把查询结构放到二维数组
while (rs.next()) {
tabledata[m][0] = rs.getString("cgdid");//采购单编号信息
tabledata[m][1] = rs.getString("dh");//单号信息
tabledata[m][2] = rs.getString("gys");//供应商信息
tabledata[m][3] = rs.getString("bt");//标题信息
tabledata[m][4] = rs.getString("sm");//说明信息
tabledata[m][5] = rs.getString("sp");//商品信息
tabledata[m][6] = rs.getString("sl");//数量信息
tabledata[m][7] = rs.getString("cgsj");//采购时间信息
m++;
}
jTable1.setModel(new javax.swing.table.DefaultTableModel(tabledata,
headtitle));
this.jTable1.getTableHeader().setPreferredSize(
new Dimension(this.jTable1.getTableHeader()
.getPreferredSize().width, 20));
jTable1.setSelectionBackground(Color.GREEN);
//表格居中
DefaultTableCellRenderer tcr = new DefaultTableCellRenderer();// 设置table内容居中
// tcr.setHorizontalAlignment(JLabel.CENTER);
tcr.setHorizontalAlignment(SwingConstants.CENTER);// 这句和上句作用一样
jTable1.setDefaultRenderer(Object.class, tcr);
jButton4.setVisible(false);
jButton5.setVisible(false);
hideColumn(jTable1, 0);
} catch (Exception e) {
e.printStackTrace();
} finally {
if (db != null) {
db.close();
}
}
resetForm();
}
public static void hideColumn(JTable table, int column) {
TableColumn tc = table.getColumnModel().getColumn(column);
tc.setMaxWidth(0);
tc.setPreferredWidth(0);
tc.setWidth(0);
tc.setMinWidth(0);
table.getTableHeader().getColumnModel().getColumn(column)
.setMaxWidth(0);
table.getTableHeader().getColumnModel().getColumn(column)
.setMinWidth(0);
}
public void resetForm() {
//把控件信息清空
this.cgdid.setText("");//采购单编号信息赋值成空
java.util.Date now = new java.util.Date();
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat(
"mmssssss");
// System.out.print(formatter.format(now));
String ddid = "" + formatter.format(now);
this.dh.setText(ddid);//单号信息赋值成空
//this.gys.setText("");//供应商信息赋值成空
this.bt.setText("");//标题信息赋值成空
this.sm.setText("");//说明信息赋值成空
DBO db = new DBO();
String sql = "";
ResultSet rs = null;
this.sp.removeAllItems();
this.gys.removeAllItems();
try {
sql = "select * from shangpin ";
rs = db.query(sql);
while (rs.next()) {
this.sp.addItem(rs.getString("spmc"));
}
sql = "select * from gys";
rs = db.query(sql);
while (rs.next()) {
this.gys.addItem(rs.getString("gysmc"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
db.close();
}
this.sl.setText("");//数量信息赋值成空
this.cgsj.setText(StaticMethod.getStringDate());//采购时间信息赋值成空
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
//GEN-BEGIN:initComponents
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
cgdid = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
dh = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
gys = new javax.swing.JComboBox();
jLabel3 = new javax.swing.JLabel();
bt = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
sp = new javax.swing.JComboBox();
jLabel5 = new javax.swing.JLabel();
sl = new javax.swing.JTextField();
jLabel6 = new javax.swing.JLabel();
cgsj = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
jScrollPane2 = new javax.swing.JScrollPane();
sm = new javax.swing.JTextArea();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jButton5 = new javax.swing.JButton();
setBackground(java.awt.SystemColor.activeCaption);
setClosable(true);
setTitle("\u91c7\u8d2d\u5355\u7ba1\u7406");
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object[][] { { null, null, null, null },
{ null, null, null, null }, { null, null, null, null },
{ null, null, null, null } }, new String[] { "Title 1",
"Title 2", "Title 3", "Title 4" }));
jScrollPane1.setViewportView(jTable1);
jLabel1.setText("\u5355\u53f7");
dh.setEnabled(false);
jLabel2.setText("\u4f9b\u5e94\u5546");
gys.setModel(new javax.swing.DefaultComboBoxModel(new String[] {
"Item 1", "Item 2", "Item 3", "Item 4" }));
jLabel3.setText("\u6807\u9898");
jLabel4.setText("\u5546\u54c1");
sp.setModel(new javax.swing.DefaultComboBoxModel(new String[] {
"Item 1", "Item 2", "Item 3", "Item 4" }));
jLabel5.setText("\u6570\u91cf");
sl.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyTyped(java.awt.event.KeyEvent evt) {
slKeyTyped(evt);
}
});
jLabel6.setText("\u91c7\u8d2d\u65f6\u95f4");
cgsj.setEditable(false);
jLabel7.setText("\u8bf4\u660e");
sm.setColumns(20);
sm.setRows(5);
jScrollPane2.setViewportView(sm);
jButton1.setText("\u6dfb\u52a0");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setText("\u8be6\u60c5");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setText("\u5173\u95ed");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton4.setText("\u4fee\u6539");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jButton5.setText("\u5220\u9664");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(
getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(layout
.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(
layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1,
1940java swing零售库存管理系统myeclipse开发Mysql数据库CS结构java编程源码 （202个子文件） 
cgd.class 16KB main.class 16KB chuhuo.class 15KB shangpin.class 15KB jinhuo.class 15KB tuihuo.class 15KB kcpd.class 14KB yuangong.class 13KB gly.class 13KB kehu.class 13KB gys.class 13KB kcyj.class 11KB login.class 9KB chth.class 8KB kucun.class 8KB yuangongmodify.class 7KB glymodify.class 7KB chthtj.class 4KB chtj.class 4KB thtj.class 4KB cgdtj.class 4KB jhtj.class 4KB DBO.class 4KB StaticMethod.class 3KB yuangongmodify$1.class 767B yuangongmodify$2.class 767B shangpin$1.class 764B shangpin$2.class 764B jinhuo$1.class 752B glymodify$2.class 732B glymodify$1.class 732B yuangong$4.class 725B shangpin$6.class 725B shangpin$8.class 725B shangpin$5.class 725B yuangong$5.class 725B yuangong$1.class 725B yuangong$3.class 725B shangpin$4.class 725B yuangong$2.class 725B shangpin$7.class 725B tuihuo$6.class 711B chuhuo$3.class 711B jinhuo$2.class 711B tuihuo$1.class 711B chuhuo$4.class 711B jinhuo$5.class 711B jinhuo$4.class 711B jinhuo$3.class 711B chuhuo$5.class 711B tuihuo$5.class 711B tuihuo$3.class 711B chuhuo$2.class 711B tuihuo$4.class 711B login$2.class 704B kucun$1.class 704B login$1.class 704B kucun$2.class 704B main$21.class 700B main$27.class 700B main$20.class 700B main$24.class 700B main$25.class 700B main$26.class 700B main$15.class 700B main$23.class 700B main$22.class 700B main$19.class 700B main$16.class 700B main$18.class 700B main$17.class 700B main$14.class 699B main$11.class 699B main$12.class 699B main$10.class 699B main$13.class 699B kcyj$4.class 697B main$6.class 697B kcpd$4.class 697B kehu$1.class 697B kcpd$3.class 697B kcpd$2.class 697B main$7.class 697B main$4.class 697B kehu$2.class 697B main$2.class 697B chth$1.class 697B main$1.class 697B main$3.class 697B kcpd$5.class 697B main$5.class 697B main$8.class 697B main$9.class 697B kehu$3.class 697B kehu$4.class 697B chth$2.class 697B kcyj$3.class 697B kcpd$6.class 697B kehu$5.class 697B gys$4.class 690B共 202 条
- 1
- 2
- 3
资源评论
