belajar post coding for netbeans

Membuat database 

database: project123
table : userinfo
atribut :
pumpidinteger (11)
datedate
pressureinteger (11)
temperatureinteger (11)
volumeFlowinteger (11)
rotationalSpeedinteger (11)

javaconnect.java

import java.sql.*;
import javax.swing.*;
public class javaconnect {
    Connection conn = null;
    public static Connection ConnecrDb(){
        try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/project123","root","");
            //JOptionPane.showMessageDialog(null, "Koneksi Sukses ...!!");
            return conn;
        }catch(Exception e){
            JOptionPane.showMessageDialog(null, e);
            return null;
        }
    }
 
}

Form Userinfo_frame.java


Userinfo_frame.java

import java.sql.*;
import javax.swing.*;
import net.proteanit.sql.DbUtils;

public class Userinfo_frame extends javax.swing.JFrame {
    Connection conn = null;
    ResultSet rs = null;
    PreparedStatement pst = null;
 
    public Userinfo_frame() {
        initComponents();
        conn = javaconnect.ConnecrDb();
        Update_table();
    }
 
    public void close(){
        WindowEvent winClosingEvent = new WindowEvent(this, WindowEvent.WINDOW_CLOSING);
        Toolkit.getDefaultToolkit().getSystemEventQueue().postEvent(winClosingEvent);
    }
 
    public void Update_table(){
        try{
            String sql = "select * from userinfo";
            pst = conn.prepareStatement(sql);
            rs = pst.executeQuery();
            Table_User.setModel(DbUtils.resultSetToTableModel(rs));
        }catch(Exception e){
            JOptionPane.showMessageDialog(null, e);
        }finally{
            try{
                rs.close();
                pst.close();
            }catch(Exception e){
             
            }
        }
    }

disini saya menggunakan library MYSQL JDBC Driver  itu ada langsung di paket javanya
dan kita menambahkan jar rs2xml download http://sitinurhanifa4.blogspot.co.id/2017/01/download-free-rs2xml.html

Hasilnya

yang belum jelas boleh bertanya di komentar, insyaAllah dijawab...!

Komentar

Postingan populer dari blog ini

download free rs2xml

Artikel tentang LINQ

Makalah Etika Politik Berdasarkan Pancasila