oracleµ÷ÓÃjava³ÌÐòÁ¬sqlserver2005

1¡¢ÔÚoracleµÄsys-sysdbaϵǽ
дһ¸öjava source³ÌÐòÁ´½Ósqlserver2005£º
create or replace and compile java source named test as
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class excutesql1
{
    public static String entry(String str1,String str2) {
       String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
       // ¼ÓÔØjdbcÇý¶¯
    String a = "0";
       String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=wb"; // Á´½ÓÊý¾Ý¿â·þÎñºÍÇý¶¯sample
       String userName = "sa"; // Óû§Ãû
       String userPwd = "giap"; // ÃÜÂë
       Connection dbConn;
       try {
      a = "1";
           Class.forName(driverName);
           dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
           String sql = "insert into ry_jbxx (RYBH,XM) values ('" + str1
                  + "','" + str2 + "')";
           PreparedStatement pstmt = dbConn.prepareStatement(sql);
           pstmt.addBatch();
           pstmt.executeBatch();
      a = "2";
       } catch (Exception e) {
           e.printStackTrace();
      a = "error";
          
  &n