java mysql data show jtable with arraylist

package test;

import java.sql.Connection;
import java.sql.DriverManager;


public class Mysqlconnect {
	String host="localhost";
	String username= "root";
	String password ="usbw";
	String dbname="test";
	String driverclassname= "com.mysql.jdbc.Driver" ;
	
	public Connection connection(){
		
		Connection connection=null;
		try {
			Class.forName(driverclassname);
			connection=DriverManager.getConnection("jdbc:mysql://localhost/"+dbname, username, password);
		} catch (Exception e) {
			// TODO: handle exception
		}
		return connection;
	}

}

package test;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;




class User{
	
	String id;
	String name;
	public User(String id, String name) {
		this.id = id;
		this.name = name;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}	
}



public class Check {
public static void main(String[] args) {
	
	
	JFrame jFrame= new JFrame();
	jFrame.setSize(800, 800);
	
	Mysqlconnect cMysqlconnect= new Mysqlconnect();
	Connection conn=cMysqlconnect.connection();
	
	if (conn!=null) {
		System.out.println("connected");
		ArrayList<User> userdata=new ArrayList<User>();

		DefaultTableModel defaultTableModel = null;
	
		try {
			String query="select * from user_accounts";
			Statement statement;
			statement = conn.createStatement();
			ResultSet resultSet =statement.executeQuery(query);
			String colname[]={"id","user"};
			defaultTableModel=new DefaultTableModel(colname,0);
			
			while (resultSet.next()) {
				userdata.add(new User(resultSet.getString("id"), resultSet.getString("user_id")));
				
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
		for (int i = 0; i < userdata.size(); i++) {
			Object[] objects={userdata.get(i).id,userdata.get(i).name};
			defaultTableModel.addRow(objects);
		}
		JTable jTable=new JTable(defaultTableModel);
		jTable.setBounds(100, 50, 400, 600);
		JScrollPane jScrollPane=new JScrollPane(jTable);
		jScrollPane.setBounds(100, 100, 600, 600);
		jFrame.add(jScrollPane);
		
	}
	
	jFrame.setVisible(true);
}
}

Published by

Unknown's avatar

Nusrat Faria

I Am A Web Developer And A Android Developer. This Is My Personal Blog So Noted My Work For Helping People .

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.