jdbc dml语句

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestDML {/** * @param args * @throws ClassNotFoundException  * @throws SQLException  */public static void main(String[] args)  {// TODO Auto-generated method stubif (args.length != 3) {System.out.println("parameter error!please input again!");System.exit(-1);}int id = 0;try { id = Integer.parseInt(args[0]);} catch (NumberFormatException e) {// TODO: handle exceptione.printStackTrace();System.exit(-1);}String name = args[1];int age = 0;try { age = Integer.parseInt(args[2]);} catch (NumberFormatException e) {// TODO: handle exceptione.printStackTrace();System.exit(-1);}Connection conn = null;Statement statement = null;try {Class.forName("oracle.jdbc.driver.OracleDriver");conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","123456");statement = conn.createStatement();String sql = "insert into student values ("+ id + ",'" + name + "'," + age +")";System.out.println(sql);statement.executeUpdate(sql);} catch (ClassNotFoundException e) {// TODO: handle exceptione.printStackTrace();} catch (SQLException e) {// TODO: handle exceptione.printStackTrace();} finally{try {if (statement != null) {statement.close();statement = null;}if (conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}