顯示具有 POS系統 標籤的文章。顯示所有文章

2012年7月8日星期日

[NetBean][Java] Load mysql-connector-java-5.1.6.jar into BeanNet

Posted by Computer Newbie on 上午9:15 in Java, mysql, POS系統 / No comments

[NetBean][Java] Load mysql-connector-java-5.1.6.jar into BeanNet

[Purpose]

Java code connect with Mysql.

1. Download mysql-connector-java-5.1.6.jar from internet

Laod this file into NetBean.

Right click

Select java file

Then will see package into NetBean.

When save some data into Mysql will successfully.

[POS][Book menu][Latex] Book menu

Posted by Computer Newbie on 上午9:39 in book, latex, POS系統 / No comments

[POS][Book menu][Latex] Book menu

Install mysql

Install NetBean

Create Database

[POS] POS learning track

Posted by Computer Newbie on 晚上7:56 in 學習區, Java, mysql, POS系統, Ubuntu / No comments

Database :

Mysql teach:

[mysql] input data to database

JAVA tutor :

Java Teach :

Java Swing Tutorials

Java mysql :

A Java MySQL INSERT example (using Statement)

NetBeans :

[java] (16) List all data in jTable from database, Edit Cell and store it

Posted by Computer Newbie on 晚上8:13 in 學習區, Java, mysql, NetBean, POS系統 / No comments

class MyTableModel extends AbstractTableModel

{

//     import java.util.*;

       private ArrayList<String> colname;

       private ArrayList<ArrayList> data;

       public MyTableModel(ResultSet rs)

       {

          try{

             // 取得欄位數量

             ResultSetMetaData rm = rs.getMetaData();

             int cnum = rm.getColumnCount();

             colname = new ArrayList<String>(cnum);

             // 取得欄位名稱

             for(int i=2; i<=cnum; i++){

                colname.add(rm.getColumnName(i));

             }

             // 取得列

             data = new ArrayList<ArrayList>();



             while(rs.next()){



                ArrayList<String> rowdata = new ArrayList<String>();

                for(int i=2; i<=cnum; i++){

                   System.out.println("happy1 int i=2; i<=cnum; i++ ");

                   rowdata.add(rs.getObject(i).toString());

                }



                data.add(rowdata);

                System.out.println("afdafads");

                System.out.println(data);

             }

           }

           catch(Exception e){

              e.printStackTrace();

          }







       }



           /*

     * Don't need to implement this method unless your table's

     * editable.

     */

      // This one can edit the cell

       public boolean isCellEditable(int row, int col) {

        //Note that the data/cell address is constant,

        //no matter where the cell appears onscreen.

            return true;



       }

   public void setValueAt(Object value, int row, int col) {



            System.out.println(value.getClass());

            System.out.println("setValueAt Row is :" + row);

            System.out.println("setValueAt col is :" + col);

            System.out.println("setValueAt :" + value);

            // After edit cell can store the data into table

            ArrayList rowdata = (ArrayList)data.get(row);

            System.out.println((ArrayList)data.get(row));

            rowdata.set(col, value);

            System.out.println(rowdata.get(col));

        }



       public int getRowCount()

       {



          System.out.println("getRowCount() data.size :"+data.size());



          return data.size();

       }

       public int getColumnCount()

       {

          System.out.println("getColumnCount() colname.size :"+colname.size());

          return colname.size();

       }

       public Object getValueAt(int row, int column)

       {

          System.out.println("getValueAt");

          ArrayList rowdata = (ArrayList)data.get(row);





          System.out.println("rowdata :" + rowdata);

          return rowdata.get(column);

       }

       public String getColumnName(int column)

       {

          System.out.println("getColumnName");

          return (String) colname.get(column);

       }

   }



    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:

        Connection conn = null;

        String url = "jdbc:mysql://localhost:3306/sale?useUnicode=true&characterEncoding=big5";

        String user = "testuser";

        String password = "test623";

        try {

            conn = DriverManager.getConnection(url, user, password);

            Statement st = conn.createStatement();



//            String qry = "SELECT * FROM total_calc";

//            String qry = "SELECT * FROM total_calc";

              String qry = "SELECT * FROM tabaco_product order by Tabaco_order " ;

            ResultSet rs = st.executeQuery(qry);



                        if (rs.last()){

                   int i = rs.getRow();

                    System.out.println(i);





               System.out.println(rs.last());

               rs.first();



            }

            // put My TableModel(rs) into setModel

            data_jTable1.setModel(new MyTableModel(rs));



            rs.close();

            st.close();

            conn.close();



        } catch (SQLException ex) {

            System.out.println(ex.getMessage());

        }







    }

[java] How to use rs

Posted by Computer Newbie on 凌晨12:54 in 學習區, Java, NetBean, POS系統 / No comments

   if(rs.last()) {

   rowcount = rs.getRow();

   rs.first();

   }

Reference:

[Java] Creating JTable from Resultset

[java] (15) jComboBox connect to mysql

Posted by Computer Newbie on 下午2:29 in 學習區, Java, mysql, NetBean, POS系統 / No comments

public void jComboBox_connect_mysql (){



             Connection conn = null;

        String url = "jdbc:mysql://localhost:3306/sale?useUnicode=true&characterEncoding=big5";

        String user = "testuser";

        String password = "test623";

        try {

            conn = DriverManager.getConnection(url, user, password);

            Statement st = conn.createStatement();





            ResultSet rs = st.executeQuery( "SELECT * FROM tabaco_product " );



           try{

           while (rs.next()) {

                jComboBox1.addItem(rs.getString("Tabaco_name"));

           } // while

           }catch(ArrayIndexOutOfBoundsException e){}





            rs.close();





            st.close();

            conn.close();



        } catch (SQLException ex) {

            System.out.println(ex.getMessage());

        }







    }

[java] (14) Update the data of mysql with java code (NetBean )

Posted by Computer Newbie on 上午9:12 in 學習區, Java, mysql, NetBean, POS系統 / No comments

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

Connection conn = null;

PreparedStatement pstm = null;

String url = "jdbc:mysql://localhost:3306/sale?useUnicode=true&characterEncoding=big5";

String user = "testuser";

String password = "test623";

// Calendar date = Calendar.getInstance();

// SimpleDateFormat dateformatter = new SimpleDateFormat("yyyy-MM-dd");

