Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package jdbc;
- import java.awt.BorderLayout;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.ArrayList;
- import javax.swing.JPanel;
- import javax.swing.JScrollPane;
- import javax.swing.JTable;
- import javax.swing.table.DefaultTableModel;
- class student {
- private int id;
- private String fname;
- private String lname;
- private String mname;
- private int age;
- private String gender;
- private String address;
- private String level;
- private String section;
- private int phone;
- public student(int Stu_ID,String Stu_Fname,String Stu_Lname,String Stu_Mname,int Stu_Age,String Stu_gender,String Stu_Address,String Stu_Level,String Stu_Section,int Stu_phone) {
- this.id = Stu_ID;
- this.fname = Stu_Fname;
- this.lname = Stu_Lname;
- this.mname = Stu_Mname;
- this.age = Stu_Age;
- this.gender = Stu_gender;
- this.address = Stu_Address;
- this.level = Stu_Level;
- this.section = Stu_Section;
- this.phone = Stu_phone;
- }
- public int getStu_ID()
- {
- return id;
- }
- public String getStu_Fname()
- {
- return fname;
- }
- public String getStu_Lname()
- {
- return lname;
- }
- public String getStu_Mname()
- {
- return mname;
- }
- public int getStu_Age()
- {
- return age;
- }
- public String getStu_gender()
- {
- return gender;
- }
- public String getStu_Address()
- {
- return address;
- }
- public String getStu_Level()
- {
- return level;
- }
- public String getStu_Section()
- {
- return section;
- }
- public int getStu_phone()
- {
- return phone;
- }
- static ArrayList<student> getstudent(){
- ArrayList<student> users = new ArrayList<student>();
- Statement st;
- ResultSet rs;
- student u;
- try {
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
- st = con.createStatement();
- rs = st.executeQuery("SELECT * FROM users");
- while(rs.next()){
- u = new student(
- rs.getInt("Stu_ID"),
- rs.getString("Stu_Fname"),
- rs.getString("Stu_Lname"),
- rs.getString("Stu_Mname"),
- rs.getInt("Stu_Age"),
- rs.getString("Stu_gender"),
- rs.getString("Stu_Address"),
- rs.getString("Stu_Level"),
- rs.getString("Stu_Section"),
- rs.getInt("Stu_phone")
- );
- users.add(u);
- }
- } catch (SQLException ex) {
- }
- return users;
- }
- public static void main(String[] args){
- /*
- now we are gonna create and populate a jtable from the arraylist who is populated from mysql database
- */
- JTable table = new JTable();
- DefaultTableModel model = new DefaultTableModel();
- Object[] columnsName = new Object[10];
- columnsName[0] = "Id";
- columnsName[1] = "Fname";
- columnsName[2] = "Lname";
- columnsName[3] = "Mname";
- columnsName[4] = "Age";
- columnsName[5] = "Gender";
- columnsName[6] = "Address";
- columnsName[7] = "Level";
- columnsName[8] = "Section";
- columnsName[9] = "Phone";
- model.setColumnIdentifiers(columnsName);
- Object[] rowData = new Object[10];
- for(int i = 0; i < getstudent().size(); i++){
- rowData[0] = getstudent().get(i).getStu_ID();
- rowData[1] = getstudent().get(i).getStu_Fname();
- rowData[2] = getstudent().get(i).getStu_Lname();
- rowData[3] = getstudent().get(i).getStu_Mname();
- rowData[4] = getstudent().get(i).getStu_Age();
- rowData[5] = getstudent().get(i).getStu_gender();
- rowData[6] = getstudent().get(i).getStu_Address();
- rowData[7] = getstudent().get(i).getStu_Level();
- rowData[8] = getstudent().get(i).getStu_Section();
- rowData[9] = getstudent().get(i).getStu_phone();
- model.addRow(rowData);
- }
- table.setModel(model);
- // System.out.println(getUsers().size());
- Work window = new Work();
- JPanel panel = new JPanel();
- panel.setLayout(new BorderLayout());
- JScrollPane pane = new JScrollPane(table);
- panel.add(pane,BorderLayout.CENTER);
- window.setContentPane(panel);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement