Author: Nusrat Faria

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

package sap;



import java.awt.ScrollPane;
import java.util.ArrayList;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;




public class GetData  {
	
	public static void main(String[] args) throws Exception {
		
	
		
		// Main Container
		JFrame containerFrame = new JFrame();
		containerFrame.setSize(800, 600);
		ArrayList<String> coloumnnameArrayList= new ArrayList<>();
		ArrayList<String[]> rowdatArrayList = new ArrayList<>();
	
		// populate coloumn data
		coloumnnameArrayList.add("code");
		coloumnnameArrayList.add("description");
		coloumnnameArrayList.add("stock");
		
		// populate row data
		for (int i = 0; i < 100; i++) {
			rowdatArrayList.add( new String [] {"123","ashik","45"});
		}
		TableModel tableModel = new DefaultTableModel(rowdatArrayList.toArray(new Object [][] {}),coloumnnameArrayList.toArray());
		JTable jTable = new JTable(tableModel);
		JScrollPane scrollPane = new JScrollPane(jTable);
		
		containerFrame.add(scrollPane);
		
		containerFrame.setVisible(true);
		
		
	}
	

}

package sap;

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

public class SapLogin {
	  // Your IP address must be static otherwise this will not work. You //can get your Ip address
	//From <em>Network and security in Windows.</em>
	    String ip = "192.168.10.101";
	    // This is default if you are using JTDS driver.
	    String classs = "net.sourceforge.jtds.jdbc.Driver";
	    // Name Of your database.
	    String db = "NEWFIZTEST";
	    // Userame and password are required for security.
	   // so Go to sql server and add username and password for your database.
	    String un = "sa";
	    String password = "fizsa7,";

	    public Connection CONN() {
	       
	        Connection conn = null;
	        String ConnURL;
	        try {
	            Class.forName(classs);
	            ConnURL = "jdbc:jtds:sqlserver://" + ip + ";"
	                    + "databaseName=" + db + ";user=" + un + ";password="
	                    + password + ";";
	            conn = DriverManager.getConnection(ConnURL);
	        }
	        catch (SQLException se)
	        {
	        
	        }
	        catch (ClassNotFoundException e) {
	        }
	        catch (Exception e) {
	        }
	        return conn;
	    }
public static void main(String[] args) {
	
	 SapLogin sapLogin = new SapLogin();
	 Connection connection = sapLogin.CONN();
	 if (connection!=null) {
		System.out.println("connected");
	}
}

}

package sap;

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

public class MysqlConnect {
	  // Your IP address must be static otherwise this will not work. You //can get your Ip address
	//From <em>Network and security in Windows.</em>
	    String ip = "192.168.10.44";
	    // This is default if you are using JTDS driver.
	    String classs = "com.mysql.jdbc.Driver";
	    // Name Of your database.
	    String db = "NEWFIZTEST";
	    // Userame and password are required for security.
	   // so Go to sql server and add username and password for your database.
	    String un = "root";
	    String password = "usbw";
	    
	    public Connection conn() {
	        Connection conn = null;
	        String ConnURL;
	        try {
	            Class.forName(classs);
	            ConnURL = "jdbc:jtds:sqlserver://" + ip + ";"
	                    + "databaseName=" + db + ";user=" + un + ";password="
	                    + password + ";";
	            conn = DriverManager.getConnection(ConnURL);
	        }
	        catch (SQLException se)
	        {
	        
	        }
	        catch (ClassNotFoundException e) {
	        }
	        catch (Exception e) {
	        }
	        return conn;
	    }
	    
	    public static void main(String[] args) {
	    	
	   	 SapLogin sapLogin = new SapLogin();
	   	 Connection connection = sapLogin.CONN();
	   	 if (connection!=null) {
	   		System.out.println("connected");
	   	}
	   }
}