import java.io.*;
import java.sql.*;
class del
{
public static void main(String args[])
{
String n;
int x;
Connection k;
PreparedStatement pp;
try
{
n=args[0];
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
k=DriverManager.getConnection("jdbc:odbc:ucer","","");
pp=k.prepareStatement("delete from school where name=?");
pp.setString(1,n);
x=pp.executeUpdate();
if(x==1)
{
System.out.println("record has been deleted");
}
}
catch(Exception xx)
{
System.out.println("check data"+xx.getMessage());
}
}
}
import java.sql.*;
class del
{
public static void main(String args[])
{
String n;
int x;
Connection k;
PreparedStatement pp;
try
{
n=args[0];
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
k=DriverManager.getConnection("jdbc:odbc:ucer","","");
pp=k.prepareStatement("delete from school where name=?");
pp.setString(1,n);
x=pp.executeUpdate();
if(x==1)
{
System.out.println("record has been deleted");
}
}
catch(Exception xx)
{
System.out.println("check data"+xx.getMessage());
}
}
}
No comments:
Post a Comment