D:\BATCH\1.bat    testwrapper就是wrapper-windows生成出来的服务名称

@echo off
sc stop testwrapper
sc config testwrapper start= Auto

sc start testwrapper

rem -----------------------------------------------------------rem注释
rem @echo off
rem echo 确定要启动oracle 11g服务吗?
rem net start "OracleOraDb11g_home1TNSListener"
rem net start "OracleServiceORCL"
rem echo 启动Oracle 11g服务完成,请确认有没有错误发生。

rem @echo off
rem sc stop 服务名称
rem sc config 服务名称 start= Auto
rem sc start 服务名称



public class MyConn {

static Connection getConn() {
   String driver = "com.mysql.jdbc.Driver";
   String url = "jdbc:mysql://xxxxxx:3326/xxxxxxxx";
   String username = "roo";
   String password = "root";
   Connection conn = null;
   try {
       Class.forName(driver); //classLoader,加载对应驱动
       conn = (Connection) DriverManager.getConnection(url, username, password);
   } catch (ClassNotFoundException e) {
   } catch (SQLException e) {
   return conn;

public class HttpRequestUtils {
     * httpPost
     * @param url  路径
     * @param jsonParam 参数
     * @return
    public static JSONObject httpPost(String url,JSONArray jsonParam){
        return httpPost(url, jsonParam, false);
     * post请求
     * @param url         url地址
     * @param jsonParam     参数
     * @param noNeedResponse    不需要返回结�?
     * @return
    public static JSONObject httpPost(String url,JSONArray jsonParam, boolean noNeedResponse){
        DefaultHttpClient httpClient = new DefaultHttpClient();
        JSONObject jsonResult = null;
        HttpPost method = new HttpPost(url);
        try {
            if (null != jsonParam) {
                StringEntity entity = new StringEntity(jsonParam.toString(), "utf-8");
            HttpResponse result = httpClient.execute(method);
            url = URLDecoder.decode(url, "UTF-8");
            if (result.getStatusLine().getStatusCode() == 200) {
                String str = "";
                try {
                    str = EntityUtils.toString(result.getEntity());
                    if (noNeedResponse) {
                        return null;
                    jsonResult = JSONObject.fromObject(str);
                } catch (Exception e) {
        } catch (IOException e) {
        return jsonResult;
     * 发�?�get请求
     * @param url    路径
     * @return
    public static JSONObject httpGet(String url){
        JSONObject jsonResult = null;
        try {
            DefaultHttpClient client = new DefaultHttpClient();
            HttpGet request = new HttpGet(url);
            HttpResponse response = client.execute(request);
            if (response.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
                String strResult = EntityUtils.toString(response.getEntity());
                jsonResult = JSONObject.fromObject(strResult);
                url = URLDecoder.decode(url, "UTF-8");
            } else {
                System.out.println("get请求提交失败:" + url);
        } catch (IOException e) {
        return jsonResult;

public class Main{

private static String url = "http://xxxxx:8080/xxxx/xxxx/xxxx/";  
private static List<Map<String, Object>> list = new ArrayList<Map<String,Object>>(); 
public static void main(String[] args) throws IOException, SQLException {

Statement stmt = null;
ResultSet rs = null;
String sql = null;

try {
Connection conn = MyConn.getConn();
stmt = conn.createStatement();
sql = "select * from admin_user";
rs = stmt.executeQuery(sql);//执行sql语句
       ResultSetMetaData md = rs.getMetaData(); //获得结果集结构信息,元数据  
       int columnCount = md.getColumnCount();   //获得列数
Map<String,Object> rowData = new HashMap<String,Object>();  
           for (int i = 1; i <= columnCount; i++) {  
               rowData.put(md.getColumnName(i), rs.getObject(i));  
} catch (Exception e) {
      JSONArray jsonarray = JSONArray.fromObject(list); 
    HttpRequestUtils.httpPost(url, jsonarray, false);


wrapper.conf  主要配置文件

# Configuration files must begin with a line specifying the encoding
#  of the the file.

# Wrapper License Properties (Ignored by Community Edition)
# Professional and Standard Editions of the Wrapper require a valid
#  License Key to start.  Licenses can be purchased or a trial license
#  requested on the following pages:

# Include file problems can be debugged by removing the first '#'
#  from the following line:

# The Wrapper will look for either of the following optional files for a
#  valid License Key.  License Key properties can optionally be included
#  directly in this configuration file.
#include ../conf/wrapper-license.conf
#include ../conf/wrapper-license-%WRAPPER_HOST_NAME%.conf

# The following property will output information about which License Key(s)
#  are being found, and can aid in resolving any licensing problems.

# Wrapper Localization
# Specify the locale which the Wrapper should use.  By default the system
#  locale is used.
#wrapper.lang=en_US # en_US or ja_JP

# Specify the location of the Wrapper's language resources.  If these are
#  missing, the Wrapper will default to the en_US locale.

# Wrapper Java Properties
# Java Application
#  Locate the java binary on the system PATH:
#  Specify a specific java binary:

# Tell the Wrapper to log the full generated Java command line.

# Java Main class.  This class must implement the WrapperListener interface
#  or guarantee that the WrapperManager class is initialized.  Helper
#  classes are provided to do this for you.  See the Integration section
#  of the documentation for details.

# Java Classpath (include wrapper.jar)  Add class path elements as
#  needed starting from 1

# Java Library Path (location of Wrapper.DLL or

# Java Bits.  On applicable platforms, tells the JVM to run in 32 or 64-bit mode.

# Java Additional Parameters

# Initial Java Heap Size (in MB)

# Maximum Java Heap Size (in MB)

# Application parameters.  Add parameters as needed starting from 1

# Wrapper Logging Properties
# Enables Debug output from the Wrapper.
# wrapper.debug=TRUE

# Format of output for the console.  (See docs for formats)

# Log Level for console output.  (See docs for log levels)

# Log file to use for wrapper output logging.

# Format of output for the log file.  (See docs for formats)

# Log Level for log file output.  (See docs for log levels)

# Maximum size that the log file will be allowed to grow to before
#  the log is rolled. Size is specified in bytes.  The default value
#  of 0, disables log rolling.  May abbreviate with the 'k' (kb) or
#  'm' (mb) suffix.  For example: 10m = 10 megabytes.

# Maximum number of rolled log files which will be allowed before old
#  files are deleted.  The default value of 0 implies no limit.

# Log Level for sys/event log output.  (See docs for log levels)

# Wrapper General Properties
# Allow for the use of non-contiguous numbered properties

# Do not start if the pid file already exists.

# Title to use when running as a console

# Wrapper JVM Checks
# Detect DeadLocked Threads in the JVM. (Requires Standard Edition)

# Out Of Memory detection.
# (Ignore output from dumping the configuration to the console.  This is only needed by the TestWrapper sample application.)
#  Ignore -verbose:class output to avoid false positives.
wrapper.filter.trigger.1000=[Loaded java.lang.OutOfMemoryError
# (Simple match)
# (Only match text in stack traces if -XX:+PrintClassHistogram is being used.)
#wrapper.filter.trigger.1001=Exception in thread "*" java.lang.OutOfMemoryError
wrapper.filter.message.1001=The JVM has run out of memory.

# Wrapper Email Notifications. (Requires Professional Edition)
# Common Event Email settings.<SMTP_Host>[%WRAPPER_HOSTNAME%:%WRAPPER_NAME%:%WRAPPER_EVENT_NAME%] Event Notification<Sender email><Recipient email>

# Configure the log attached to event emails.

# Enable specific event emails.

# Specify custom mail content JVM was restarted.\n\nPlease check on its status.\n

# Wrapper Windows NT/2000/XP Service Properties
# WARNING - Do not modify any of these properties when an application
#  using this configuration file has been installed as a service.
#  Please uninstall the service before modifying this section.  The
#  service can then be reinstalled.

# Name of the service

# Display name of the service

# Description of the service
wrapper.description=Tmr UpLoad Data Application Description

# Service dependencies.  Add dependencies as needed starting from 1

# Mode in which the service is installed.  AUTO_START, DELAY_START or DEMAND_START

# Allow the service to interact with the desktop.

©️2020 CSDN 皮肤主题: 编程工作室 设计师:CSDN官方博客 返回首页