Develop a program to insert employee record in to the database Employee.

import java.sql.*;

class Emp

{

public static void main(String args[])

{

try

{

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

System.out.println("Driver Loaded");

String URL="jdbc:odbc:Emp";

Connection con=DriverManager.getConnection(URL);

System.out.println("Connection Created");

Statement s=con.createStatement();

System.out.println("Statement Created");

String str="insert into Employee values('PQR',111,30000)";

int i=s.executeUpdate(str);

System.out.println("Row inserted: "+i);

con.close();

}

catch (Exception e)

{

System.out.println("Error::"+e);

}

}

}

No comments:

Post a Comment