try{

conn = DriverManager.getConnection(url, user, password);

Statement st = conn.createStatement();

for (int i=0 ;i
try {

String Shift_Data = Shift_jComboBox2.getSelectedItem().toString();

String Data_Year = Year_jComboBox2.getSelectedItem().toString();

String Data_Month = Month_jComboBox3.getSelectedItem().toString();

String Data_Day = Day_jComboBox4.getSelectedItem().toString();

String Date_Data = Data_Year +"-"+ Data_Month +"-"+ Data_Day;

String Goods_name_Data = jTable1.getValueAt(i,0).toString();

String Unit_price_Data = jTable1.getValueAt(i,1).toString();

String Stocks_DataC = jTable1.getValueAt(i,2).toString();

String Good_in_stock_DataD = jTable1.getValueAt(i,3).toString();

String Ship_DataE = jTable1.getValueAt(i,4).toString();

String Balance_DataF = jTable1.getValueAt(i,5).toString();

String Selling_goods_DataG = jTable1.getValueAt(i,6).toString();

String Subtotal_DataH = jTable1.getValueAt(i,7).toString();

String Space_reserve_DataI = jTable1.getValueAt(i,8).toString();

String query = "update total_calc set Stocks= ?, Good_in_stock= ?, Ship= ?, Balance= ?, Selling_goods= ?, Subtotal= ?, Space_reserve= ? where Date = ? and Shift = ? and Goods_name= ? " ;

//綠色是要變更的項目藍色是所選擇的項目選項越多越精準

// green color is the item which we want to change. Blue color is the item which we want green color //item to change. More condition is better. Between item and item use "and".

// System.out.println(Data);

pstm = conn.prepareStatement(query);

System.out.println(Date_Data);

pstm.setString(1,Stocks_DataC);//按照上面?的順序 (follow the question mark on the //above.)

pstm.setString(2,Good_in_stock_DataD);

pstm.setString(3,Ship_DataE);

pstm.setString(4,Balance_DataF);

pstm.setString(5,Selling_goods_DataG);

pstm.setString(6,Subtotal_DataH);

pstm.setString(7,Space_reserve_DataI);

pstm.setString(8, Date_Data );

pstm.setString(9,Shift_Data);

pstm.setString(10,Goods_name_Data);

System.out.println(Goods_name_Data);

System.out.println("happy");

pstm.executeUpdate();

}catch(NullPointerException e){

// jTable1.setValueAt(0, i, j);

// JOptionPane.showMessageDialog(null,("第"+ (i+1) + "行 \n 第"+ (j+1)+ "行 \n 沒有輸入資料" ) );

}

}

pstm.close();

st.close();

conn.close();

}catch (SQLException ex) {

System.out.println(ex.getMessage());

}

JOptionPane.showMessageDialog(null,("資料傳送到資料庫完成" ) );

}

[mysql] download from mysql website and install in windows

Posted by Computer Newbie on 下午6:26 in 學習區, mysql, NetBean, POS系統 / No comments

Mysql website

I download MySQL Community Server 5.5.15 from mysql website.

Install it.

Becare please click Big5 option when end-user connect to server won't cause any problem.

And then create one new user and password.

Create database and table

[java] build jar and become excutable file in windows

Posted by Computer Newbie on 上午11:15 in 學習區, Java, NetBean, POS系統 / No comments

tar dist folder. And copy this to windows any folder.
dist this folder include lib.

recompress this compressed file.

And download this file(jarfix 1.2.0) into dist fold.

And excute this file.

If computer don't have any java runtime program.
Will download from java website.

when finish install java runtime program.
Excute jarfix again.
XXX.jar become excutable file.

[java] (13) get data from database and put data into jTable

Posted by Computer Newbie on 晚上10:13 in 學習區, Java, mysql, NetBean, POS系統 / No comments

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:

        Connection conn = null;



        String url = "jdbc:mysql://localhost:3306/sale?useUnicode=true&characterEncoding=big5";

        String user = "testuser";

        String password = "test623";





        try{

           conn = DriverManager.getConnection(url, user, password);

           Statement st = conn.createStatement();





           String Data_Shift = jComboBox1.getSelectedItem().toString();

           String Data_Year = Year_jComboBox2.getSelectedItem().toString();

           String Data_Month = Month_jComboBox3.getSelectedItem().toString();

           String Data_Day   = Day_jComboBox4.getSelectedItem().toString();

//    ResultSet rs = st.executeQuery( "SELECT Balance FROM total_calc where Shift= '早班' and Date= '2011_08_07' "); 要注意裡面有有點 ‘ ’

// ResultSet rs     rs前面要有ResultSet 整行才算完整

           ResultSet rs = st.executeQuery( "SELECT Balance FROM total_calc where Shift ='"+ Data_Shift +"' and Date ='"+ Data_Year   +"-"+ Data_Month +"-"+ Data_Day +"'" );







         // SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444';



           int li_row = 0;

           while (rs.next()) {

// 因為rs.getString(1) 1是因為只有抓 Balance 資料，所以放在第一列裡面

//如果是 select * from table 因為抓好幾列資料，所以要指定那一列要顯示

                jTable1.setValueAt(rs.getString(1),li_row,3);

                li_row ++;

           } // while









            rs.close();

            st.close();

            conn.close();

        }catch (SQLException ex) {

         System.out.println(ex.getMessage());

        }

    }

Reference:

Mastering the JTable

How do I determine the column type when querying a database?

[java] (12) select jCombBox and put selected item into database

Posted by Computer Newbie on 下午1:20 in 學習區, Java, NetBean, POS系統 / No comments

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:



        Connection conn = null;

        PreparedStatement pstm = null;



        String url = "jdbc:mysql://localhost:3306/sale?useUnicode=true&characterEncoding=big5";

        String user = "testuser";

        String password = "test623";



         Calendar date = Calendar.getInstance();

         SimpleDateFormat dateformatter = new SimpleDateFormat("yyyy-MM-dd");



        try{

           conn = DriverManager.getConnection(url, user, password);

           Statement st = conn.createStatement();





           for (int i=0 ;i<jTable1.getRowCount();i++){

//               for (int j=0 ; j<jTable1.getColumnCount();j++){

                    try {



                    String DataZ = jComboBox1.getSelectedItem().toString();    //讀取 jComboBox1所選擇的項目，然後放入資料庫中

                    String DataA = jTable1.getValueAt(i,0).toString();

                    String DataB = jTable1.getValueAt(i,1).toString();

                    String DataC = jTable1.getValueAt(i,2).toString();

                    String DataD = jTable1.getValueAt(i,3).toString();

                    String DataE = jTable1.getValueAt(i,4).toString();

                    String DataF = jTable1.getValueAt(i,5).toString();

                    String DataG = jTable1.getValueAt(i,6).toString();

                    String DataH = jTable1.getValueAt(i,7).toString();

                    String DataI = jTable1.getValueAt(i,8).toString();



//                     System.out.println(Data);

                     pstm = conn.prepareStatement("insert into total_calc "

                             + "(Shift,Goods_name,Unit_price,Stocks,Good_in_stock,Ship,Balance,Selling_goods,Subtotal,Space_reserve,Date) "

                             + "values (?,?,?,?,?,?,?,?,?,?,? )" );



                     pstm.setString(1,DataZ);

                     pstm.setString(2,DataA);

                     pstm.setString(3,DataB);

                     pstm.setString(4,DataC);

                     pstm.setString(5,DataD);

                     pstm.setString(6,DataE);

                     pstm.setString(7,DataF);

                     pstm.setString(8,DataG);

                     pstm.setString(9,DataH);

                     pstm.setString(10,DataI);

                     pstm.setString(11, dateformatter.format(date.getTime()) );



                     pstm.executeUpdate();



                    }catch(NullPointerException e){

//                      jTable1.setValueAt(0, i, j);

//                      JOptionPane.showMessageDialog(null,("第"+ (i+1) + "行 \n 第"+ (j+1)+ "行 \n 沒有輸入資料" ) );

                    }

//             }

           }





            pstm.close();

            st.close();

            conn.close();

        }catch (SQLException ex) {

         System.out.println(ex.getMessage());

        }





    }

