JDBC -SQLSERVER 2012 Connection

//set path="C:\Program Files\Java\jdk1.7.0_25\bin"
// to compile use javac Conection,java and to run use java -classpath .;sqljdbc41.jar Conection
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Conection
{
    public static void main(String a[]) throws ClassNotFoundException, SQLException
    {
        try
        {



           // String url = "jdbc:sqlserver://localhost:1433//CSCLAP\\SQLEXPRESS;;;databaseName=employee"; 
           // Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");  

String url = "jdbc:sqlserver://CSCLAP\\SQLEXPRESS;databaseName=employee;integratedSecurity=true";// this is for  windows authendication-SQLERVER 2012
// copy  the file sqljdbc_auth.dll stored at  D:\sqljdbc_6.2\enu\auth\x64  into "C:\Program Files\Java\jdk1.7.0_25\bin" */
// HElp  Message
//If it provides the following error
//WARNING: Failed to load the sqljdbc_auth.dll cause : C:\Program Files\Java\jdk1.7.0_25\bin\sqljdbc_auth.dll: Can't load AMD 64-bit .dll on a IA 32-bit platform
//Exceptioncom.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:dc8585c2-c404-44fe-85a0-5d0fcdb2de97
// copy  the file sqljdbc_auth.dll stored at  D:\sqljdbc_6.2\enu\auth\x86 into "C:\Program Files\Java\jdk1.7.0_25\bin" */


//String url="jdbc:sqlserver://CSCLAP;instanceName=SQLEXPRESS;user=sa;password=sql;DatabaseName=employee";
// this is for sqlserver authendication

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url);
  
      
        System.out.println("test");
        Statement sta = conn.createStatement();
        String Sql = "select * from emp";
        ResultSet rs = sta.executeQuery(Sql);
        while (rs.next()) {
            System.out.println(rs.getString("eno"));
        }
    }


catch(Exception e)
{
System.out.println("Exception"+e);
}
           }
}

JDBC ORACLE Connection

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//SQL> select name from v$database;

//NAME
//---------
//XE

//SQL> SELECT sys_context('USERENV', 'SID') FROM DUAL;

//SYS_CONTEXT('USERENV','SID')
//--------------------------------------------------------------------------------
//94
/*
D:\>javac SampleDatabaseConn.java

D:\>java -classpath .;ojdbc6.jar SampleDatabaseConn
100
101 */
//java -cp E:\ojdbc6.jar;E:\ SampleDatabaseConn
//Just goto Command prompt
//tnsping XE
//Set Oracle SID C:>set oracle_sid=ORCL
//Now run Net start command. C:>net start oracleserviceORCL
class SampleDatabaseConn
{
    public static void main (String args []) throws Exception
    {  

  
    
Class.forName ("oracle.jdbc.driver.OracleDriver");
//Driver myDriver = new oracle.jdbc.driver.OracleDriver();
  // DriverManager.registerDriver( myDriver );

//Connection conn = DriverManager.getConnection("jdbc:oracle:oci:@94", "system", "system");

 
     Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@csclap:1521:XE", "system", "system");
                            // @//machineName:port/SID,   userid,  password
        try {
        Statement stmt = conn.createStatement();
        try {
        ResultSet rset = stmt.executeQuery("select * from emp");
        try {
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        } finally {
            try { rset.close(); } catch (Exception ignore) {}
        }
        } finally {
            try { stmt.close(); } catch (Exception ignore) {}
        }
        } finally {
            try { conn.close(); } catch (Exception ignore) {}
        }
    }
}

Java database - Records Navigation

import java.io.*;
import java.sql.*;
//set path="C:\Program Files\Java\jdk1.7.0_51\bin"
public class dbnavigation{

