java里操作oracle执行插入操作

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

}