Reference:

How to Use Combo Boxes

[java] (11) put data into database from jTable

Posted by Computer Newbie on 中午12:02 in 學習區, Java, NetBean, POS系統 / No comments

        //Sql 所吃的時間格式 String

         Calendar date = Calendar.getInstance();

         SimpleDateFormat dateformatter = new SimpleDateFormat("yyyy-MM-dd");



        try{

           conn = DriverManager.getConnection(url, user, password);

           Statement st = conn.createStatement();





           for (int i=0 ;i<jTable1.getRowCount();i++){

                    try {

                  // 抓出資料

                    String DataA = jTable1.getValueAt(i,0).toString();

                    String DataB = jTable1.getValueAt(i,1).toString();

                    String DataC = jTable1.getValueAt(i,2).toString();

                    String DataD = jTable1.getValueAt(i,3).toString();

                    String DataE = jTable1.getValueAt(i,4).toString();

                    String DataF = jTable1.getValueAt(i,5).toString();

                    String DataG = jTable1.getValueAt(i,6).toString();

                    String DataH = jTable1.getValueAt(i,7).toString();

                    String DataI = jTable1.getValueAt(i,8).toString();



                   // 所要放入的格式

                     pstm = conn.prepareStatement("insert into total_calc "

                             + "(Goods_name,Unit_price,Stocks,Good_in_stock,Ship,Balance,Selling_goods,Subtotal,Space_reserve,Date) "

                             + "values (?,?,?,?,?,?,?,?,?,? )" );

                     // 資料一個一個放入

                     pstm.setString(1,DataA);

                     pstm.setString(2,DataB);

                     pstm.setString(3,DataC);

                     pstm.setString(4,DataD);

                     pstm.setString(5,DataE);

                     pstm.setString(6,DataF);

                     pstm.setString(7,DataG);

                     pstm.setString(8,DataH);

                     pstm.setString(9,DataI);

                     pstm.setString(10, dateformatter.format(date.getTime()) );



                     pstm.executeUpdate(); //存完之後，馬上加到sql裡面



                    }catch(NullPointerException e){

//                      jTable1.setValueAt(0, i, j);

//                      JOptionPane.showMessageDialog(null,("第"+ (i+1) + "行 \n 第"+ (j+1)+ "行 \n 沒有輸入資料" ) );

                    }

           }





            pstm.close();

            st.close();

            conn.close();

        }catch (SQLException ex) {

         System.out.println(ex.getMessage());

        }





    }

Reference:

Calendar Example

[java] (11) Make execute file

Posted by Computer Newbie on 凌晨1:56 in 學習區, Java, NetBean, POS系統 / No comments

Make execute file :

NetBean --> Run --> Build project --> java -jar "/home/luke/test5/POS_system/dist/POS_system.jar"

Already have one file call POS_system.jar at /home/luke/test5/POS_system/dist/ .
go to /home/luke/test5/POS_system/dist/

And type
Change file type to execution file.
And execute it.

luke@luke-MS-6657:~/test5/POS_system/dist$ chmod 777 ./POS_system.jar
luke@luke-MS-6657:~/test5/POS_system/dist$ ./POS_system.jar

[java] (11) Create jTable input data and calcuate it

Posted by Computer Newbie on 凌晨1:39 in 學習區, Java, POS系統 / No comments

Thinking :

I put zero into all column.

And I calcuate the column which I need to do.

I will put the data into database. ( Next Step )

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

/*

* total_calc.java

*

* Created on 2011/8/6, 上午 01:44:15

*/

package pos_system;

import javax.swing.*;

/**

*

* @author luke

*/

public class total_calc extends javax.swing.JFrame {

    /** Creates new form total_calc */

    public total_calc() {

        initComponents();

    }

    /** 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.

     */

    @SuppressWarnings("unchecked")

    // <editor-fold defaultstate="collapsed" desc="Generated Code">

