import java.sql.*;
import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;public class DisplayDemo extends JFrame {
private String dbURL = "jdbc:mysql://localhost/book?useUnicode=true&characterEncoding=GBK"; // 数据库标识名
private String user = "root"; // 数据库用户
private String password = ""; // 数据库用户密码
private JTable table; public DisplayDemo() {
super("显示数据库查询结果"); // 调用父类构造函数
//super("显示数据库查询结果"); // 调用父类构造函数
final Frame f=new Frame("http");
f.setSize(600,400);
MenuBar mb= new MenuBar();
Menu m1=new Menu("文件");
Menu m2=new Menu("编辑");
MenuItem mi1=new MenuItem("新建");
MenuItem mi2=new MenuItem("打开");
mi2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
try{
}
catch(Exception ex){
ex.printStackTrace();
}
}
} );
MenuItem mi3=new MenuItem("保存");
MenuItem mi4=new MenuItem("退出");
mi4.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
System.exit(0);
}
} );
MenuItem mi5=new MenuItem("复制");
MenuItem mi6=new MenuItem("粘贴");
m1.add(mi1);
m1.add(mi2);
m1.add(mi3);
m1.add(mi4);
m2.add(mi5);
m2.add(mi6);
mb.add(m1);
mb.add(m2);
f.setMenuBar(mb);
f.setVisible(true);
String[] columnNames = { "序号", "书名", "副标题", "作者", "国籍", "出版社", "价格",
"ISBN" }; // 列名
Object[][] rowData = new Object[9][8]; // 表格数据 try {
Class.forName("com.mysql.jdbc.Driver"); // 加载驱动器
Connection con = DriverManager.getConnection(dbURL, user, password); // 获取连接
String sqlStr = "select * from user"; // 查询语句
PreparedStatement ps = con.prepareStatement(sqlStr); // 获取PreparedStatement对象
ResultSet rs = ps.executeQuery(); // 执行查询
String id, title, subhead, authors, nationality, publisher, price, isbn; // 查询结果
// int age;
int count = 0;
while (rs.next()) { // 遍历查询结果
rowData[count][0] = rs.getString("id"); // 初始化数组内容
// rowData[count][1]=Integer.toString(rs.getInt("title"));
rowData[count][1] = rs.getString("title");
rowData[count][2] = rs.getString("subhead");
rowData[count][3] = rs.getString("authors");
rowData[count][4] = rs.getString("nationality");
rowData[count][5] = rs.getString("publisher");
rowData[count][6] = rs.getString("price");
rowData[count][7] = rs.getString("isbn");
count++;
}
con.close(); // 关闭连接
} catch (Exception ex) {
ex.printStackTrace(); // 输出出错信息
}
Container container = getContentPane(); // 获取窗口容器
table = new JTable(rowData, columnNames); // 实例化表格
table.getColumn("序号").setMaxWidth(30); // 设置行宽
table.getColumn("书名").setMaxWidth(200);
table.getColumn("副标题").setMaxWidth(200);
table.getColumn("作者").setMaxWidth(80);
table.getColumn("国籍").setMaxWidth(50);
table.getColumn("出版社").setMaxWidth(100);
table.getColumn("价格").setMaxWidth(40);
table.getColumn("ISBN").setMaxWidth(100);
container.add(new JScrollPane(table), BorderLayout.CENTER); // 增加组件 setSize(800, 600); // 设置窗口尺寸
setVisible(true); // 设置窗口可视
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); // 关闭窗口时退出程序
} public static void main(String[] args) {
new DisplayDemo();
}
}这个是用表格导出数据库文件的,我想在上面添加菜单,但是就是加不了
解决方案 »
- socket为何会自己closed?
- 存储过程
- 高手前辈都来讨论一下呀!软件制作另存为的问题!急!
- 请问Java如何设置header让服务器发送普通页面而不是gzip压缩过的页面?
- 求助:一个拼图游戏的图形显示问题 60分
- JCreator的运行出现问题,高手请进!
- 【不是广告】帮朋友发,欲转让《Java思想》第三版,9成新,4折,最好是南京朋友!mail:[email protected]
- 这本书怎么样,大侠帮忙看一下!
- 如何使用Postgres的JDBC驱动?
- 代码转移后出现错误NoSuchFieldError
- 求教:ftpClient的问题
- 求助:鼠标移动事件调用方法实例化对象产生垃圾对象?!
import java.awt.Font;
import java.awt.Frame;
import java.awt.Rectangle;
import java.awt.SystemColor;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.DecimalFormat;
import java.text.NumberFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Vector;import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;import com.superet.conn.NetConn;public class CashRegister extends JDialog implements ActionListener {
private JPanel jContentPane = null;
private JScrollPane jScrollPane = null;
private JTable jTable = null;
private DefaultTableModel defaultTableModel = null;
private JLabel jLabelDealingIDTitle = null;
public JLabel jLabelDealingID = null;
private JLabel jLabelUserNameTitle = null;
private JComboBox jComboBoxUserName = null;
private JLabel jLabelPayWayTitle = null;
private JComboBox jComboBoxPayWay = null;
static Vector vecTitle = null;
private JLabel jLabelMerchID = null;
private JTextField jTextFieldProductID = null;
private JLabel jLabelNumber = null;
private JTextField jTextFieldNumber = null;
private JLabel jLabelSum = null;
static JLabel jLabelSumShow = null;
private JLabel jLabelMerberID = null;
private JLabel jShouyin = null;
static JLabel jLabelMerberIDShow = null;
private JLabel jLabelMerberName = null;
static JLabel jLabelMerberNameShow = null;
private JLabel jLabelMerberLevel = null;
static JLabel jLabelMerberLevelShow = null;
private JLabel jLabelMerberDiscount = null;
static JLabel jLabelMerberDiscountShow = null;
private JLabel jLabelMerberPoints = null;
static JLabel jLabelMerberPointsShow = null;
private JLabel jLabelCustomerType = null;
static JRadioButton jRadioButtonCommon = null;
static JRadioButton jRadioButtonMerBer = null;
private ButtonGroup bg = new ButtonGroup();
private JButton jButtonAdd = null;
private JButton jButtonPay = null;
private JLabel jLabelNum = null;
private JLabel jLabelNumShow = null;
private JButton jButtonExit = null;
private JButton jButtonDelete = null;
NetConn conn;
Statement st;
ResultSet rs;
String sql1,userName;
Vector vec;
public Vector getVecTitle(){
vecTitle = new Vector();
vecTitle.add("序号");
vecTitle.add("商品编号");
vecTitle.add("商品名称");
vecTitle.add("商品售价");
vecTitle.add("折扣率");
vecTitle.add("折后价格");
vecTitle.add("数量");
vecTitle.add("金额");
return vecTitle;
}
public SuperetMain myFrame = null;
/**
* @param owner
*/
//
public CashRegister(Frame f,String name) {
userName=name;
//super(f,s,b);
myFrame =(SuperetMain)f;
initialize();
this.setVisible(true);
} /**
* This method initializes this
*
* @return void
*/
private void initialize() {
this.setTitle("CashRegister");
this.setSize(1024, 768);
this.setModal(true);
this.setLocationRelativeTo(this);
this.setContentPane(getJContentPane());
}
* This method initializes jContentPane
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPane() {
if (jContentPane == null) {
jLabelNumShow = new JLabel();
jLabelNumShow.setBounds(new Rectangle(38, 605, 53, 25));
jLabelNumShow.setForeground(Color.WHITE);
jLabelNumShow.setText("");
jLabelNum = new JLabel();
jLabelNum.setBounds(new Rectangle(0, 605, 40, 25));
jLabelNum.setForeground(Color.WHITE);
jLabelNum.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelNum.setText("总计:");
jLabelCustomerType = new JLabel();
jLabelCustomerType.setBounds(new Rectangle(790, 0, 67, 35));
jLabelCustomerType.setForeground(Color.WHITE);
jLabelCustomerType.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelCustomerType.setText("顾客类型:");
jLabelMerberPointsShow = new JLabel();
jLabelMerberPointsShow.setBounds(new Rectangle(882, 689, 114, 42));
jLabelMerberPointsShow.setForeground(Color.WHITE);
jLabelMerberPointsShow.setText("");
jLabelMerberPoints = new JLabel();
jLabelMerberPoints.setBounds(new Rectangle(813, 689, 69, 42));
jLabelMerberPoints.setForeground(Color.WHITE);
jLabelMerberPoints.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelMerberPoints.setText("会员积分:");
jLabelMerberDiscountShow = new JLabel();
jLabelMerberDiscountShow.setBounds(new Rectangle(683, 689, 114, 42));
jLabelMerberDiscountShow.setForeground(Color.WHITE);
jLabelMerberDiscountShow.setText("");
jLabelMerberDiscount = new JLabel();
jLabelMerberDiscount.setBounds(new Rectangle(614, 689, 69, 42));
jLabelMerberDiscount.setForeground(Color.WHITE);
jLabelMerberDiscount.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelMerberDiscount.setText("会员折扣:");
jLabelMerberLevelShow = new JLabel();
jLabelMerberLevelShow.setBounds(new Rectangle(485, 689, 114, 42));
jLabelMerberLevelShow.setForeground(Color.WHITE);
jLabelMerberLevelShow.setText("");
jLabelMerberLevel = new JLabel();
jLabelMerberLevel.setBounds(new Rectangle(418, 689, 69, 42));
jLabelMerberLevel.setForeground(Color.WHITE);
jLabelMerberLevel.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelMerberLevel.setText("会员级别:");
jLabelMerberNameShow = new JLabel();
jLabelMerberNameShow.setBounds(new Rectangle(288, 689, 114, 42));
jLabelMerberNameShow.setForeground(Color.WHITE);
jLabelMerberNameShow.setText("");
jLabelMerberName = new JLabel();
jLabelMerberName.setBounds(new Rectangle(219, 689, 69, 42));
jLabelMerberName.setForeground(Color.WHITE);
jLabelMerberName.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelMerberName.setText("会员名称:");
jLabelMerberIDShow = new JLabel();
jLabelMerberIDShow.setBounds(new Rectangle(89, 689, 114, 42));
jLabelMerberIDShow.setForeground(Color.WHITE);
jLabelMerberIDShow.setText("");
jLabelMerberID = new JLabel();
jLabelMerberID.setBounds(new Rectangle(20, 689, 69, 42));
jLabelMerberID.setForeground(Color.WHITE);
jLabelMerberID.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelMerberID.setText("会员编号:");
jLabelSumShow = new JLabel();
jLabelSumShow.setBounds(new Rectangle(917, 636, 69, 42));
jLabelSumShow.setText("0.00"+"元");
jLabelSumShow.setForeground(Color.RED);
jLabelSum = new JLabel();
jLabelSum.setBounds(new Rectangle(848, 636, 69, 42));
jLabelSum.setText("合计金额: ");
jLabelSum.setForeground(Color.RED);
jLabelNumber = new JLabel();
jLabelNumber.setBounds(new Rectangle(268, 637, 43, 42));
jLabelNumber.setForeground(Color.WHITE);
jLabelNumber.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelNumber.setText("数量:");
jLabelMerchID = new JLabel();
jLabelMerchID.setBounds(new Rectangle(20, 637, 114, 42));
jLabelMerchID.setForeground(Color.WHITE);
jLabelMerchID.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelMerchID.setText("请输入商品编号:");
jLabelPayWayTitle = new JLabel();
jLabelPayWayTitle.setBounds(new Rectangle(515, 0, 67, 35));
jLabelPayWayTitle.setForeground(Color.WHITE);
jLabelPayWayTitle.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelPayWayTitle.setText("付款方式:");
jLabelUserNameTitle = new JLabel();
jLabelUserNameTitle.setBounds(new Rectangle(269, 0, 53, 35));
jLabelUserNameTitle.setForeground(Color.WHITE);
jLabelUserNameTitle.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelUserNameTitle.setText("收银员: ");
jShouyin = new JLabel();
jShouyin.setBounds(new Rectangle(319, 0, 53, 35));
jShouyin.setForeground(Color.WHITE);
jShouyin.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jShouyin.setText(userName);
// jShouyin.setText("张三");
//生成交易编号
jLabelDealingID = new JLabel();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddkkmmss");
jLabelDealingID.setBounds(new Rectangle(88, 0, 123, 35));
jLabelDealingID.setForeground(Color.WHITE);
jLabelDealingID.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelDealingID.setText("DY"+sdf.format(new Date()));
jLabelDealingIDTitle = new JLabel();
jLabelDealingIDTitle.setBounds(new Rectangle(21, 0, 67, 35));
jLabelDealingIDTitle.setForeground(Color.WHITE);
jLabelDealingIDTitle.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jLabelDealingIDTitle.setText("交易编号: ");
jContentPane = new JPanel();
jContentPane.setLayout(null);
jContentPane.add(getJScrollPane(), null);
jContentPane.add(jLabelDealingIDTitle, null);
jContentPane.add(jLabelDealingID, null);
jContentPane.add(jShouyin, null);
jContentPane.add(jLabelUserNameTitle, null);
jContentPane.add(jLabelPayWayTitle, null);
jContentPane.add(getJComboBoxPayWay(), null);
jContentPane.add(jLabelMerchID, null);
jContentPane.add(getjTextFieldProductID(), null);
jContentPane.add(jLabelNumber, null);
jContentPane.add(getJTextFieldNumber(), null);
jContentPane.add(jLabelSum, null);
jContentPane.add(jLabelSumShow, null);
jContentPane.add(jLabelMerberID, null);
jContentPane.add(jLabelMerberIDShow, null);
jContentPane.add(jLabelMerberName, null);
jContentPane.add(jLabelMerberNameShow, null);
jContentPane.add(jLabelMerberLevel, null);
jContentPane.add(jLabelMerberLevelShow, null);
jContentPane.add(jLabelMerberDiscount, null);
jContentPane.add(jLabelMerberDiscountShow, null);
jContentPane.add(jLabelMerberPoints, null);
jContentPane.add(jLabelMerberPointsShow, null);
jContentPane.add(jLabelCustomerType, null);
jContentPane.add(getJRadioButtonCommon(), null);
jContentPane.add(getJRadioButtonMerBer(), null);
jContentPane.add(getJButtonAdd(), null);
jContentPane.add(getJButtonPay(), null);
jContentPane.add(jLabelNum, null);
jContentPane.add(jLabelNumShow, null);
jContentPane.add(getJButtonExit(), null);
jContentPane.add(getJButtonDelete(), null);
jContentPane.setBackground(SystemColor.darkGray);//背景颜色
}
return jContentPane;
}
* This method initializes jScrollPane
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane() {
if (jScrollPane == null) {
jScrollPane = new JScrollPane();
jScrollPane.setBounds(new Rectangle(0, 35, 1017, 571));
jScrollPane.setViewportView(getJTable());
}
return jScrollPane;
} /**
* This method initializes jTable
*
* @return javax.swing.JTable
*/
JTable getJTable() {
if (jTable == null) {
jTable = new JTable(getDefaultTableModel());
jTable.getTableHeader().setReorderingAllowed(false);
jTable.setRowHeight(50); }
return jTable;
}
private DefaultTableModel getDefaultTableModel(){
Vector vecData = new Vector();
defaultTableModel = new DefaultTableModel(vecData,getVecTitle());
return defaultTableModel;
} /**
* This method initializes jComboBoxPayWay
* 选择现金刷卡
* @return javax.swing.JComboBox
*/
private JComboBox getJComboBoxPayWay() {
if (jComboBoxPayWay == null) {
jComboBoxPayWay = new JComboBox();
jComboBoxPayWay.setBackground(Color.gray);
jComboBoxPayWay.setForeground(Color.WHITE);
jComboBoxPayWay.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jComboBoxPayWay.addItem("现金支付");
jComboBoxPayWay.addItem("刷卡支付");
jComboBoxPayWay.setBounds(new Rectangle(582, 0, 123, 35));
jComboBoxPayWay.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(jComboBoxPayWay.getSelectedItem().equals("刷卡支付")){
int i = JOptionPane.showConfirmDialog(null, "确定刷卡支付吗?", "提示", JOptionPane.YES_NO_OPTION);
if(i==0){
JOptionPane.showMessageDialog(null, "卡上余额不足,请现金支付", "提示", JOptionPane.CANCEL_OPTION);
jComboBoxPayWay.setSelectedItem("现金支付");
}
else{
jComboBoxPayWay.setSelectedItem("现金支付");
}
}
}
});
}
return jComboBoxPayWay;
}
/**
* This method initializes jRadioButtonCommon
* 普通
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonCommon() {
if (jRadioButtonCommon == null) {
jRadioButtonCommon = new JRadioButton();
jRadioButtonCommon.setBounds(new Rectangle(856, 7, 54, 21));
jRadioButtonCommon.setBackground(Color.gray);
jRadioButtonCommon.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jRadioButtonCommon.setText("普通");
jRadioButtonCommon.setSelected(true);
jRadioButtonCommon.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent e) {
CashRegister.jLabelMerberIDShow.setText("");
CashRegister.jLabelMerberNameShow.setText("");
CashRegister.jLabelMerberLevelShow.setText("");
CashRegister.jLabelMerberDiscountShow.setText("");
CashRegister.jLabelMerberPointsShow.setText("");
}
});
bg.add(jRadioButtonCommon);
}
return jRadioButtonCommon;
} /**
* This method initializes jRadioButtonMerBer
* 会员
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonMerBer() {
if (jRadioButtonMerBer == null) {
jRadioButtonMerBer = new JRadioButton();
jRadioButtonMerBer.setBounds(new Rectangle(910, 7, 54, 21));
jRadioButtonMerBer.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jRadioButtonMerBer.setText("会员");
jRadioButtonMerBer.setSelected(false);// 交易后返回普通用户
bg.add(jRadioButtonMerBer);
jRadioButtonMerBer.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent e) {
if(e.getStateChange()==e.SELECTED){
JDialogDealingInfo_SelectMerber jDialogDealingInfo_SelectMerber = new JDialogDealingInfo_SelectMerber(null,"会员",true);
}
}
});
}
return jRadioButtonMerBer;
}
/**
* This method initializes jTextFieldProductID
* 输入购买商品编号
* @return javax.swing.JTextField
*/
private JTextField getjTextFieldProductID() {
if (jTextFieldProductID == null) {
jTextFieldProductID = new JTextField();
jTextFieldProductID.setBounds(new Rectangle(134, 637, 114, 42));
}
return jTextFieldProductID;
} /**
* This method initializes jTextFieldNumber
* 输入购买商品数量
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldNumber() {
if (jTextFieldNumber == null) {
jTextFieldNumber = new JTextField("1");
jTextFieldNumber.setBounds(new Rectangle(309, 637, 114, 42));
}
return jTextFieldNumber;
}
public Vector selectProduct_ID(int id) {
String sql = "select * from ProductInfo where Product_ID = "+id+"";
System.out.println(sql);
Vector vec = new Vector();
conn = new NetConn();
try {
st=conn.getConnection();
rs = st.executeQuery(sql);
while(rs.next()) {
vec.add(rs.getInt("Product_ID"));
vec.add(rs.getString("Product_Name"));
vec.add(rs.getFloat("Product_OutPrice"));
System.out.println(1);
}
rs.close();
st.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
System.out.println(4);
}
System.out.println(5);
return vec;
}
public boolean validateProductID(int productId){
String sql = "select * from ProductInfo where Product_ID="+productId;
try {
conn=new NetConn();
st=conn.getConnection();
rs = st.executeQuery(sql);
while(rs.next()){
return true;
}
st.close();
} catch (Exception e) {
// TODO: handle exception
System.out.println("##### "+e);
}
return false;
}
* This method initializes jButtonAdd
* 收银台添加商品
* @return javax.swing.JButton
*/
private JButton getJButtonAdd() {
if (jButtonAdd == null) {
jButtonAdd = new JButton();
jButtonAdd.setBounds(new Rectangle(443, 636, 69, 42));
jButtonAdd.setBackground(Color.gray);
jButtonAdd.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jButtonAdd.setText("添加");
jButtonAdd.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
java.util.regex.Pattern pattern=java.util.regex.Pattern.compile("[0-9]*");
java.util.regex.Matcher match=pattern.matcher(jTextFieldProductID.getText().trim().toString()); if(match.matches()){
Integer in = 0;
if(jTextFieldProductID.getText().equals("")){
JOptionPane.showMessageDialog(null, "请输入商品编号", "提示", JOptionPane.CANCEL_OPTION);
}else{
in = new Integer(jTextFieldProductID.getText());
if(!(validateProductID(in))){
jTextFieldProductID.setText("");
JOptionPane.showMessageDialog(null, "该商品不存在", "提示", JOptionPane.CANCEL_OPTION);
}else if(match.matches()){
// Integer in = new Integer(jTextFieldProductID.getText());
Vector vecMerch = null;
vecMerch=selectProduct_ID(in.intValue());
DecimalFormat nf = new DecimalFormat("########.##");
//如果选择普通类型
if(jRadioButtonCommon.isSelected()){
System.out.println(8);
try {
System.out.println(9);
float commonDiscount = 1;//折扣率,即:不打折
// Float price = Float.valueOf(vecMerch.get(2).toString())*commonDiscount;
System.out.println("@@@@@@@");
float price = (((Float)vecMerch.get(2)).floatValue())*commonDiscount; //折后价格
Integer in2 = new Integer(jTextFieldNumber.getText());
int number = in2.intValue();//商品数量
float sumOld = price * number;
Float sum = Float.valueOf(nf.format(sumOld));//总价格
System.out.println(10);
if(jTextFieldNumber.getText().equals("") || jTextFieldNumber.getText()== null){
JOptionPane.showMessageDialog(null, "商品数量不能为空", "提示", JOptionPane.CANCEL_OPTION);
}
else if(jTextFieldNumber.getText().matches("[0-9]*")){
//jTable里没有购买信息的时候
if(jTable.getModel()==null){
vecMerch.add(0,1);//从第一列第一行开始添加
vecMerch.add(commonDiscount);//折扣率
vecMerch.add(price);//折后价格
vecMerch.add(number);//商品数量
vecMerch.add(sum);//总价格
((DefaultTableModel)jTable.getModel()).addRow(vecMerch);//把购买信息添加到jTable //显示购买信息
jLabelNumShow.setText("1"+"件");
Float f = (Float)((DefaultTableModel)jTable.getModel()).getValueAt(0, 7);
jLabelSumShow.setText(nf.format(f)+" 元");
}else{
//jTable里有购买信息的时候
int rowCount1 = ((DefaultTableModel)jTable.getModel()).getRowCount()+1;
vecMerch.add(0,rowCount1);//从第一列第rowCount1行开始添加
vecMerch.add(commonDiscount);
vecMerch.add(price);
vecMerch.add(number);
vecMerch.add(sum);
((DefaultTableModel)jTable.getModel()).addRow(vecMerch);
//序号
Integer in3 = new Integer(rowCount1);
jLabelNumShow.setText(in3.toString()+"件");
float f = 0;
for(int i=0;i<rowCount1; i++){
Float f1 = (Float)((DefaultTableModel)jTable.getModel()).getValueAt(i, 7);
f += f1;
}
jLabelSumShow.setText(nf.format(f)+" 元");
}
}
else{
JOptionPane.showMessageDialog(null, "请输入正确的商品数量", "提示", JOptionPane.CANCEL_OPTION);
}
}
catch (Exception e2) {
// TODO: handle exception
e2.printStackTrace();
System.out.println("N");
JOptionPane.showMessageDialog(null, "操作失败", "错误", JOptionPane.CANCEL_OPTION);
}
}
else{
//如果没有选择会员类型,
try {
int rowCount = ((DefaultTableModel)jTable.getModel()).getRowCount()+1;
Float f = null;
if(jLabelMerberDiscountShow.getText().equals("")){
JOptionPane.showMessageDialog(null, "请登录会员", "提示", JOptionPane.CANCEL_OPTION);
CashRegister.jRadioButtonCommon.setSelected(true);
jRadioButtonMerBer.setSelected(false);
}else{
f = new Float(jLabelMerberDiscountShow.getText());
// Float f = new Float(jLabelMerberDiscountShow.getText()).equals(0)?10: new Float(jLabelMerberDiscountShow.getText());
float commonDiscount = f.floatValue()/10; //折扣率
float price = (((Float)vecMerch.get(2)).floatValue())*commonDiscount; //折后价格
Integer in2 = new Integer(jTextFieldNumber.getText());
int number = in2.intValue(); //商品数量
float sumOld = price * number;
Float sum = Float.valueOf(nf.format(sumOld));//总价格
if(jTextFieldNumber.getText().equals("")){
JOptionPane.showMessageDialog(null, "商品数量不能为空", "提示", JOptionPane.CANCEL_OPTION);
}
else if(jTextFieldNumber.getText().matches("[0-9]*")){
if(jTable.getModel()==null){
vecMerch.add(0,1);
vecMerch.add(commonDiscount);
vecMerch.add(price);
vecMerch.add(number);
vecMerch.add(sum);
((DefaultTableModel)jTable.getModel()).addRow(vecMerch);
jLabelNumShow.setText("1"+"件");
Float ff = (Float)((DefaultTableModel)jTable.getModel()).getValueAt(0, 7);
jLabelSumShow.setText(nf.format(ff)+" 元");
}else{
int rowCount2 = ((DefaultTableModel)jTable.getModel()).getRowCount()+1;
vecMerch.add(0,rowCount2);
vecMerch.add(commonDiscount);
vecMerch.add(price);
vecMerch.add(number);
vecMerch.add(sum);
((DefaultTableModel)jTable.getModel()).addRow(vecMerch);
//�����ܼ���
Integer in3 = new Integer(rowCount2);
jLabelNumShow.setText(in3.toString()+"件");
//�����ܽ��
float ff = 0;
for(int i=0;i<rowCount2; i++){
Float f1 = (Float)((DefaultTableModel)jTable.getModel()).getValueAt(i, 7);
ff += f1;
}
jLabelSumShow.setText(nf.format(ff)+" 元");
}
}
else{
JOptionPane.showMessageDialog(null, "请输入正确的商品数量", "提示", JOptionPane.CANCEL_OPTION);
}
}
}
catch (Exception e2) {
// TODO: handle exception
e2.printStackTrace();
JOptionPane.showMessageDialog(null, "操作失败,请重新输入", "提示", JOptionPane.CANCEL_OPTION);
}
}
jTextFieldProductID.getText();
}
}}
else{
jTextFieldProductID.setText("");
JOptionPane.showMessageDialog(null, "请输入正确的商品编号", "提示", JOptionPane.CANCEL_OPTION);
}
}
});
}
return jButtonAdd;
}
* This method initializes jButtonPay
*
* @return javax.swing.JButton
*/
private JButton getJButtonPay() {
if (jButtonPay == null) {
jButtonPay = new JButton();
jButtonPay.setBounds(new Rectangle(533, 636, 69, 42));
jButtonPay.setBackground(Color.red);
jButtonPay.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jButtonPay.setText("付款");
jButtonPay.addActionListener(this);
}
return jButtonPay;
}
/**
* This method initializes jButtonDelete
*
* @return javax.swing.JButton
*/
private JButton getJButtonDelete() {
if (jButtonDelete == null) {
jButtonDelete = new JButton();
jButtonDelete.setBounds(new Rectangle(623, 636, 69, 42));
jButtonDelete.setBackground(Color.gray);
jButtonDelete.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jButtonDelete.setText("删除");
jButtonDelete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
int count = jTable.getSelectedRow();
if(count == -1){
JOptionPane.showMessageDialog(null, "请点击上面的商品信息进行删除", "提示", JOptionPane.CANCEL_OPTION);
}else{
int in = JOptionPane.showConfirmDialog(null, "确定要删除吗?", "提示", JOptionPane.YES_NO_OPTION);
if(in==0){
((DefaultTableModel)jTable.getModel()).removeRow(count);
int rowCount = ((DefaultTableModel)jTable.getModel()).getRowCount();
NumberFormat nf = NumberFormat.getInstance();
nf.setMaximumFractionDigits(2);
//�����ܼ���
// Integer in3 = new Integer(rowCount);
jLabelNumShow.setText(((Integer)rowCount).toString()+"件");
//�����ܽ��
float f = 0;
for(int i=0;i<rowCount; i++){
Float f1 = (Float)((DefaultTableModel)jTable.getModel()).getValueAt(i, 7);
f += f1;
}
if(nf.format(f).equals("0")){
jLabelSumShow.setText("0.00");
}else{
jLabelSumShow.setText(nf.format(f)+" 元");
}
}
}
}
});
}
return jButtonDelete;
} /**
* This method initializes jButtonExit
*
* @return javax.swing.JButton
*/
private JButton getJButtonExit() {
if (jButtonExit == null) {
jButtonExit = new JButton();
jButtonExit.setBounds(new Rectangle(711, 636, 69, 42));
jButtonExit.setBackground(Color.gray);
jButtonExit.setFont(new Font("\u5fae\u8f6f\u96c5\u9ed1", Font.BOLD, 12));
jButtonExit.setText("退出");
jButtonExit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
dispose();
}
});
}
return jButtonExit;
}
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(e.getSource()==jButtonPay){
jRadioButtonCommon.setSelected(true);// 交易后返回普通用户
JDialogDealingInfo_Pay jDialogDealingInfo_Pay = new JDialogDealingInfo_Pay(this);
}
}
}