java中sql语句_在java中执行多个SQL语句

我想用

Java执行查询.

我创建了一个连接.然后我想执行一个INSERT语句,完成后,连接关闭,但我想通过连接执行一些insert语句,当循环完成然后关闭连接.

我能做什么 ？

我的示例代码是：

public NewClass() throws SQLException {

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e) {

System.out.println("Where is your Oracle JDBC Driver?");

return;

}

System.out.println("Oracle JDBC Driver Registered!");

Connection connection = null;

try {

connection = DriverManager.getConnection(

"jdbc:oracle:thin:@localhost:1521:orcl1", "test",

"oracle");

} catch (SQLException e) {

System.out.println("Connection Failed! Check output console");

return;

}

if (connection != null) {

Statement stmt = connection.createStatement();

ResultSet rs = stmt.executeQuery("SELECT * from test.special_columns");

while (rs.next()) {

this.ColName = rs.getNString("column_name");

this.script = "insert into test.alldata (colname) ( select " + ColName + " from test.alldata2 ) " ;

stmt.executeUpdate("" + script);

}

}

else {

System.out.println("Failed to make connection!");

}

}

当执行select语句(“SELECT * from test.special_columns”)时,循环必须是两次,但是当执行并完成(stmt.executeUpdate(“”script)),然后关闭连接并从类返回.