    private void initComponents() {

        jScrollPane1 = new javax.swing.JScrollPane();

        jTable1 = new javax.swing.JTable();

        jButton1 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jTable1.setModel(new javax.swing.table.DefaultTableModel(

            new Object [][] {

                {"先鋒", "20", null, null, null, null, null, null, null},

                {"摩爾", "2", null, null, null, null, null, null, null},

                {"硬白長壽", "5", null, null, null, null, null, null, null},

                {"寶島長支", "1", null, null, null, null, null, null, null},

                {"1379號", "2", null, null, null, null, null, null, null},

                {"藍長610", "3", null, null, null, null, null, null, null},

                {"藍星", null, null, null, null, null, null, null, null},

                {"萬寶555", null, null, null, null, null, null, null, null},

                {"BOSS", null, null, null, null, null, null, null, null},

                {"七星", null, null, null, null, null, null, null, null},

                {"峰", null, null, null, null, null, null, null, null},

                {"黑白豆", null, null, null, null, null, null, null, null},

                {"維珍百樂", null, null, null, null, null, null, null, null},

                {"金鹿", null, null, null, null, null, null, null, null},

                {"寶馬", null, null, null, null, null, null, null, null},

                {"登喜兒", null, null, null, null, null, null, null, null},

                {"", null, null, null, null, null, null, null, null},

                {"蠻牛", null, null, null, null, null, null, null, null},

                {"啤酒", null, null, null, null, null, null, null, null},

                {"綠茶", null, null, null, null, null, null, null, null},

                {"蘆荀汁", null, null, null, null, null, null, null, null},

                {"舒跑", null, null, null, null, null, null, null, null},

                {"海尼根", null, null, null, null, null, null, null, null},

                {"可樂", null, null, null, null, null, null, null, null},

                {"麥仔茶", null, null, null, null, null, null, null, null},

                {"咖啡", null, null, null, null, null, null, null, null},

                {"椰奶", null, null, null, null, null, null, null, null},

                {"西打", null, null, null, null, null, null, null, null},

                {"八寶粥", null, null, null, null, null, null, null, null},

                {"烏龍茶", null, null, null, null, null, null, null, null},

                {"沙士", null, null, null, null, null, null, null, null},

                {"果汁", null, null, null, null, null, null, null, null},

                {"大水", null, null, null, null, null, null, null, null},

                {"小水", null, null, null, null, null, null, null, null},

                {"仙草冬瓜", null, null, null, null, null, null, null, null},

                {"汽水", null, null, null, null, null, null, null, null},

                {"康貝特", null, null, null, null, null, null, null, null},

                {"奧利多", null, null, null, null, null, null, null, null},

                {"大保", null, null, null, null, null, null, null, null},

                {"小保", null, null, null, null, null, null, null, null}

            },

            new String [] {

                "貨名", "單價", "庫存", "上存貨", "進貨", "結存", "銷貨", "小計", "備註"

            }

        ) {

            Class[] types = new Class [] {

                java.lang.String.class, java.lang.String.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class, java.lang.Integer.class

            };

            public Class getColumnClass(int columnIndex) {

                return types [columnIndex];

            }

        });

        jScrollPane1.setViewportView(jTable1);

        jTable1.getColumnModel().getColumn(1).setPreferredWidth(15);

        jButton1.setText("計算");

        jButton1.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                jButton1ActionPerformed(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()

                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

                    .addGroup(layout.createSequentialGroup()

                        .addContainerGap()

                        .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 1284, Short.MAX_VALUE))

                    .addGroup(layout.createSequentialGroup()

                        .addGap(22, 22, 22)

                        .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)))

                .addContainerGap())

        );

        layout.setVerticalGroup(

            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

            .addGroup(layout.createSequentialGroup()

                .addContainerGap()

                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 577, javax.swing.GroupLayout.PREFERRED_SIZE)

                .addGap(18, 18, 18)

                .addComponent(jButton1)

                .addContainerGap(26, Short.MAX_VALUE))

        );

        pack();

    }// </editor-fold>







public boolean tabaco_vaildCheck(){



       for(int i=0;i<jTable1.getRowCount();i++){

           for(int j=0;j<( jTable1.getColumnCount()-1 );j++){

             try {

               String om = jTable1.getValueAt(i, j).toString();

               System.out.println("\n Value ="+om+ " and Length :"+om.length());

             }catch(NullPointerException e){

               jTable1.setValueAt(0, i, j);

              // JOptionPane.showMessageDialog(null,("第"+ (i+1) + "行 \n 第"+ (j+1)+ "行 \n 沒有輸入資料" ) );

             }



          }

       }

       return true;

}

public void How_many_sell(){

        for(int i=0;i<jTable1.getRowCount();i++){

            String DataA = jTable1.getValueAt(i, 2).toString();

            String DataB = jTable1.getValueAt(i, 3).toString();

            String DataC = jTable1.getValueAt(i, 4).toString();

            String DataD = jTable1.getValueAt(i, 5).toString();

            int How_many_sell = Integer.parseInt(String.valueOf(DataA)) + Integer.parseInt(String.valueOf(DataB))+Integer.parseInt(String.valueOf(DataC))-Integer.parseInt(String.valueOf(DataD));

            jTable1.setValueAt(How_many_sell , i, 6);

        }

}

public void Money(){

        for(int i=0;i<jTable1.getRowCount();i++){

            String DataA = jTable1.getValueAt(i, 1).toString();

            String DataD = jTable1.getValueAt(i, 6).toString();

            int Money = Integer.parseInt(String.valueOf(DataA)) * Integer.parseInt(String.valueOf(DataD));

            jTable1.setValueAt(Money , i, 7);

        }

}







    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:

// if ( vaildCheck() ){

//                   JOptionPane.showMessageDialog(null,"field empty");

// }

     tabaco_vaildCheck();

     How_many_sell();

     Money();



    }

    /**

     * @param args the command line arguments

     */

    public static void main(String args[]) {

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new total_calc().setVisible(true);

            }

        });

    }

    // Variables declaration - do not modify

    private javax.swing.JButton jButton1;

    private javax.swing.JScrollPane jScrollPane1;

    private javax.swing.JTable jTable1;

    // End of variables declaration

}

[java] (10) JTable : Resolve jTable1.getValueAt(i,j) get null become NullPointerException

Posted by Computer Newbie on 凌晨1:02 in 學習區, Java, POS系統 / No comments

JTable : Resolve jTable1.getValueAt(i,j) get null become NullPointerException

一開始都解不出來，後來我想到可以用 try .. catch這個方法來解決。

public boolean vaildCheck(){



       for(int i=0;i<3;i++){

           for(int j=0;j<3;j++){

             try {

               String om = jTable1.getValueAt(i, j).toString();

               System.out.println("\n Value ="+om+ " and Length :"+om.length());

               if(om.trim().length()==0){

                 return false;

               }

             }catch(NullPointerException e){

               jTable1.setValueAt(0, i, j);

             }



          }

       }

       return true;

}

Reference :

JTable Cell Empty Validation: How to check or know JTable cell is empty or not and also avoid null or space entry validation in JTable cell before saving JTable data in Database

[java] (9) version 1 input data (Easy one)

Posted by Computer Newbie on 上午10:37 in 學習區, Java, POS系統 / No comments

version 1 :

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

/*

* test4.java

*

* Created on 2011/8/4, 下午 10:11:23

*/

package pos_system;

import java.sql.*;

/**

*

* @author luke

*/

