Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try{
- Object header[]={"No Faktur","No Barang","Quantity","Nama Pembelian","Tanggal","Total Harga"};
- DefaultTableModel data = new DefaultTableModel(null,header);
- TableL.setModel(data);
- String nofak = faktur.getText();
- try{
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/Penjualan?zeroDateTimeBehavior=convertToNull","root","");
- Statement state= conn.createStatement();
- Statement statement= conn.createStatement();
- String sql="SELECT * FROM jualan where Nofak="+"'"+nofak+"'";
- ResultSet rs = state.executeQuery(sql);
- while(rs.next()){
- int test1 = rs.getInt(1);
- String test2 = rs.getString(2);
- int test3 = rs.getInt(3);
- String test4 = rs.getString(4);
- String test5 = rs.getString(5);
- String ss="SELECT * FROM datamaster where NoBarang="+"'"+test2+"'";
- ResultSet rs2 = statement.executeQuery(ss);
- int data4 = 0;
- while(rs2.next()){
- data4=rs2.getInt(4);
- }
- data4 = data4*test3;
- String test[]={String.valueOf(test1),test2,String.valueOf(test3),test4,test5,String.valueOf(data4)};
- data.addRow(test);
- }
- }
- catch (Exception e)
- {
- JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
- }
- }
- catch (Exception e)
- {
- JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement