Category: Java Code Snippet

JAVA JDBC CRUD EXAMPLE

To Connect With SERVER SEE Configuration Tutorial Link

package mypack; 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
 
public class Myconnection {
      // 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) {
             
        ArrayList <String>cardnameArrayList= new ArrayList<>();
         Myconnection sapLogin = new Myconnection();
         Connection connection = sapLogin.conn();
         if (connection!=null) {
            System.out.println("connected");
            
            
            // For Select Data From Database
            try {
             Statement statement = connection.createStatement();
             ResultSet resultSet = statement.executeQuery("SELECT TOP 10 cardname FROM OQUT");
             while (resultSet.next()) {
              cardnameArrayList.add(resultSet.getString("cardname")); // column index from 1 if you use coloumn name then
             }
             System.out.println(cardnameArrayList);
            } catch (SQLException e) {
             // TODO Auto-generated catch block
             e.printStackTrace();
            }
        	
          	// Insert Data 
          	try {
          	 Statement insertStatement = connection.createStatement();
          	 // Return A Integer Value as row number if (insert>0)
          	 int insert = insertStatement.executeUpdate("INSERT INTO OQUT (DocNum,DocEntry,cardname) VALUES (147845,474774,'74587')");
          	 System.out.println("Data Inserted SuccessFull");
          	} catch (SQLException e) {
          	 e.printStackTrace();
          	}
        	
        	// For Delete  Data
			try {
				 Statement deleteStatement;
				 deleteStatement = connection.createStatement();
				 int delete = deleteStatement.executeUpdate("DELETE  FROM OQUT WHERE DocNum='14542'");
				 if (delete > 0) {
				  System.out.println("Data Deleted Successfull");
				 }
				} catch (SQLException e) {
				 // TODO Auto-generated catch block
				 e.printStackTrace();
				}
        	
			// For Update Data 
			try {
				Statement updateStatement = connection.createStatement();
				int update= updateStatement.executeUpdate("UPDATE OQUT SET CARDNAME='1451245' WHERE DOCNUM='147845'");
				if (update>0) {
					System.out.println("Data Updated Successfull");
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			
        	
        	
        }
       }
}

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

Array List Data To Jtable Java Sewing

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

}

Java Connect With Sql Server,mysql server Using JDTS JDBC DRIVER and mysql-connector-java-8.0.17 driver

I Am Using Eclips Ide.

  1. After Create A Project First Download Jdts.jar Library. link
  2. Second Create A libs Folder And Past library File under libs folder .
  3. From Project->Propities->JavaBuildpath->Library And Add Jar File Now Jar File Is Ready For Work
  4. Follow The Code 
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");
	}
}

}

Connect With Mysql Server Code

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

Java Jlabel Logo Set From ResourceFolder With Resize

contentPane = new JPanel();
		contentPane.setBackground(new Color(230, 230, 250));
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);
		ImageIcon logo  = new ImageIcon(getClass().getResource("res/logo.png"));
		Image logoImage = logo.getImage();
		Image newresizeableImage = logoImage.getScaledInstance(100, 100,java.awt.Image.SCALE_SMOOTH);
		logo = new ImageIcon(newresizeableImage)  ;
		JLabel label = new JLabel(logo);
		label.setBounds(10, 11, 52, 26);
		contentPane.add(label);