简易多线程任务 往数据库插数据

 

threadController  类:

package com.threads.threadPoolInsertData;

import java.io.IOException;
import java.sql.Timestamp;
import java.util.Date;
import java.util.UUID;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import com.alibaba.fastjson.JSONObject;

@Controller
public class threadController {

    @Autowired
    private threadService threadService;
    /**
     * 接收params参数
     * @param request
     * @param response
     * @throws IOException
     */
    @RequestMapping("/thread/requestData.do") 
    public void  requestData(HttpServletRequest request,HttpServletResponse response) throws IOException {
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/plain; charset=UTF-8");
        String stFjId = UUID.randomUUID().toString();
        String url = request.getParameter("url");
        String stApplyId = "000000000000001";
        String fjName = request.getParameter("fjName"); 
//        Date date = new Date();
//        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//        String time = format.format(date).toString();
        Timestamp  saveTime=new Timestamp(new Date().getTime());
        JSONObject json = new  JSONObject();
        json.put("stFjId", stFjId);
        json.put("url", url);
        json.put("stApplyId", stApplyId);
        json.put("fjName", fjName);
        json.put("time", saveTime);
        System.out.println("requestData--->"+json);
        threadService.insertData(json);
        
    }
    
    /**
     * 接收json参数
     * @param request
     * @param response
     * @throws IOException
     */
    @RequestMapping("/thread/requestData1.do")
    public void  requestData1(HttpServletRequest request,HttpServletResponse response) throws IOException{
        String data = threadService.getRequestPostStr(request);
        JSONObject json = JSONObject.parseObject(data);
        String stFjId = UUID.randomUUID().toString();
        String stApplyId = "CSJ000000000000001";
//        String url = json.getString("url");
//        String fjName =  json.getString("fjName");
        Timestamp  saveTime=new Timestamp(new Date().getTime());
        json.put("stFjId", stFjId);
        json.put("stApplyId", stApplyId);
        json.put("time", saveTime);
        System.out.println("requestData--->"+json);
        threadService.insertData(json);
    }
    
}

threadService 类:

package com.threads.threadPoolInsertData;

import java.io.IOException;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;
import javax.servlet.http.HttpServletRequest;
import org.springframework.stereotype.Service;
import com.alibaba.fastjson.JSONObject;

@Service
public class threadService {
    
    private ExecutorService executorService = Executors.newFixedThreadPool(20);
    
    public void  insertData(JSONObject json) {
        System.out.println("insertData--->"+json);
        executorService.execute(new threadUtil(json) );
    }
    
    
    //接收json参数
         public static String getRequestPostStr(HttpServletRequest request)
                    throws IOException {
             int contentLength = request.getContentLength();
                if(contentLength<0){
                    return null;
                }
                byte buffer[] = new byte[contentLength];
                for (int i = 0; i < contentLength;) {
                    int readlen = request.getInputStream().read(buffer, i,
                            contentLength - i);
                    if (readlen == -1) {
                        break;
                    }
                    i += readlen;
                }
                String charEncoding = request.getCharacterEncoding();
                System.out.println(charEncoding);
                if (charEncoding == null) {
                    charEncoding = "UTF-8";
                }
                return new String(buffer, charEncoding);
            }
}

threadUtil 类:

package com.threads.threadPoolInsertData;

import java.sql.Timestamp;
import com.alibaba.fastjson.JSONObject;
import wfc.service.database.SQL;

public class threadUtil implements Runnable {

    private JSONObject json;
    
    public threadUtil(JSONObject json) {
        this.json = json;
    }

    @Override
    public void run() {
        System.out.println("threadUtil--->"+json);
        System.out.println("当前线程:"+Thread.currentThread().getName());
        String stFjId = json.getString("stFjId");
        String stApplyId = json.getString("stApplyId");
        String fjName =json.getString("fjName");
        String url = json.getString("url");
        String time = json.getString("time");
        //String 转 Timestamp
        Timestamp saveTime = Timestamp.valueOf(time.toString());
        
        String sql = "insert into DAAN_FJ(ST_ID,APPLY_ID,NAME,URL,TIME) values (?,?,?,?,?)";
        Object[] objects = new Object[] { stFjId, stApplyId, fjName,url,saveTime };
        SQL.execute(sql,objects);
    }
    
    
}

 

简易多线程任务 往数据库插数据

上一篇:数据库-第十一章 并发控制-11.2 *


下一篇:MySql生成带自增标识的列