public class tabaco_calc extends javax.swing.JFrame {

/** Creates new form test4 */

public tabaco_calc() {

initComponents();

}

/** 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.

*/

@SuppressWarnings("unchecked")

//

private void initComponents() {

jPanel1 = new javax.swing.JPanel();

jLabel1 = new javax.swing.JLabel();

jTextField1 = new javax.swing.JTextField();

jTextField2 = new javax.swing.JTextField();

jLabel2 = new javax.swing.JLabel();

jLabel3 = new javax.swing.JLabel();

jPanel2 = new javax.swing.JPanel();

jLabel4 = new javax.swing.JLabel();

jTextField3 = new javax.swing.JTextField();

jTextField4 = new javax.swing.JTextField();

jLabel5 = new javax.swing.JLabel();

jLabel6 = new javax.swing.JLabel();

jPanel3 = new javax.swing.JPanel();

jLabel7 = new javax.swing.JLabel();

jTextField5 = new javax.swing.JTextField();

jTextField6 = new javax.swing.JTextField();

jLabel8 = new javax.swing.JLabel();

jLabel9 = new javax.swing.JLabel();

jPanel4 = new javax.swing.JPanel();

jLabel10 = new javax.swing.JLabel();

jTextField7 = new javax.swing.JTextField();

jTextField8 = new javax.swing.JTextField();

jLabel11 = new javax.swing.JLabel();

jLabel12 = new javax.swing.JLabel();

jPanel5 = new javax.swing.JPanel();

jLabel13 = new javax.swing.JLabel();

jTextField9 = new javax.swing.JTextField();

jTextField10 = new javax.swing.JTextField();

jLabel14 = new javax.swing.JLabel();

jLabel15 = new javax.swing.JLabel();

jPanel6 = new javax.swing.JPanel();

jLabel16 = new javax.swing.JLabel();

jTextField11 = new javax.swing.JTextField();

jTextField12 = new javax.swing.JTextField();

jLabel17 = new javax.swing.JLabel();

jLabel18 = new javax.swing.JLabel();

jPanel7 = new javax.swing.JPanel();

jLabel19 = new javax.swing.JLabel();

jTextField13 = new javax.swing.JTextField();

jTextField14 = new javax.swing.JTextField();

jLabel20 = new javax.swing.JLabel();

jLabel21 = new javax.swing.JLabel();

jPanel8 = new javax.swing.JPanel();

jLabel22 = new javax.swing.JLabel();

jTextField15 = new javax.swing.JTextField();

jTextField16 = new javax.swing.JTextField();

jLabel23 = new javax.swing.JLabel();

jLabel24 = new javax.swing.JLabel();

jPanel9 = new javax.swing.JPanel();

jLabel25 = new javax.swing.JLabel();

jTextField17 = new javax.swing.JTextField();

jTextField18 = new javax.swing.JTextField();

jLabel26 = new javax.swing.JLabel();

jLabel27 = new javax.swing.JLabel();

jPanel10 = new javax.swing.JPanel();

jLabel28 = new javax.swing.JLabel();

jTextField19 = new javax.swing.JTextField();

jTextField20 = new javax.swing.JTextField();

jLabel29 = new javax.swing.JLabel();

jLabel30 = new javax.swing.JLabel();

jPanel11 = new javax.swing.JPanel();

jLabel31 = new javax.swing.JLabel();

jTextField21 = new javax.swing.JTextField();

jTextField22 = new javax.swing.JTextField();

jLabel32 = new javax.swing.JLabel();

jLabel33 = new javax.swing.JLabel();

jPanel12 = new javax.swing.JPanel();

jLabel34 = new javax.swing.JLabel();

jTextField23 = new javax.swing.JTextField();

jTextField24 = new javax.swing.JTextField();

jLabel35 = new javax.swing.JLabel();

jLabel36 = new javax.swing.JLabel();

jPanel13 = new javax.swing.JPanel();

jLabel37 = new javax.swing.JLabel();

jTextField25 = new javax.swing.JTextField();

jTextField26 = new javax.swing.JTextField();

jLabel38 = new javax.swing.JLabel();

jLabel39 = new javax.swing.JLabel();

jPanel14 = new javax.swing.JPanel();

jLabel40 = new javax.swing.JLabel();

jTextField27 = new javax.swing.JTextField();

jTextField28 = new javax.swing.JTextField();

jLabel41 = new javax.swing.JLabel();

jLabel42 = new javax.swing.JLabel();

jPanel15 = new javax.swing.JPanel();

jLabel43 = new javax.swing.JLabel();

jLabel44 = new javax.swing.JLabel();

jLabel45 = new javax.swing.JLabel();

jLabel46 = new javax.swing.JLabel();

jLabel47 = new javax.swing.JLabel();

jLabel48 = new javax.swing.JLabel();

jButton1 = new javax.swing.JButton();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jPanel1.setBackground(new java.awt.Color(240, 223, 205));

jLabel1.setText("先鋒");

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);

jPanel1.setLayout(jPanel1Layout);

jPanel1Layout.setHorizontalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel1)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 127, Short.MAX_VALUE)

.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(28, 28, 28)

.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel1Layout.setVerticalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel3, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel2.setBackground(new java.awt.Color(240, 223, 205));

jLabel4.setText("摩爾");

javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);

jPanel2.setLayout(jPanel2Layout);

jPanel2Layout.setHorizontalGroup(

jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel4)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 127, Short.MAX_VALUE)

.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel2Layout.setVerticalGroup(

jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel2Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel5, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel6, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel3.setBackground(new java.awt.Color(240, 223, 205));

jLabel7.setText("硬白長壽");

javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);

jPanel3.setLayout(jPanel3Layout);

jPanel3Layout.setHorizontalGroup(

jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel3Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel7)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 95, Short.MAX_VALUE)

.addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(29, 29, 29)

.addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel3Layout.setVerticalGroup(

jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel3Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel8, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel9, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel7, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel4.setBackground(new java.awt.Color(240, 223, 205));

jLabel10.setText("寶島長支");

javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);

jPanel4.setLayout(jPanel4Layout);

jPanel4Layout.setHorizontalGroup(

jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel4Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel10)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 98, Short.MAX_VALUE)

.addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(33, 33, 33)

.addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(31, 31, 31)

.addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addContainerGap())

);

jPanel4Layout.setVerticalGroup(

jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel4Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel11, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel12, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel10, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel5.setBackground(new java.awt.Color(240, 223, 205));

jLabel13.setText("1379號");

javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);

jPanel5.setLayout(jPanel5Layout);

jPanel5Layout.setHorizontalGroup(

jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel5Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel13)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 110, Short.MAX_VALUE)

.addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField10, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel15, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel5Layout.setVerticalGroup(

jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel5Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel14, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel15, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel13, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel6.setBackground(new java.awt.Color(240, 223, 205));

jLabel16.setText("藍長610");

javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);

jPanel6.setLayout(jPanel6Layout);

jPanel6Layout.setHorizontalGroup(

jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel6Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel16)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 102, Short.MAX_VALUE)

.addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(28, 28, 28)

.addComponent(jLabel17, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel18, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel6Layout.setVerticalGroup(

jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel6Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel17, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel18, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel16, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel7.setBackground(new java.awt.Color(240, 223, 205));

jLabel19.setText("藍星");

javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);

jPanel7.setLayout(jPanel7Layout);

jPanel7Layout.setHorizontalGroup(

jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel7Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel19)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 127, Short.MAX_VALUE)

