Advertisement
Guest User

Untitled

a guest
Jun 6th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.59 KB | None | 0 0
  1.                                    
  2.        try{
  3.        Object header[]={"No Faktur","No Barang","Quantity","Nama Pembelian","Tanggal","Total Harga"};
  4.        DefaultTableModel data = new DefaultTableModel(null,header);
  5.        TableL.setModel(data);
  6.        String nofak = faktur.getText();
  7.      
  8.        try{
  9.        Class.forName("com.mysql.jdbc.Driver").newInstance();
  10.        Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/Penjualan?zeroDateTimeBehavior=convertToNull","root","");
  11.        Statement state= conn.createStatement();
  12.        Statement statement= conn.createStatement();
  13.        String sql="SELECT * FROM jualan where Nofak="+"'"+nofak+"'";
  14.        ResultSet rs = state.executeQuery(sql);
  15.        while(rs.next()){
  16.        
  17.        int test1 = rs.getInt(1);
  18.        String test2 = rs.getString(2);
  19.        int test3 = rs.getInt(3);
  20.        String test4 = rs.getString(4);
  21.        String test5 = rs.getString(5);
  22.        String ss="SELECT * FROM datamaster where NoBarang="+"'"+test2+"'";
  23.        ResultSet rs2 = statement.executeQuery(ss);
  24.  
  25.        int data4 = 0;
  26.        while(rs2.next()){
  27.        data4=rs2.getInt(4);
  28.        }
  29.        data4 = data4*test3;
  30.        String test[]={String.valueOf(test1),test2,String.valueOf(test3),test4,test5,String.valueOf(data4)};
  31.        data.addRow(test);
  32.      
  33.        }
  34.        }
  35.        catch (Exception e)
  36.        {
  37.            JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
  38.        }
  39.        }
  40.        catch (Exception e)
  41.        {
  42.            JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
  43.        }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement