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