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.BufferedReaderimport 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文件