    static void marker(){
        for (int i=1;i<=50;i++)
        {
            System.out.print("*");
        }
        System.out.println();
    }
    public static void main(String[] args) throws IOException
{
        Connection con;
        Statement st,st1;
        BufferedReader bin;
        ResultSet rs,rs1;
        ResultSetMetaData rm,rm1;
        String euname, epwd, eno;
        int ch, nocol,eid,i,nocol1,ch1;
 try
{
       
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con = DriverManager.getConnection("jdbc:odbc:chanstaff");
        //st = con.createStatement();
            bin = new BufferedReader(new InputStreamReader(System.in));
            st1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);//,ResultSet.CONCUR_READ_ONLY);
rs1 = st1.executeQuery("select * from stafftab");
rm1 = rs1.getMetaData();
nocol1= rm1.getColumnCount();
do
{
System.out.println("NAVIGATION AMONG RECORDS \n");
System.out.println(" F. Move First Record");
System.out.println(" L. Move Last Record");
System.out.println(" P. Move Previous Record");
System.out.println(" N. Move Next Record");
System.out.println(" S. Move Specific Record");
System.out.println(" n. Move  single Next Record");
System.out.println(" p. Move single Previous Record");

System.out.println("PRESS F/L/P/N/S/p/n");
String  nach =bin.readLine();
switch(nach)
{
case "F":
System.out.println("FIRSRT RECORD");
rs1.first();
euname=rs1.getString("uname");
epwd=rs1.getString("pwd");
//eno=Integer.parseInt(rs1.getString("ID"));
int  eidd=Integer.parseInt(rs1.getString("ID"));
System.out.println("ID \t\t\t\t"+eidd);
System.out.println("User Name :\t"+euname);
System.out.println("Password:\t\t"+epwd);
rs1.beforeFirst();
break;
case "L":System.out.println("LAST RECORD");
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
               System.out.println();
              
               rs1.last();
              
               for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println(); rs1.afterLast();break;
case "N":
System.out.println("NEXT RECORD");
while(rs1.next())
{
euname=rs1.getString("uname");
epwd=rs1.getString("pwd");
int  eiddd=Integer.parseInt(rs1.getString("ID"));
System.out.println("ID \t\t\t\t"+eiddd);
System.out.println("User Name :\t"+euname);
System.out.println("Password:\t\t"+epwd);

               System.out.println();
}
break;
case "p":
try
{
rs1.previous();
int rno1=rs1.getRow();
System.out.println(rno1);
//rs1.absolute(rno-1);
System.out.println("Single PREVIOUS RECORD");
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println();
}
catch(Exception e)
        {
            System.out.println("Reason : This is the First Record :");
rs1.first(); for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println(); 
    
}
break;
case "n" :
try
{
rs1.next();
int rno=rs1.getRow();
rs1.absolute(rno);
System.out.println(rno);
System.out.println("Single NEXT RECORD");
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println();
}
catch(Exception e)
        {
            System.out.println("Reason : This is the Last Record :");
rs1.last();  
        for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println();     
}
break;
default:
{ System.out.println(" Wrong input : PRESS F/L/P/N/S/p/n");
con.close();
bin.close();   
System.exit(0);break;
}
}
   

System.out.println(" do you want to Continue navigation ? press no 0 to exit");
                ch1 = Integer.parseInt(bin.readLine());
            }while(ch1>0);
}   
catch (Exception e)
{
System.out.println(" Exception fired");
}
  

}
}


   

JAVA Database Maintenance Code


1.
import java.io.*;
import java.sql.*;
public class dbpg1 {

    static void marker(){
        for (int i=1;i<=50;i++)
        {
            System.out.print("*");
        }
        System.out.println();
    }
    public static void main(String[] args) {
        Connection con;
        Statement st;
        BufferedReader bin;
        ResultSet rs;
        ResultSetMetaData rm;
        String euname, epwd, eno,salary;
        int ch, nocol,eid;

        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:chanstaff");
            st = con.createStatement();
            bin = new BufferedReader(new InputStreamReader(System.in));
            while(true){
                System.out.println("Choose Option");
                System.out.println("1. Select");
                System.out.println("2. Insert");
                System.out.println("3. Update");
                System.out.println("4. Delete");
                System.out.println("0. Exit");
                ch = Integer.parseInt(bin.readLine());
           if (ch==1)

           {
               rs = st.executeQuery("select * from stafftab");
               rm = rs.getMetaData();
               nocol= rm.getColumnCount();
               marker();
               for(int i=1; i<=nocol; i++)
               {
                   System.out.print(rm.getColumnName(i)+"\t\t");
               }
               System.out.println();
               marker();
               while(rs.next())
               {
               for(int i=1; i<=nocol; i++)
               {
                   System.out.print(rs.getString(i) +"\t\t");
               }
               System.out.println();
               }
                marker();

           }
           else if(ch==2)
                   {
            do
            {
                System.out.println("Enter user name");
                euname = bin.readLine();
                System.out.println("Enter pasword");
                epwd = bin.readLine();
                //System.out.println("Enter Salary");
                //salary = bin.readLine();
               st.execute("insert into stafftab (uname,pwd)values('"+euname+"','"+epwd+"')");
//st.execute("insert into stafftab (uname,pwd)values('"+euname+"','"+epwd+"')");
                System.out.println("1 Record inserted");
                System.out.println("Continue ? [y/n]");
                eno = bin.readLine();
            }while(eno.equalsIgnoreCase("y"));
         }
           else if(ch==3)
           {
    System.out.println("Enter id for the record to do edit");
               eid  = Integer.parseInt(bin.readLine());
               System.out.println("Enter uname to change :");
               euname = bin.readLine();
               System.out.println("Enter new password");
               epwd = bin.readLine();
              
             //  st.execute("update stafftab set uname='"+euname+"',pwd='"+epwd+"'where ID="+eid);
st.execute("update stafftab set uname='"+euname+"',pwd='"+epwd+"'where ID="+eid+"");
               System.out.println("1 Record Updated");
con.setAutoCommit(true);

           }
           else if(ch==4)
           {
               System.out.println("Enter uname. to Delete :");
               euname = bin.readLine();
               //st.execute("delete from stafftab where uname='bala'");
 st.execute("delete from stafftab where uname='"+euname+"'");
con.setAutoCommit(true);
               System.out.println("Record Deleted");
           }
           else if(ch==0)
           {
            bin.close();
            con.close();
            System.exit(0);
           }
        }
        }
        catch(Exception e)
        {
            System.out.println("Error :"+e.getMessage());
        }
    }
}
---------------------------------------------------------------------------------------------------------------------------

Java Exception, Multi-threading Programs