Sunday, 15 September 2013

JDBC CURD operatoin through Command Line Argument

JDBC CURD operatoin through Command Line Argument

i m trying to Curd operation through Command Line Argument here i assign
args[0] for operation(insert,delete ,update) args[1] for name args[2]
designation args[3] dob args[4] dob
package empcmd; import java.sql.*;
public class EmpCmd {
static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
static final String DB_URL="jdbc:mysql://localhost/sandeep";
static final String USER="root";
static final String PASS="root";
public static void main(String args[])throws ClassNotFoundException {
String name;
String desg;
int dob;
int age;
Connection con=null;
PreparedStatement ps=null;
try{
class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(DB_URL,USER,PASS);
char op;
int x=0;
op=args[0];
name=args[1];
desg=args[2];
dob=args[3];
age=args[4];
if(args[0]=insert||INSERT||Insert)
{
ps=con.prepareStatement("insert into sandeep
values(?,?,?,?)");
ps.setString(1,name);
ps.setString(2, desg);
ps.setString(3,dob);
ps.setString(4,age);
x=ps.executeUpdate();
}
else if (args[0]=update||Update||UPDATE)
{
ps=con.PrepareStatement("update sandeep set
name=?,desg=?,dob=?,age=?");
ps.setString(1,name);
ps.setString(2, desg);
ps.setString(3,dob);
ps.setString(4,age);
x=ps.executeUpdate();
}
else if (args[0]=delete||DELETE||Delete)
{
ps=con.PrepareStatement("delete from sandeep where name=?);"
ps.SetString(1,name);
x=ps.executeUpdate();
}
}
}catch(SQLException se){
se.printStackTrace(); }
}

No comments:

Post a Comment