Java程序执行sql脚本

需要引入ant的jar包

public static int getConnection(String url,String user,String password) {

        SQLExec sqlExec;
        try {
            String[] sql = {"/table.sql","/tables_in.sql","/tables_up.sql","/cashbilllist_in.sql","/cashbilllist_del.sql","/cashbill_in.sql"
                    ,"/custment_in.sql","/custment_up.sql","/vip_in.sql","/vip_up.sql","/cashbilllist_up.sql"};
            System.out.println("size: " + sql.length);

            for(int i=0;i<sql.length;i++){
                String a = sql[i];
                System.out.println(a);
                sqlExec = new SQLExec();   

                //设置数据库参数   
                sqlExec.setDriver("com.microsoft.sqlserver.jdbc.SQLServerDriver");   
                sqlExec.setUrl(url);  
                sqlExec.setUserid(user);   
                sqlExec.setPassword(password);   

                sqlExec.setEncoding("UTF8");
                //要执行的脚本   
                sqlExec.setSrc(new File(System.getProperty("user.dir") + sql[i]));   

                //有出错的语句该如何处理   
                sqlExec.setOnerror((SQLExec.OnError)(EnumeratedAttribute.getInstance(   
                        SQLExec.OnError.class, "abort")));   

                sqlExec.setPrint(true); //设置是否输出   

                //输出到文件 sql.out 中；不设置该属性，默认输出到控制台   
                sqlExec.setOutput(new File(System.getProperty("user.dir")+"/sql.out"));   
                sqlExec.setProject(new Project()); // 要指定这个属性，不然会出错   
                sqlExec.execute();
            }
            return 1;
        } catch (Exception e) {
            e.printStackTrace();
            return 0;
        }   
    }