Saturday, 13 February 2016

tybca slip 105

import java.sql.*;
import java.io.*;

class slip105
{


 Connection con;

 PreparedStatement ps;

 ResultSet rs;


  
   slip105()
 {

 try
{


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


  con=DriverManager.getConnection("jdbc:odbc:emp");



 ps=con.prepareStatement("select * from empTable");


    rs=ps.executeQuery();


   while(rs.next())
 {


System.out.print("\n \n "+rs.getString("eno")+"\t"+rs.getString("ename")+"\t"+rs.getString("dname")+"\t"+rs.getString("sal"));




 }

  ps=con.prepareStatement("delete from empTable where eno=?");




 BufferedReader br=new BufferedReader(new InputStreamReader(System.in));



 System.out.print("\n enter the id to Delete the Record=");

 int n=Integer.parseInt(br.readLine());


 ps.setInt(1,n);


     int i=ps.executeUpdate();



  if(i==1)
 {



 ps=con.prepareStatement("select * from empTable");


    rs=ps.executeQuery();


   while(rs.next())
 {


System.out.print("\n \n "+rs.getString("eno")+"\t"+rs.getString("ename")+"\t"+rs.getString("dname")+"\t"+rs.getString("sal"));




 }



 System.out.print("\n Record is Deleted Succefully\n \n");


  }
 else
 {

 System.out.print("\n Record is Deleted UN-Succefully\n\n");


  }



   }


 catch(Exception e)
 {


 System.out.print(e.getMessage());

 }

 }



 public static void main(String args[])
 {
 slip105 ob=new slip105();



 }

 }


 

0 comments:

Post a Comment

Note: only a member of this blog may post a comment.

 
Copyright © 2013. BloggerSpice.com - All Rights Reserved
Author: MohammadFazle Rabbi | Powered by: Blogger
Designed by: Blogger Spice
^