/*Write a JDBC Program in java to delet the names of Employees starting with ‘a' character. */
import java.sql.*;
public class DeleteEmployeeRecord
{
static Connection cn;
static Statement st;
public static void main(String args[])
{
try
{
ResultSet rs,rs1;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn=DriverManager.getConnection("jdbc:odbc:emp1");
st=cn.createStatement();
System.out.println("\nBefore deleting records are :");
rs=st.executeQuery("select * from employees");
System.out.println("\nEno \t Ename\t Sal \n");
while(rs.next())
{
System.out.println(rs.getInt("eno")+"\t"+rs.getString("ename")+"\t"+rs.getInt("sal"));
}
st.executeUpdate("delete from employees where ename like 'a%'");
System.out.println("\nAfter deleting records are :");
rs1=st.executeQuery("select * from employees");
System.out.println("\nEno \t Ename\t Sal \n");
while(rs1.next())
{
System.out.println(rs1.getInt("eno")+"\t"+rs1.getString("ename")+"\t"+rs1.getInt("sal"));
}
cn.close();
}catch(Exception e)
{
System.out.println(e);
}
}
}
import java.sql.*;
public class DeleteEmployeeRecord
{
static Connection cn;
static Statement st;
public static void main(String args[])
{
try
{
ResultSet rs,rs1;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn=DriverManager.getConnection("jdbc:odbc:emp1");
st=cn.createStatement();
System.out.println("\nBefore deleting records are :");
rs=st.executeQuery("select * from employees");
System.out.println("\nEno \t Ename\t Sal \n");
while(rs.next())
{
System.out.println(rs.getInt("eno")+"\t"+rs.getString("ename")+"\t"+rs.getInt("sal"));
}
st.executeUpdate("delete from employees where ename like 'a%'");
System.out.println("\nAfter deleting records are :");
rs1=st.executeQuery("select * from employees");
System.out.println("\nEno \t Ename\t Sal \n");
while(rs1.next())
{
System.out.println(rs1.getInt("eno")+"\t"+rs1.getString("ename")+"\t"+rs1.getInt("sal"));
}
cn.close();
}catch(Exception e)
{
System.out.println(e);
}
}
}
No comments:
Post a Comment