.addComponent(jTextField13, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField14, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel20, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel21, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel7Layout.setVerticalGroup(

jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel7Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel20, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel21, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel19, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField14, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField13, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel8.setBackground(new java.awt.Color(240, 223, 205));

jLabel22.setText("萬寶555");

javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);

jPanel8.setLayout(jPanel8Layout);

jPanel8Layout.setHorizontalGroup(

jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel8Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel22)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 102, Short.MAX_VALUE)

.addComponent(jTextField15, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField16, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(28, 28, 28)

.addComponent(jLabel23, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel24, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel8Layout.setVerticalGroup(

jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel8Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel23, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel24, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel22, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField16, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField15, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel9.setBackground(new java.awt.Color(240, 223, 205));

jLabel25.setText("Boss");

javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);

jPanel9.setLayout(jPanel9Layout);

jPanel9Layout.setHorizontalGroup(

jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel9Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel25)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 124, Short.MAX_VALUE)

.addComponent(jTextField17, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField18, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel26, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel27, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel9Layout.setVerticalGroup(

jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel9Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel26, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel27, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel25, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField18, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField17, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel10.setBackground(new java.awt.Color(240, 223, 205));

jLabel28.setText("七星");

javax.swing.GroupLayout jPanel10Layout = new javax.swing.GroupLayout(jPanel10);

jPanel10.setLayout(jPanel10Layout);

jPanel10Layout.setHorizontalGroup(

jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel10Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel28)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 127, Short.MAX_VALUE)

.addComponent(jTextField19, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField20, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel29, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel30, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel10Layout.setVerticalGroup(

jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel10Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel29, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel30, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel28, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField20, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField19, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel11.setBackground(new java.awt.Color(240, 223, 205));

jLabel31.setText("峰");

javax.swing.GroupLayout jPanel11Layout = new javax.swing.GroupLayout(jPanel11);

jPanel11.setLayout(jPanel11Layout);

jPanel11Layout.setHorizontalGroup(

jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel11Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel31)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 142, Short.MAX_VALUE)

.addComponent(jTextField21, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField22, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel32, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel33, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel11Layout.setVerticalGroup(

jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel11Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel32, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel33, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel31, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField22, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField21, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel12.setBackground(new java.awt.Color(240, 223, 205));

jLabel34.setText("黑白豆");

javax.swing.GroupLayout jPanel12Layout = new javax.swing.GroupLayout(jPanel12);

jPanel12.setLayout(jPanel12Layout);

jPanel12Layout.setHorizontalGroup(

jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel12Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel34)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 112, Short.MAX_VALUE)

.addComponent(jTextField23, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField24, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel35, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel36, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel12Layout.setVerticalGroup(

jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel12Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel35, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel36, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel34, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField24, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField23, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel13.setBackground(new java.awt.Color(240, 223, 205));

jLabel37.setText("維珍百樂");

javax.swing.GroupLayout jPanel13Layout = new javax.swing.GroupLayout(jPanel13);

jPanel13.setLayout(jPanel13Layout);

jPanel13Layout.setHorizontalGroup(

jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel13Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel37)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 95, Short.MAX_VALUE)

.addComponent(jTextField25, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField26, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(29, 29, 29)

.addComponent(jLabel38, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel39, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel13Layout.setVerticalGroup(

jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel13Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel38, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel39, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel37, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField26, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField25, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel14.setBackground(new java.awt.Color(240, 223, 205));

jLabel40.setText("金鹿");

javax.swing.GroupLayout jPanel14Layout = new javax.swing.GroupLayout(jPanel14);

jPanel14.setLayout(jPanel14Layout);

jPanel14Layout.setHorizontalGroup(

jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel14Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel40)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 127, Short.MAX_VALUE)

.addComponent(jTextField27, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addComponent(jTextField28, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(27, 27, 27)

.addComponent(jLabel41, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(26, 26, 26)

.addComponent(jLabel42, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(24, 24, 24))

);

jPanel14Layout.setVerticalGroup(

jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel14Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel41, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addComponent(jLabel42, javax.swing.GroupLayout.DEFAULT_SIZE, 28, Short.MAX_VALUE)

.addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel40, javax.swing.GroupLayout.DEFAULT_SIZE, 25, Short.MAX_VALUE)

.addComponent(jTextField28, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jTextField27, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel15.setBackground(new java.awt.Color(240, 223, 205));

jLabel43.setText("貨名");

jLabel44.setText("存貨");

jLabel45.setText("銷貨");

jLabel46.setText("結存");

jLabel47.setText("小計");

jLabel48.setText("單價");

javax.swing.GroupLayout jPanel15Layout = new javax.swing.GroupLayout(jPanel15);

jPanel15.setLayout(jPanel15Layout);

jPanel15Layout.setHorizontalGroup(

jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel15Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel43)

.addGap(71, 71, 71)

.addComponent(jLabel48)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 26, Short.MAX_VALUE)

.addComponent(jLabel44)

.addGap(34, 34, 34)

.addComponent(jLabel46)

.addGap(41, 41, 41)

.addComponent(jLabel45)

.addGap(27, 27, 27)

.addComponent(jLabel47)

.addGap(34, 34, 34))

);

jPanel15Layout.setVerticalGroup(

jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel15Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel43, javax.swing.GroupLayout.DEFAULT_SIZE, 22, Short.MAX_VALUE)

.addComponent(jLabel45, javax.swing.GroupLayout.DEFAULT_SIZE, 22, Short.MAX_VALUE)

.addComponent(jLabel47, javax.swing.GroupLayout.DEFAULT_SIZE, 22, Short.MAX_VALUE)

.addComponent(jLabel46, javax.swing.GroupLayout.DEFAULT_SIZE, 22, Short.MAX_VALUE)

.addComponent(jLabel44, javax.swing.GroupLayout.DEFAULT_SIZE, 22, Short.MAX_VALUE)

.addComponent(jLabel48, javax.swing.GroupLayout.DEFAULT_SIZE, 22, Short.MAX_VALUE))

.addContainerGap())

);

jButton1.setText("傳送");

jButton1.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jButton1ActionPerformed(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()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jPanel6, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel12, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel11, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel10, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel13, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel14, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel4, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addGap(97, 97, 97)

.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE)

.addContainerGap())

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(jPanel1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

.addGap(182, 182, 182))))

);

layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGap(545, 545, 545)

.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addComponent(jPanel15, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 46, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel11, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel13, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jPanel14, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

pack();

}//

public boolean determine_input_or_not( String Data1, String Data2){

if ( ( Data1.length() == 0 || Data1 == null ) || ( Data2.length() == 0 || Data2 == null ) ){

return false;

}

return true;

}

