JAVA JDBC CRUD EXAMPLE

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