目錄：本篇含Java部分的第12，13個(gè)Java文件

12

package shouYinXiTong;

import java.awt.Color;

import java.awt.HeadlessException;

import java.awt.event.*;

import java.sql.*;

import java.util.*;

import javax.swing.*;

import javax.swing.table.DefaultTableModel;

class shiJian implements MouseListener, ActionListener {

public ptGuoWuCheCaozZuo jieShouchuangTi = null;

public shiJian(ptGuoWuCheCaozZuo chuangTi) {

this.jieShouchuangTi = chuangTi;

}

@Override

public void actionPerformed(ActionEvent arg0) {

String huoQuDaoDeWenZi = arg0.getActionCommand();

if (huoQuDaoDeWenZi.equals("條件查詢")) {

String gouWuCheId = jieShouchuangTi.

gouWuCheIdWenBenKuangTop.getText();

String spName = jieShouchuangTi

.spNameWenBenKuang.getText();

jieShouchuangTi.chuanZhi(gouWuCheId, spName);

}?

else if (huoQuDaoDeWenZi.equals("結(jié)算單件")) {

int row = jieShouchuangTi.jt1.getSelectedRow();

// int Column = jieShouchuangTi.jt1.getSelectedColumn();

String jiage=jieShouchuangTi.jt1.

getValueAt(row, 7).toString();

String num=jieShouchuangTi.jt1.

getValueAt(row, 8).toString();

Double jiesuan=Double.valueOf(jiage)*Double.valueOf(num);

jieShouchuangTi.spjieSuanWenBenKaung .

setText(String.valueOf(jiesuan).toString()+"元");

}?

else if (huoQuDaoDeWenZi.equals("查看現(xiàn)有商品編號(hào)和存貨數(shù)量")) {

new ptshangPinCaoZuo();

}?

else if (huoQuDaoDeWenZi.equals("增加購(gòu)物車")) {

String gouWuCheId = jieShouchuangTi.gouWuCheIdWenBenKuangTop

.getText();

String username = dengLu.unameWenBenKuang.getText();

//String userid = jieShouchuangTi.useridWenBenKaung.getText();

String sp_id = jieShouchuangTi.spIdWenBenKuang.getText();

String sp_num = jieShouchuangTi.spNumWenBenKuang.getText();

int row= jieShouchuangTi.jt1.getSelectedRow();

//String sp_num1 = jieShouchuangTi.jt1.

//getValueAt(row,8).toString();

String sp_id1 = jieShouchuangTi.jt1.

getValueAt(row,3).toString();

String sql = "select *? from yonghu "

+ " where yh_uname='"+username+"'";

System.out.println(sql);

ResultSet res = DBUtils.Select(sql);

try {

while(res.next()) {

// jieShouchuangTi.chuanZhi(null, null);

//

// JOptionPane.showMessageDialog(null, "增加成功！");

//

String userid=res.getString("yh_id");

String sqlinsert = "insert into gouwuche(yh_id,sp_id,sp_num) "?

+ "values(" + userid + "," + sp_id + ","+sp_num+")";

System.out.println(sqlinsert);

if (DBUtils.ZSG(sqlinsert)) {

jieShouchuangTi.chuanZhi(null, null);

JOptionPane.showMessageDialog(null, "增加成功！");

String sql2 = "select *? from sp where sp_id='" + sp_id1 + "'";

System.out.println(sql2);

ResultSet res1=DBUtils.Select(sql2);

try {

while(res1.next()){

int sp_cunhuo=res1.getInt("spCunHuoShuLiang");

int sp_cunhuoNew=sp_cunhuo-Integer.valueOf(sp_num);

String sql1 = "update sp set spCunHuoShuLiang='" + sp_cunhuoNew

+ "' where sp_id=" + sp_id1+"";

System.out.println(sql1);

DBUtils.ZSG(sql1);

}

} catch (NumberFormatException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} else {

JOptionPane.showMessageDialog

(null, "增加失?。∩唐肪幪?hào)不可重復(fù)！");

}

}

} catch (HeadlessException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} else if (huoQuDaoDeWenZi.equals("修改購(gòu)物車")) {

String gouWuCheId =?

jieShouchuangTi.gouWuCheIdWenBenKuang.getText();

String userid = jieShouchuangTi.useridWenBenKaung.getText();

String sp_id = jieShouchuangTi.spIdWenBenKuang.getText();

String sp_numNew = jieShouchuangTi.spNumWenBenKuang.getText();

int row= jieShouchuangTi.jt1.getSelectedRow();

String sp_numOld = jieShouchuangTi.jt1.

getValueAt(row,8).toString();

int? sp_numCha=Integer.valueOf(sp_numOld)-Integer.valueOf(sp_numNew);

String sql = "update gouwuche set sp_id='" + sp_id +?

"',sp_num='" + sp_numNew

+ "' where gwc_id='" + gouWuCheId+"'";

System.out.println(sql);

String sp_id1 = jieShouchuangTi.jt1.getValueAt(row,3).toString();

if (DBUtils.ZSG(sql)) {

jieShouchuangTi.chuanZhi(null, null);

JOptionPane.showMessageDialog(null, "修改成功!");

String sqlSelect = "select *? from sp where sp_id='" + sp_id1 + "'";

System.out.println(sqlSelect);

ResultSet res=DBUtils.Select(sqlSelect);

try {

while(res.next()){

int sp_cunhuo=res.getInt("spCunHuoShuLiang");

// int sp_cunhuoNew=sp_cunhuo-Integer.valueOf(sp_numNew);

String sqlUpdate = "update sp set spCunHuoShuLiang='"?

+ (sp_cunhuo+sp_numCha)

+ "' where sp_id=" + sp_id1+"";

System.out.println(sqlUpdate);

DBUtils.ZSG(sqlUpdate);

}

} catch (NumberFormatException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} else {

JOptionPane.showMessageDialog(null, "修改失敗!");

}

} else if (huoQuDaoDeWenZi.equals("清空")) {

jieShouchuangTi.gouWuCheIdWenBenKuangTop.setText("");

jieShouchuangTi.spNameWenBenKuang.setText("");

jieShouchuangTi.gouWuCheIdWenBenKuang.setText("");

jieShouchuangTi.useridWenBenKaung.setText("");

jieShouchuangTi.yhNameWenBenKuang.setText("");

jieShouchuangTi.spNameWenBenKuang2.setText("");

jieShouchuangTi.spDanJiaWenBenKuang.setText("");

jieShouchuangTi.spIdWenBenKuang.setText("");

jieShouchuangTi.spNumWenBenKuang.setText("");

jieShouchuangTi.spjieSuanWenBenKaung.setText("");

}

}

@Override

public void mouseClicked(MouseEvent arg0) {

if (arg0.getClickCount() == 2) {

int row = jieShouchuangTi.jt1.getSelectedRow();

jieShouchuangTi.spNameWenBenKuang2.

setText(jieShouchuangTi.jt1.getValueAt(row, 4)

.toString());

jieShouchuangTi.gouWuCheIdWenBenKuang.setText(jieShouchuangTi.jt1.

getValueAt(row, 0).toString());

jieShouchuangTi.useridWenBenKaung.

setText(jieShouchuangTi.jt1.getValueAt(row, 1).toString());

jieShouchuangTi.spIdWenBenKuang.

setText(jieShouchuangTi.jt1.getValueAt(row, 3).toString());

jieShouchuangTi.spNumWenBenKuang.

setText(jieShouchuangTi.jt1.getValueAt(row, 4)

.toString());

jieShouchuangTi.yhNameWenBenKuang.

setText(jieShouchuangTi.jt1.getValueAt(row, 2).toString());

jieShouchuangTi.spNumWenBenKuang.

setText(jieShouchuangTi.jt1.getValueAt(row, 8).toString());

jieShouchuangTi.spDanJiaWenBenKuang.

setText(jieShouchuangTi.jt1.getValueAt(row,7).toString()+"元");

} else if (arg0.isMetaDown()) {

int num = JOptionPane.showConfirmDialog(null, "確認(rèn)刪除嗎?");

if (num == 0) {

int row = jieShouchuangTi.jt1.getSelectedRow();

String gwc_id = jieShouchuangTi.jt1.getValueAt(row,0).toString();

String sql = "delete gouwuche where gwc_id='" + gwc_id + "'";

String sp_num = jieShouchuangTi.jt1.getValueAt(row,8).toString();

String sp_id = jieShouchuangTi.jt1.getValueAt(row,3).toString();

if (DBUtils.ZSG(sql)) {

jieShouchuangTi.chuanZhi(null, null);

JOptionPane.showMessageDialog(null, "刪除成功!");

String sqlSelect = "select *? from sp where sp_id='" + sp_id + "'";

System.out.println(sqlSelect);

ResultSet res=DBUtils.Select(sqlSelect);

try {

while(res.next()){

int sp_cunhuo=res.getInt("spCunHuoShuLiang");

int sp_cunhuoNew=sp_cunhuo+Integer.valueOf(sp_num);

String sqlUpdate = "update sp set spCunHuoShuLiang='"?

+ sp_cunhuoNew

+ "' where sp_id=" + sp_id+"";

System.out.println(sqlUpdate);

DBUtils.ZSG(sqlUpdate);

}

} catch (NumberFormatException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} else {

JOptionPane.showMessageDialog(null, "刪除失敗!");

}

}

}

}

@Override

public void mouseEntered(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mouseExited(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mousePressed(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mouseReleased(MouseEvent arg0) {

// TODO Auto-generated method stub

}

}

public class ptGuoWuCheCaozZuo extends JFrame {

public static ArrayList<Integer> jieHe = null;

public static JButton SelectAnNiu, insertAnNiu, updateAnNiu,

qingKongAnNiu ,jieSuan,spIdAnNiu= null;

public static DefaultTableModel dtm = null;

public static JPanel jp1, jp2, jp3 = null;

public static JTable jt1 = null;

public static JLabel jieSuanAllWenZi,gouWuCheIdWenZi1,

yhIdWenZi, gouWuCheIdWenZi2,

spNameWenZi,yhNameWenZi,

userIdWenZi,jieSuanDanJianWenZi,spIdWenZi,spNumWenZi,

spDanJiaWenZi= null;

public static JTextField jieSuanAllWenZiKuang,

gouWuCheIdWenBenKuangTop,?

spNameWenBenKuang ,spjieSuanWenBenKaung,spIdWenBenKuang= null;

public static JTextField gouWuCheIdWenBenKuang,?

useridWenBenKaung, yhNameWenBenKuang,spNumWenBenKuang,

spDanJiaWenBenKuang,

spNameWenBenKuang2 = null;

public ptGuoWuCheCaozZuo() {

this.setTitle("購(gòu)物車");

this.setLayout(null);

this.setSize(1000, 1000);

this.setLocationRelativeTo(null);

jp2 = new JPanel();

jp2.setBorder(BorderFactory.createLineBorder(Color.gray));

jp2.setLayout(null);

jp2.setBounds(670, 10, 300, 240);

gouWuCheIdWenZi1 = new JLabel("購(gòu)物車編號(hào):");

yhIdWenZi= new JLabel("商品名稱:");

gouWuCheIdWenZi1.setBounds(10, 10, 70, 30);

yhIdWenZi.setBounds(10, 50, 70, 30);

gouWuCheIdWenBenKuangTop = new JTextField();

spNameWenBenKuang = new JTextField();

gouWuCheIdWenBenKuangTop.setBounds(80, 10, 100, 30);

spNameWenBenKuang.setBounds(80, 50, 100, 30);

SelectAnNiu = new JButton("條件查詢");

SelectAnNiu.setBounds(80, 90, 100, 30);

spIdAnNiu = new JButton("查看現(xiàn)有商品編號(hào)和存貨數(shù)量");

spIdAnNiu.setBounds(80, 190, 200, 30);

spIdAnNiu.addActionListener(new shiJian(this));

jp2.add(spIdAnNiu);

jp2.add(gouWuCheIdWenZi1);

jp2.add(yhIdWenZi);

jp2.add(gouWuCheIdWenBenKuangTop);

jp2.add(spNameWenBenKuang);

jp2.add(SelectAnNiu);

jp3 = new JPanel();

jp3.setBorder(BorderFactory.createLineBorder(Color.gray));

jp3.setLayout(null);

jp3.setBounds(670, 280, 300, 620);

gouWuCheIdWenZi1 = new JLabel("購(gòu)物車編號(hào):");

yhIdWenZi = new JLabel("用戶編號(hào):");

yhNameWenZi = new JLabel("用戶名稱:");

spNameWenZi = new JLabel("商品名稱:");

jieSuanDanJianWenZi = new JLabel("結(jié)算單件:");

jieSuanDanJianWenZi.setBounds(10, 370, 70, 30);

jp3.add(jieSuanDanJianWenZi);

spIdWenZi = new JLabel("商品編號(hào):");

spIdWenZi .setBounds(10, 210, 70, 30);

jp3.add(spIdWenZi);

spNumWenZi = new JLabel("商品數(shù)量:");

spNumWenZi.setBounds(10, 250, 70, 30);

jp3 .add(spNumWenZi);

gouWuCheIdWenZi1.setBounds(10, 10, 70, 30);

yhIdWenZi.setBounds(10, 50, 70, 30);

yhNameWenZi.setBounds(10, 90, 70, 30);

spNameWenZi.setBounds(10, 130, 70, 30);

spDanJiaWenZi = new JLabel("商品單價(jià):");

spDanJiaWenZi.setBounds(10, 170, 70, 30);

jp3.add(spDanJiaWenZi);

spDanJiaWenBenKuang = new JTextField();

spDanJiaWenBenKuang.setEditable(false);

spDanJiaWenBenKuang.setForeground(Color.white);

spDanJiaWenBenKuang.setBackground(Color.black);

spDanJiaWenBenKuang.setBounds(80, 170, 100, 30);

jp3.add(spDanJiaWenBenKuang);

jp3.add(gouWuCheIdWenZi1);

jp3.add(yhIdWenZi);

jp3.add(spNameWenZi);

jp3.add(yhNameWenZi);

gouWuCheIdWenBenKuang = new JTextField();

gouWuCheIdWenBenKuang.setForeground(Color.white);

gouWuCheIdWenBenKuang.setBackground(Color.black);

useridWenBenKaung = new JTextField();

useridWenBenKaung.setEditable(false);

useridWenBenKaung.setForeground(Color.white);

useridWenBenKaung.setBackground(Color.black);

yhNameWenBenKuang = new JTextField();

spNameWenBenKuang2 = new JTextField();

spNameWenBenKuang2.setEditable(false);

spNameWenBenKuang2.setForeground(Color.white);

spNameWenBenKuang2.setBackground(Color.black);

spNumWenBenKuang = new JTextField();

spIdWenBenKuang= new JTextField();

yhNameWenBenKuang.setEditable(false);

yhNameWenBenKuang.setForeground(Color.white);

yhNameWenBenKuang.setBackground(Color.black);

gouWuCheIdWenBenKuang.setBounds(80, 10, 100, 30);

useridWenBenKaung.setBounds(80, 50, 100, 30);

yhNameWenBenKuang.setBounds(80, 90, 100, 30);

spNameWenBenKuang2.setBounds(80, 130, 100, 30);

spIdWenBenKuang.setBounds(80, 10, 170, 30);

spNumWenBenKuang.setBounds(80, 50, 210, 30);

spjieSuanWenBenKaung = new JTextField();

spjieSuanWenBenKaung.setEditable(false);

spjieSuanWenBenKaung.setBounds(80, 370, 100, 30);

gouWuCheIdWenBenKuang.setEditable(false);

jp3.add(spjieSuanWenBenKaung);

spIdWenBenKuang = new JTextField();

spIdWenBenKuang.setBounds(80, 210, 100, 30);

jp3.add(spIdWenBenKuang);

spNumWenBenKuang = new JTextField();

spNumWenBenKuang.setBounds(80, 250, 100, 30);

jp3.add(spNumWenBenKuang);

insertAnNiu = new JButton("增加購(gòu)物車");

insertAnNiu.setBounds(10, 290, 80, 30);

updateAnNiu = new JButton("修改購(gòu)物車");

updateAnNiu.setBounds(95, 290, 80, 30);

qingKongAnNiu = new JButton("清空");

qingKongAnNiu.setBounds(10, 330, 80, 30);

jieSuan = new JButton("結(jié)算單件");

jieSuan.setBounds(95, 330, 80, 30);

jieSuan.addActionListener(new shiJian(this));

jp3.add(jieSuan);

//

//

//jieSuanAllWenZi= new JLabel("結(jié)算總金額:");

//jieSuanAllWenZi.setBounds(10, 420, 80, 30);

//jp3.add(jieSuanAllWenZi);

jieSuanAllWenZi= new JLabel("結(jié)算總金額:");

jieSuanAllWenZi.setBounds(10, 420, 80, 30);

jp3.add(jieSuanAllWenZi);

jieSuanAllWenZiKuang= new JTextField();

jieSuanAllWenZiKuang.setBounds(85, 420, 80, 30);

jp3.add(jieSuanAllWenZiKuang);

SelectAnNiu.addActionListener(new shiJian(this));

insertAnNiu.addActionListener(new shiJian(this));

updateAnNiu.addActionListener(new shiJian(this));

qingKongAnNiu.addActionListener(new shiJian(this));

jp3.add(gouWuCheIdWenBenKuang);

jp3.add(useridWenBenKaung);

jp3.add(yhNameWenBenKuang);

jp3.add(spNameWenBenKuang2);

jp3.add(insertAnNiu);

jp3.add(updateAnNiu);

jp3.add(qingKongAnNiu);

this.add(jp2);

this.add(jp3);

this.setVisible(true);

chuanZhi(null, null);

}

public void chuanZhi(String gwc_id, String sp_name) {

if (jp1 != null) {

this.remove(jp1);

}

String sql = "select * from sp s inner "

+ "join gouwuche g on s.sp_id=g.sp_id "

+ "inner join yonghu y on y.yh_id=g.yh_id "

+ "inner join sp_type spt on "

+ "spt.sp_typeid=s.sp_typeid where yh_uname='"+dengLu

.unameWenBenKuang.getText()+"'";

if (gwc_id != null && gwc_id.length() > 0) {

sql += " and gwc_id='" + gwc_id + "'";

}

if (sp_name != null && sp_name.length() > 0) {

sql += " and sp_name like'%" + sp_name + "%'";

}

Vector<Object> v_head = new Vector<Object>();

v_head.add("購(gòu)物車編號(hào)");

v_head.add("用戶編號(hào)");

v_head.add("用戶姓名");

v_head.add("商品編號(hào)");

v_head.add("商品名稱");

v_head.add("商品介紹");

v_head.add("商品類型");

v_head.add("商品價(jià)格");

v_head.add("購(gòu)買數(shù)量");

Vector<Vector<Object>> v_body = new Vector<Vector<Object>>();

ResultSet res = DBUtils.Select(sql);

Double jieSuanAll=(double) 0;

try {

while (res.next()) {

Vector<Object> v = new Vector<Object>();

v.add(res.getInt("gwc_id"));

v.add(res.getInt("yh_id"));

v.add(res.getString("yh_uname"));

v.add(res.getInt("sp_id"));

v.add(res.getString("sp_name"));

v.add(res.getString("sp_jieshao"));

v.add(res.getString("sp_typename"));

v.add(res.getDouble("sp_price"));

//+"元"

v.add(res.getInt("sp_num"));

//+"件"

Double sp_price=res.getDouble("sp_price");

Double sp_num=res.getDouble("sp_num");

v_body.add(v);

jieSuanAll=jieSuanAll+sp_price*sp_num;

jieSuanAllWenZiKuang.

setText(jieSuanAll+"元");

}

} catch (SQLException e) {

e.printStackTrace();

}

dtm = new DefaultTableModel(v_body, v_head) {

@Override

public boolean isCellEditable(int a, int b) {

return false;

}

};

jt1 = new JTable(dtm);

jt1.addMouseListener(new shiJian(this));

jt1.getTableHeader().setReorderingAllowed(false);

jt1.getTableHeader().setResizingAllowed(false);

jt1.setBackground(Color.yellow);

?

jt1.setForeground(Color.blue);

JScrollPane jsp = new JScrollPane(jt1);

jsp.setBounds(0, 0, 650, 500);

jp1 = new JPanel();

jp2.setBackground(Color.blue);

//jp2.setForeground(Color.red);

jp3.setBackground(Color.red);

//jp3.setForeground(Color.blue);

//jp1.setBackground(Color.black);

jp1.setLayout(null);

jp1.setBounds(10, 10, 650, 500);

jp1.add(jsp);

this.add(jp1);

}

}

13

package shouYinXiTong;

import java.awt.Color;

import java.awt.Graphics;

import java.awt.Image;

import java.awt.Toolkit;

import java.awt.event.*;

import java.sql.*;

import java.util.*;

import javax.swing.*;

import javax.swing.table.DefaultTableModel;

class spczShiJian implements MouseListener, ActionListener {

public ptshangPinCaoZuo jieShouchuangTi = null;

public spczShiJian(ptshangPinCaoZuo chuangTi) {

this.jieShouchuangTi = chuangTi;

}

@Override

public void actionPerformed(ActionEvent arg0) {

String huoQuDaoDeWenZi = arg0.getActionCommand();

if (huoQuDaoDeWenZi.equals("條件查詢")) {

String sptypeid = jieShouchuangTi.jiHe.

get(jieShouchuangTi.xiaLaKuang.

getSelectedIndex()).toString();

String spName = jieShouchuangTi

.spNameWenBenKuang.getText();

jieShouchuangTi.chuanZhi(sptypeid, spName);

}?

else if (huoQuDaoDeWenZi.equals("查詢?nèi)?#34;)) {

jieShouchuangTi.chuanZhi(null, null);

}?

else if (huoQuDaoDeWenZi.equals("加入購(gòu)物車")) {

String sp_id = jieShouchuangTi.spIdWenBenKuang.getText();

String sql = "insert into gouwuche(sp_id) "?

+ "values("+sp_id +")";

if (DBUtils.ZSG(sql)) {

jieShouchuangTi.chuanZhi(null, null);

JOptionPane.showMessageDialog(null, "增加成功！");

} else {

JOptionPane.showMessageDialog(null, "增加失?。?#34;);

}

}?

}

@Override

public void mouseClicked(MouseEvent arg0) {

}

@Override

public void mouseEntered(MouseEvent arg0) {

}

@Override

public void mouseExited(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mousePressed(MouseEvent arg0) {

// TODO Auto-generated method stub

}

@Override

public void mouseReleased(MouseEvent arg0) {

// TODO Auto-generated method stub

}

}

public class ptshangPinCaoZuo extends JFrame {

public static ArrayList<Integer> jieHe = null;

public static JButton SelectAnNiu,SelectAllAnNiu

= null;

public static DefaultTableModel dtm = null;

public static JPanel jp1, jp2, jp3 = null;

public static JTable jt1 = null;

public static ArrayList<Integer> jiHe = null;

public static JLabel spNameWenZi,spLeiXingWenZi, imgJLabel= null;

public static JTextField?

spNameWenBenKuang ,spIdWenBenKuang

= null;

public static JComboBox xiaLaKuang = null;

public ptshangPinCaoZuo() {

this.setTitle("商品操作");

this.setLayout(null);

this.setSize(1000, 1000);

this.setLocationRelativeTo(null);

jp2 = new JPanel();

jp2.setBorder(BorderFactory.createLineBorder(Color.gray));

jp2.setLayout(null);

jp2.setBounds(670, 10, 300, 250);

//class GamePanel extends JPanel {

//public void paint(Graphics g) {

//

//super.paint(g);

//

///*

//

//* graphics:制圖法。Graphics用途: 閉屏圖像上，進(jìn)行繪制。

//

//* paint:描繪。imgBack背景圖。observer:觀察者。?

//* img:圖片代碼（路徑或前面聲明數(shù)組， 可用數(shù)組表示等）

//

//* g.drawImage (img,x，y，width, height, observer)。

//*? this為面板（JPanel）對(duì)象

//

//

//

//* ，面板的width, height, 有時(shí)可忽略不寫。

//

//

//

//*/

//Image img=Toolkit. getDefaultToolkit().

//createImage("img\\頭像.png");

//g.drawImage (img,670, 280, 300, 400, jp3);

//

//

//}}

spNameWenZi=new JLabel("商品名稱：");

spNameWenZi.setBounds(20, 50, 100, 30);

jp2.add(spNameWenZi);

spLeiXingWenZi=new JLabel("商品類型：");

spLeiXingWenZi.setBounds(20, 90, 100, 30);

jp2.add(spLeiXingWenZi);

spNameWenBenKuang = new JTextField();

spNameWenBenKuang.setBounds(85, 50, 100, 30);

xiaLaKuang = new JComboBox();

xiaLaKuang.setBounds(85, 90, 100, 30);

String sql = "select * from sp_type";

ResultSet res_type = DBUtils.Select(sql);

jiHe = new ArrayList<Integer>();

try {

while (res_type.next()) {

xiaLaKuang.addItem(res_type.getObject(2));

jiHe.add(res_type.getInt(1));

}} catch (SQLException e) {

e.printStackTrace();

}

SelectAnNiu = new JButton("條件查詢");

SelectAnNiu.setBounds(85, 170, 100, 30);

SelectAnNiu.addActionListener(new spczShiJian(this));

jp2.add(SelectAnNiu);

SelectAllAnNiu = new JButton("查詢?nèi)?#34;);

SelectAllAnNiu.setBounds(85, 210, 100, 30);

SelectAllAnNiu.addActionListener(new spczShiJian(this));

jp2.add(SelectAllAnNiu);

jp2.add(xiaLaKuang);

jp2.add(spNameWenBenKuang);

jp3 = new JPanel();

jp3.setBorder(BorderFactory.createLineBorder(Color.gray));

jp3.setLayout(null);

?imgJLabel = new JLabel();

imgJLabel.setBounds(0, 0, 300, 400);

imgJLabel.setIcon(new?

ImageIcon("img//dd.jpg"));

jp3.add(imgJLabel);

jp3.setBounds(670, 280, 300, 400);

this.add(jp2);

this.add(jp3);

this.setVisible(true);

chuanZhi(null, null);

}

public void chuanZhi(String spLeiXingId, String spName) {

if (jp1 != null) {

this.remove(jp1);

}

String sql = "select * from sp s inner "

+ "join sp_type spt on "

+ "spt.sp_typeid=s.sp_typeid where 1=1";

if (spLeiXingId != null && spLeiXingId.length() > 0) {

sql += " and s.sp_typeid='" + spLeiXingId + "'";

}

if (spName != null && spName.length() > 0) {

sql += " and s.sp_name like'%" + spName + "%'";

}

Vector<Object> v_head = new Vector<Object>();

v_head.add("商品編號(hào)");

v_head.add("商品名稱");

v_head.add("商品介紹");

v_head.add("商品類型");

v_head.add("商品價(jià)格");

v_head.add("存貨數(shù)量");

Vector<Vector<Object>> v_body =

new Vector<Vector<Object>>();

ResultSet res = DBUtils.Select(sql);

try {

while (res.next()) {

Vector<Object> v = new Vector<Object>();

v.add(res.getInt("sp_id"));

v.add(res.getString("sp_name"));

v.add(res.getString("sp_jieshao"));

v.add(res.getString("sp_typename"));

v.add(res.getDouble("sp_price"));

v.add(res.getDouble("spCunHuoShuLiang"));

v_body.add(v);

}

} catch (SQLException e) {

e.printStackTrace();

}

dtm = new DefaultTableModel(v_body, v_head) {

@Override

public boolean isCellEditable(int a, int b) {

return false;

}

};

jt1 = new JTable(dtm);

jt1.addMouseListener(new spczShiJian(this));

jt1.getTableHeader().setReorderingAllowed(false);

jt1.getTableHeader().setResizingAllowed(false);

jt1.setBackground(Color.yellow);

jt1.setForeground(Color.blue);

JScrollPane jsp = new JScrollPane(jt1);

jsp.setBounds(0, 0, 650, 500);

jp1 = new JPanel();

jp1.setBackground(Color.black);

jp2.setBackground(Color.blue);

jp3.setBackground(Color.green);

jp1.setLayout(null);

jp1.setBounds(10, 10, 650, 500);

jp1.add(jsp);

this.add(jp1);

}

}