public int calculate_amount(String Data1,String Data2){

int sale_amount = ( Integer.parseInt(Data1) - Integer.parseInt(Data2) );

return sale_amount;

}

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

String Data1=jTextField1.getText();

String Data2=jTextField2.getText();

String Data3=jTextField3.getText();

String Data4=jTextField4.getText();

String Data5=jTextField5.getText();

String Data6=jTextField6.getText();

String Data7=jTextField7.getText();

String Data8=jTextField8.getText();

String Data9=jTextField9.getText();

String Data10=jTextField10.getText();

String Data11=jTextField11.getText();

String Data12=jTextField12.getText();

String Data13=jTextField13.getText();

String Data14=jTextField14.getText();

String Data15=jTextField15.getText();

String Data16=jTextField16.getText();

String Data17=jTextField17.getText();

String Data18=jTextField18.getText();

String Data19=jTextField19.getText();

String Data20=jTextField20.getText();

String Data21=jTextField21.getText();

String Data22=jTextField22.getText();

String Data23=jTextField23.getText();

String Data24=jTextField24.getText();

String Data25=jTextField25.getText();

String Data26=jTextField26.getText();

String Data27=jTextField27.getText();

String Data28=jTextField28.getText();

Get_price price= new Get_price();

// ＊＊＊＊＊＊＊＊＊ n = 1 先鋒＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if ( determine_input_or_not(Data1,Data2)){

// 銷貨計算

int sale_amount1 = calculate_amount(Data1,Data2);

jLabel2.setText(String.valueOf(sale_amount1));

// 把計算出小計

int Price1 = Integer.valueOf(price.Get_price(jLabel1.getText()));

jLabel3.setText(String.valueOf(sale_amount1 * Price1));

}

// ＊＊＊＊＊＊＊＊＊ n = 2 摩爾＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if( determine_input_or_not(Data3,Data4)){

// 銷貨計算

int sale_amount2 = calculate_amount(Data3,Data4);

jLabel5.setText(String.valueOf(sale_amount2));

// 把計算出小計

int Price2 = Integer.valueOf(price.Get_price(jLabel4.getText()));

jLabel6.setText(String.valueOf(sale_amount2 * Price2));

}

// ＊＊＊＊＊＊＊＊＊ n = 3 硬白長壽＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data5,Data6)){

// 銷貨計算

int sale_amount3 = calculate_amount(Data5,Data6);

jLabel8.setText(String.valueOf(sale_amount3));

// 把計算出小計

int Price3 = Integer.valueOf(price.Get_price(jLabel7.getText()));

jLabel9.setText(String.valueOf(sale_amount3 * Price3));

}

// ＊＊＊＊＊＊＊＊＊ n = 4 寶島長支＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data7,Data8)){

// 銷貨計算

int sale_amount4 = calculate_amount(Data7,Data8);

jLabel11.setText(String.valueOf(sale_amount4));

// 把計算出小計

int Price4 = Integer.valueOf(price.Get_price(jLabel10.getText()));

jLabel12.setText(String.valueOf(sale_amount4 * Price4));

}

// ＊＊＊＊＊＊＊＊＊ n = 5 1379號＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data9,Data10)){

// 銷貨計算

int sale_amount5 = calculate_amount(Data9,Data10);

jLabel14.setText(String.valueOf(sale_amount5));

// 把計算出小計

int Price5 = Integer.valueOf(price.Get_price(jLabel13.getText()));

jLabel15.setText(String.valueOf(sale_amount5 * Price5));

}

// ＊＊＊＊＊＊＊＊＊ n = 6 藍長610＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data11,Data12)){

// 銷貨計算

int sale_amount6 = calculate_amount(Data11,Data12);

jLabel17.setText(String.valueOf(sale_amount6));

// 把計算出小計

int Price6 = Integer.valueOf(price.Get_price(jLabel16.getText()));

jLabel18.setText(String.valueOf(sale_amount6 * Price6));

}

// ＊＊＊＊＊＊＊＊＊ n = 7 藍星＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data13,Data14)){

// 銷貨計算

int sale_amount7 = calculate_amount(Data13,Data14);

jLabel20.setText(String.valueOf(sale_amount7));

// 把計算出小計

int Price7 = Integer.valueOf(price.Get_price(jLabel19.getText()));

jLabel21.setText(String.valueOf(sale_amount7 * Price7));

}

// ＊＊＊＊＊＊＊＊＊ n = 8 萬寶555＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data15,Data16)){

// 銷貨計算

int sale_amount8 = calculate_amount(Data15,Data16);

jLabel23.setText(String.valueOf(sale_amount8));

// 把計算出小計

int Price8 = Integer.valueOf(price.Get_price(jLabel22.getText()));

jLabel24.setText(String.valueOf(sale_amount8 * Price8));

}

// ＊＊＊＊＊＊＊＊＊ n = 9 Boss＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data17,Data18)){

// 銷貨計算

int sale_amount9 = calculate_amount(Data17,Data18);

jLabel26.setText(String.valueOf(sale_amount9));

// 把計算出小計

int Price9 = Integer.valueOf(price.Get_price(jLabel25.getText()));

jLabel27.setText(String.valueOf(sale_amount9 * Price9));

}

// ＊＊＊＊＊＊＊＊＊ n = 10 七星＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data19,Data20)){

// 銷貨計算

int sale_amount10 = calculate_amount(Data19,Data20);

jLabel29.setText(String.valueOf(sale_amount10));

// 把計算出小計

int Price10 = Integer.valueOf(price.Get_price(jLabel28.getText()));

jLabel30.setText(String.valueOf(sale_amount10 * Price10));

}

// ＊＊＊＊＊＊＊＊＊ n = 11 峰＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data21,Data22)){

// 銷貨計算

int sale_amount11 = calculate_amount(Data21,Data22);

jLabel32.setText(String.valueOf(sale_amount11));

// 把計算出小計

int Price11 = Integer.valueOf(price.Get_price(jLabel31.getText()));

jLabel33.setText(String.valueOf(sale_amount11 * Price11));

}

// ＊＊＊＊＊＊＊＊＊ n = 12 黑白豆＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data23,Data24)){

// 銷貨計算

int sale_amount12 = calculate_amount(Data23,Data24);

jLabel35.setText(String.valueOf(sale_amount12));

// 把計算出小計

int Price12 = Integer.valueOf(price.Get_price(jLabel34.getText()));

jLabel36.setText(String.valueOf(sale_amount12 * Price12));

}

// ＊＊＊＊＊＊＊＊＊ n = 13 維珍百樂＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data25,Data26)){

// 銷貨計算

int sale_amount13 = calculate_amount(Data25,Data26);

