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);
}
}
