java oracle 插入_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();

}

}

}

}