JDBC EXAMPLE FOR INSERT

PROGRAM:

import java.sql.*;

import java.io.*;

class EmpInsert

{

public static void main(String a[])throws Exception

{

try

{

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection c=DriverManager.getConnection("jdbc:odbc:Empsn");

            Statement s=c.createStatement();

            String str1 = " insert into emp values (" 103 + ",\'" + " William " + ",\'"+

             ",\'" + " clerk " +  8000+   1500+   500 +   2000  +"\')" ;

            int count=s.executeUpdate(str1);

            if(count==1)

            System.out.println("Record inserted!!");

            else

            System.out.println("Record not inserted");

String str="select * from emp";

            ResultSet r=s.executeQuery(str);

                        while(r.next())

                        {

                        int id=r.getInt(1);

                        String name=r.getString(2);

                        String de=r.getString(3);

                        double sal=r.getDouble(4);

                        double hr=r.getDouble(5);

                        double da=r.getDouble(6);

                        double loan=r.getDouble(7);

                        double n=(sal+hr+da)-loan;

                        System.out.println("Empid:" +id);

                        System.out.println("Name: "+name);

                        System.out.println("Designation: "+de);

                        System.out.println("Salary: "+n);

                        }

}

catch(Exception e)

{

System.out.println(e);

}

       }  

}

TABLE CREATION IN MS-ACCESS

Id	Name	De	Sal	Hr	Da	Loan
101	Martin	manager	10000	5000	750	750
102	Smith	asstmanager	7500	2500	1000	1000

OUTPUT:

Record inserted!!

Empid: 101

Name: Martin

Designation: Manager

Salary: 15000

Empid: 102

Name: Smith

Designation: AsstManager

Salary: 10000

Empid: 103

Name: William

Designation: clerk

Salary: 8000