jLabel38.setText(String.valueOf(sale_amount13));

// 把計算出小計

int Price13 = Integer.valueOf(price.Get_price(jLabel37.getText()));

jLabel39.setText(String.valueOf(sale_amount13 * Price13));

}

// ＊＊＊＊＊＊＊＊＊ n = 14 金鹿＊＊＊＊＊＊＊＊＊

// 判斷有沒有輸入

if(determine_input_or_not(Data27,Data28)){

// 銷貨計算

int sale_amount14 = calculate_amount(Data27,Data28);

jLabel41.setText(String.valueOf(sale_amount14));

// 把計算出小計

int Price14 = Integer.valueOf(price.Get_price(jLabel40.getText()));

jLabel42.setText(String.valueOf(sale_amount14 * Price14));

}

}

/**

* @param args the command line arguments

*/

public static void main(String args[]) {

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new tabaco_calc().setVisible(true);

}

});

}

// Variables declaration - do not modify

private javax.swing.JButton jButton1;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel10;

private javax.swing.JLabel jLabel11;

private javax.swing.JLabel jLabel12;

private javax.swing.JLabel jLabel13;

private javax.swing.JLabel jLabel14;

private javax.swing.JLabel jLabel15;

private javax.swing.JLabel jLabel16;

private javax.swing.JLabel jLabel17;

private javax.swing.JLabel jLabel18;

private javax.swing.JLabel jLabel19;

private javax.swing.JLabel jLabel2;

private javax.swing.JLabel jLabel20;

private javax.swing.JLabel jLabel21;

private javax.swing.JLabel jLabel22;

private javax.swing.JLabel jLabel23;

private javax.swing.JLabel jLabel24;

private javax.swing.JLabel jLabel25;

private javax.swing.JLabel jLabel26;

private javax.swing.JLabel jLabel27;

private javax.swing.JLabel jLabel28;

private javax.swing.JLabel jLabel29;

private javax.swing.JLabel jLabel3;

private javax.swing.JLabel jLabel30;

private javax.swing.JLabel jLabel31;

private javax.swing.JLabel jLabel32;

private javax.swing.JLabel jLabel33;

private javax.swing.JLabel jLabel34;

private javax.swing.JLabel jLabel35;

private javax.swing.JLabel jLabel36;

private javax.swing.JLabel jLabel37;

private javax.swing.JLabel jLabel38;

private javax.swing.JLabel jLabel39;

private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel40;

private javax.swing.JLabel jLabel41;

private javax.swing.JLabel jLabel42;

private javax.swing.JLabel jLabel43;

private javax.swing.JLabel jLabel44;

private javax.swing.JLabel jLabel45;

private javax.swing.JLabel jLabel46;

private javax.swing.JLabel jLabel47;

private javax.swing.JLabel jLabel48;

private javax.swing.JLabel jLabel5;

private javax.swing.JLabel jLabel6;

private javax.swing.JLabel jLabel7;

private javax.swing.JLabel jLabel8;

private javax.swing.JLabel jLabel9;

private javax.swing.JPanel jPanel1;

private javax.swing.JPanel jPanel10;

private javax.swing.JPanel jPanel11;

private javax.swing.JPanel jPanel12;

private javax.swing.JPanel jPanel13;

private javax.swing.JPanel jPanel14;

private javax.swing.JPanel jPanel15;

private javax.swing.JPanel jPanel2;

private javax.swing.JPanel jPanel3;

private javax.swing.JPanel jPanel4;

private javax.swing.JPanel jPanel5;

private javax.swing.JPanel jPanel6;

private javax.swing.JPanel jPanel7;

private javax.swing.JPanel jPanel8;

private javax.swing.JPanel jPanel9;

private javax.swing.JTextField jTextField1;

private javax.swing.JTextField jTextField10;

private javax.swing.JTextField jTextField11;

private javax.swing.JTextField jTextField12;

private javax.swing.JTextField jTextField13;

private javax.swing.JTextField jTextField14;

private javax.swing.JTextField jTextField15;

private javax.swing.JTextField jTextField16;

private javax.swing.JTextField jTextField17;

private javax.swing.JTextField jTextField18;

private javax.swing.JTextField jTextField19;

private javax.swing.JTextField jTextField2;

private javax.swing.JTextField jTextField20;

private javax.swing.JTextField jTextField21;

private javax.swing.JTextField jTextField22;

private javax.swing.JTextField jTextField23;

private javax.swing.JTextField jTextField24;

private javax.swing.JTextField jTextField25;

private javax.swing.JTextField jTextField26;

private javax.swing.JTextField jTextField27;

private javax.swing.JTextField jTextField28;

private javax.swing.JTextField jTextField3;

private javax.swing.JTextField jTextField4;

private javax.swing.JTextField jTextField5;

private javax.swing.JTextField jTextField6;

private javax.swing.JTextField jTextField7;

private javax.swing.JTextField jTextField8;

private javax.swing.JTextField jTextField9;

// End of variables declaration

}

訂閱：文章 (Atom)

Notepad

2012年7月8日星期日

[NetBean][Java] Load mysql-connector-java-5.1.6.jar into BeanNet

2012年7月7日星期六

[POS][Book menu][Latex] Book menu

2012年6月19日星期二

[POS] POS learning track

2011年8月11日星期四

[java] (16) List all data in jTable from database, Edit Cell and store it

2011年8月9日星期二

[java] How to use rs

2011年8月8日星期一

[java] (15) jComboBox connect to mysql

[java] (14) Update the data of mysql with java code (NetBean )

2011年8月7日星期日

[mysql] download from mysql website and install in windows

[java] build jar and become excutable file in windows

2011年8月6日星期六

[java] (13) get data from database and put data into jTable

[java] (12) select jCombBox and put selected item into database

[java] (11) put data into database from jTable

[java] (11) Make execute file

[java] (11) Create jTable input data and calcuate it

[java] (10) JTable : Resolve jTable1.getValueAt(i,j) get null become NullPointerException

2011年8月5日星期五

[java] (9) version 1 input data (Easy one)

總網頁瀏覽量

Counter

Categories

2012年7月8日 星期日

2012年7月7日 星期六

2012年6月19日 星期二

2011年8月11日 星期四

2011年8月9日 星期二

2011年8月8日 星期一

2011年8月7日 星期日

2011年8月6日 星期六

2011年8月5日 星期五

總網頁瀏覽量

Counter

Categories

2012年7月8日星期日

2012年7月7日星期六

2012年6月19日星期二

2011年8月11日星期四

2011年8月9日星期二

2011年8月8日星期一

2011年8月7日星期日

2011年8月6日星期六

2011年8月5日星期五