?? mainfrm.java~677~
字號:
}
if (JOptionPane.showConfirmDialog(null, "是否清空表中數據", "提示",
JOptionPane.YES_NO_OPTION) == 0) {
// shopping = ""; //清空所存商品數據
vr.removeAllElements();
tbltotal.updateUI();
}
}
public void btndate_actionPerformed(ActionEvent e) { //每日統計
vr.removeAllElements();
tbltotal.updateUI(); //清空表
String name = txtspname.getText().trim();
String sql;
String day = "";
Calendar cr;
cr = Calendar.getInstance();
int year = cr.get(Calendar.YEAR);
int month = cr.get(Calendar.MONTH) + 1;
int date = cr.get(Calendar.DATE);
day = year + "-" + month + "-" + date + ""; //獲取當前日期
if (name.equals("") && cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where times like '%" + day + "%'";
}
else if (!name.equals("") &&
cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where times like '%" + day +
"%' and name like'%" + name + "%'";
}
else if (name.equals("") &&
!cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where times like '%" + day +
"%' and kindsname='" +
cmbname.getSelectedItem() + "'";
}
else {
sql = "select * from sellnote where times like '%" + day +
"%' and kindsname='" +
cmbname.getSelectedItem() + "' and name like'%" + name + "%'";
}
// sql = "select * from sellnote where times like '%" + day +"%'";
// System.out.print(sql);
Link lk = new Link();
lk.connection();
ResultSet rs = lk.Select(sql);
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //商品編號
v.add(rs.getString(2).trim()); //類別
v.add(rs.getString(3).trim()); //商品名
v.add(rs.getString(4).trim()); //總數
v.add(rs.getString(5).trim()); //總額
v.add(rs.getString(6).trim()); //售出時間
vr.add(v); //添加數據
}
while (rs.next());
tbljinhuo.updateUI(); //更新表
}
else {
JOptionPane.showMessageDialog(null, "不存在紀錄", "提示",
JOptionPane.INFORMATION_MESSAGE);
}
rs.close();
lk.close();
}
catch (SQLException ex) {
}
//lk.close();
}
public void treeChanged() {
ve.removeAllElements();
//System.out.println("夠了");
tbljinhuo.updateUI();
String sql = ""; //存SQL語句
try {
DefaultMutableTreeNode node = (DefaultMutableTreeNode) treeIn.
getLastSelectedPathComponent(); //用于確定當前選定節點
String nodeInfo = node.getUserObject().toString().trim(); //用于存選定的接點名稱
if (node.isLeaf()) { //判斷是否選中商品
sql = "select * from shopping where name='" + nodeInfo + "'";
}
else { //判斷選定的類
sql = "select * from shopping where kindname='" + nodeInfo +
"'";
}
if (nodeInfo.equals("進貨管理")) { //未選中商品則進行模糊查詢
sql = "select * from shopping order by kindname";
}
}
catch (Exception ex) {
}
Link lk = new Link();
lk.connection();
//System.out.print(sql);
ResultSet rs = lk.Select(sql);
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //商品編號
v.add(rs.getString(2).trim()); //類別
v.add(rs.getString(3).trim()); //商品名
// v.add(rs.getString(4).trim()); //總數
v.add(rs.getString(5).trim()); //庫存量
v.add(rs.getString(6).trim()); //單位
v.add(rs.getString(8).trim()); //備注
ve.add(v); //添加數據
}
while (rs.next());
tbljinhuo.updateUI();
}
}
catch (SQLException ex1) {
}
lk.close();
}
public void treeIn_valueChanged(TreeSelectionEvent e) {
DefaultMutableTreeNode node = (DefaultMutableTreeNode) treeIn.
getLastSelectedPathComponent();
if (node == null) { //判斷是否選種節點
return;
}
else {
treeChanged(); //調用樹方法
}
}
public void btnquan_actionPerformed(ActionEvent e) { //進貨顯示所有
ve.removeAllElements(); //清空數組原有數據
tbljinhuo.updateUI(); //更新表
String sql = "select * from shopping order by kindname"; //存SQL語句
Link lk = new Link();
lk.connection();
System.out.print(sql);
ResultSet rs = lk.Select(sql);
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //商品編號
v.add(rs.getString(2).trim()); //類別
v.add(rs.getString(3).trim()); //商品名
// v.add(rs.getString(4).trim()); //總數
v.add(rs.getString(5).trim()); //庫存量
v.add(rs.getString(6).trim()); //單位
v.add(rs.getString(8).trim()); //備注
ve.add(v); //添加數據
}
while (rs.next());
tbljinhuo.updateUI();
}
}
catch (SQLException ex1) {
}
lk.close();
}
public void btnjinhuo_actionPerformed(ActionEvent e) { //未完成
int count = tbljinhuo.getSelectedRow();
String id = "";
String num = "";
int sum; //存輸入的庫存
if (count >= 0) { //判斷是否被選中
Calendar date = Calendar.getInstance(); //獲取一個日歷
t = new Date();
String te = t.toString().substring(11, (t.toString().length() - 4));
te = te.substring(0, 8);
date.get(Calendar.MINUTE);
date.get(Calendar.SECOND);
String time = date.get(Calendar.YEAR) + "-" +
(date.get(Calendar.MONTH) + 1)
+ "-" + date.get(Calendar.DATE) + " " + te;
Vector temp = (Vector) ve.get(count);
id = temp.get(0).toString().trim();
String sql = "select total from shopping where id='" + id + "'";
num = JOptionPane.showInputDialog(null, "請輸入需要進貨的數量");
if (num.toString().equals("")) { //判斷輸入是否為空
return;
}
try {
sum = Integer.parseInt(num);
}
catch (Exception ex) {
JOptionPane.showMessageDialog(null, "請輸入整數");
return;
}
Link lk = new Link();
lk.connection();
ResultSet rs = lk.Select(sql); //用于將現有的庫存量查詢出來
try {
if (rs.next()) {
int to = Integer.parseInt(rs.getString(1).trim());
sum += to;
sql = "update shopping set total=" + sum + " where id='" + id +
"'";
int ao = lk.Update(sql);
if (ao > 0) {
sql = "insert into jinhuo values('" + temp.get(1) + "','" +
temp.get(2) + "','" + num + "','" + time + "')";
lk.Update(sql);
JOptionPane.showMessageDialog(null, "庫存添加完成！", "成功",
JOptionPane.
INFORMATION_MESSAGE);
tbljinhuo.updateUI(); //更新表
}
else {
JOptionPane.showMessageDialog(null, "添加庫存失敗！", "錯誤",
JOptionPane.ERROR_MESSAGE);
rs.close();
lk.close();
return;
}
}
}
catch (SQLException ex1) {
}
catch (NumberFormatException ex1) {
}
try {
rs.close();
}
catch (SQLException ex2) {
}
lk.close();
}
else {
JOptionPane.showMessageDialog(null, "請在表中選擇需要進貨的商品", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
}
public void btncl_actionPerformed(ActionEvent e) { //清空進貨管理表中的數據
if (ve.size() == 0) {
return;
}
if (JOptionPane.showConfirmDialog(null, "確認清空？", "提示",
JOptionPane.YES_NO_OPTION) == 0) {
ve.removeAllElements(); //清空表中數據
tbljinhuo.updateUI();
}
}
public void btninto_actionPerformed(ActionEvent e) { //根據條件進貨明細表
vc.removeAllElements();
String yr = null;
String mn = null;
yr = cmbyear.getSelectedItem().toString();
mn = cmbmonth.getSelectedItem().toString();
String sql = "";
Link lk = new Link();
lk.connection();
sql = "select * from jinhuo where times like '" + yr + "-" + mn + "%'";
ResultSet rs = lk.Select(sql);
tblinto.updateUI();
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //進貨類別
v.add(rs.getString(2).trim()); //貨物名
v.add(rs.getString(3).trim()); //進貨量
v.add(rs.getString(4).trim()); //進貨時間
vc.add(v);
}
while (rs.next());
tblinto.updateUI();
}
else {
JOptionPane.showMessageDialog(null, "沒有記錄");
}
}
catch (SQLException ex) {
}
lk.close();
}
public void btncls_actionPerformed(ActionEvent e) {
if (vc.size() == 0) {
return;
}
if (JOptionPane.showConfirmDialog(null, "確認清空？", "提示",
JOptionPane.YES_NO_OPTION) == 0) {
vc.removeAllElements(); //清空表中數據
tblinto.updateUI();
}
}
public void btnall_actionPerformed(ActionEvent e) { //顯示全部
vc.removeAllElements();
String sql = "";
Link lk = new Link();
lk.connection();
sql = "select * from jinhuo";
ResultSet rs = lk.Select(sql);
tblinto.updateUI();
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //進貨類別
v.add(rs.getString(2).trim()); //貨物名
v.add(rs.getString(3).trim()); //進貨量
v.add(rs.getString(4).trim()); //進貨時間
vc.add(v);
}
while (rs.next());
tblinto.updateUI();
}
else {
JOptionPane.showMessageDialog(null, "沒有記錄");
}
}
catch (SQLException ex) {
}
lk.close();
}
public void btnyingye_actionPerformed(ActionEvent e) { //彈出統計框
Taking tk = new Taking();
tk.setSize(300, 250);
tk.setLocation(300, 250);
tk.show();
}
public void jMenuItem6_actionPerformed(ActionEvent e) {
Deluser dr=new Deluser();
dr.setLocation(300,250);
dr.setSize(360,290);
dr.show();
}
public void txtvipid_keyPressed(KeyEvent e) {
if ( (int) e.getKeyChar() == 10) {
btnsell_actionPerformed(null);
}
}
}
class MainFrm_jMenuItem6_actionAdapter
implements ActionListener {
private MainFrm adaptee;
MainFrm_jMenuItem6_actionAdapter(MainFrm adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuItem6_actionPerformed(e);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -