import java.sql.*;
public class TestDML2 {
/**
* @param args
*/
public static void main(String[] args) {//值得注意的是这里的args输入参数的方法
// TODO Auto-generated method stub//鼠标右键 open run Dialog,对话框里Argument里写参数要传递的数值
if(args.length!=3) {
System.out.println("Parameter error,please input again");
System.exit(-1);
}
int deptno = 0;
try {
deptno = Integer.parseInt(args[0]);
} catch (NumberFormatException e) {
// TODO: handle exception
System.out.println("Prameter Error!Deptno should be Number Format");
System.exit(-1);
}
String ename = args[1];
String loc = args[2];
Connection conn = null;
String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String sql = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url,"scott","mm");
sql = "insert into dept values (" + deptno+",'" + ename +"','"+ loc + "')";
Statement stmt = conn.createStatement();
System.out.println(sql);
stmt.executeUpdate(sql);
} catch (ClassNotFoundException e) {
System.out.println(" class should be exist in the reminded address");
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
优化
import java.sql.*;
public class TestDML3 {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
if(args.length!=3) {
System.out.println("Parameter error,please input again");
System.exit(-1);
}
int deptno = 0;
try {
deptno = Integer.parseInt(args[0]);
} catch (NumberFormatException e) {
// TODO: handle exception
System.out.println("Prameter Error!Deptno should be Number Format");
System.exit(-1);
}
String ename = args[1];
String loc = args[2];
Connection conn = null;
PreparedStatement pstmt = null;
String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String sql = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url,"scott","mm");
pstmt = conn.prepareStatement("insert into dept values(?,?,?)");
pstmt.setInt(1, deptno);
pstmt.setString(2,ename);
pstmt.setString(3, loc);
pstmt.executeUpdate();
} catch (ClassNotFoundException e) {
System.out.println(" class should be exist in the reminded address");
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if(pstmt!=null) {
pstmt.close();
}
if(conn!=null) {
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}