Java调用.bat 文件，求大神解决！！！！

Python015

Java调用.bat 文件，求大神解决！！！！,第1张

SP_CONFIGURE 'SHOW ADVANCED OPTIONS',1

RECONFIGURE

EXEC SP_CONFIGURE 'Ad Hoc Distributed Queries',1

RECONFIGURE

插入的代码：

INSERT INTO dbo.Resources(ResourcesUrl,ResourcesLink,ResourcesText) SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0HDR=YESDatabase=F:\Book1.xls', [sheet1$])

import java.io.BufferedReader

import java.io.InputStreamReader

public class RunBat {

public static void main(String[] args) {

try {

Process process = Runtime.getRuntime().exec("D:\\run.bat")

BufferedReader read = new BufferedReader(new InputStreamReader(process.getInputStream()))

String str = null

while ((str = read.readLine()) != null) {

System.out.println(str)

}

} catch (Exception e) {

e.printStackTrace()

}

}

}

@echo off

echo 正在加密，请稍后....

echo path:%~dp0

set base=%~dp0

set class=%base%\bin

set libs=%base%\lib

set

class_path=%class%%libs%\c3p0-0.9.1.2.jar%libs%\mysql-connector-java-5.0.8-bin.jar

java -classpath %class_path% com.test.Main

@pause

文件结构图：

classes目录是java编译后的class目录

libs目录存放的所要使用到的jar

startNet.bat为我们启动的bat文件