2018/6/8 山东大学学习资源聚合平台工作

今天主要完成的是审核系统的录入问题：

有三个json数据，分别代表已审核通过资源、待审核的内部资源、待审核的外部资源：

以及写了辅助导入json数据的java程序，思路很一般，就不做描述了：

package DataProcess;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.commons.io.FileUtils;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.UnsupportedEncodingException;

public class insertDataBase {
	private String url = "jdbc:mysql://localhost:3306/platform?useUnicode=true&characterEncoding=utf-8;";
	private String driver = "com.mysql.jdbc.Driver"; 
	private String userName = "root";
	private String password = "scx199702";
	
	private Connection getConnection(){
        Connection conn = null;
        try {
            Class.forName(driver);
            conn = DriverManager.getConnection(url, userName, password);
            if(!conn.isClosed()) {
                System.out.println("数据库连接成功!");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }
	//读入json，插入数据库
	public void loadDB(String path,String table_name){
//		FileInputStream in=null;
//		InputStreamReader inReader=null;
//		try {
//			in = new FileInputStream(path);
//			inReader = new InputStreamReader(in, "UTF-8"); 
//		} catch (FileNotFoundException e1) {
//			// TODO Auto-generated catch block
//			e1.printStackTrace();
//		} catch (UnsupportedEncodingException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}  
	    File f = new File(path);
	    String content = "";
		try {
			content = FileUtils.readFileToString(f, "UTF-8");
		} catch (IOException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
        Connection con = getConnection();
    	String sql = "INSERT INTO "+table_name+" (article_title,article_tag ,view_number,article_content,article_link) VALUES(?,?,?,?,?)";
    	Statement stmt;
    	
        try {
        		JSONArray jsonArray = new JSONObject(content).getJSONArray("RECORDS");
        		for(int i=0;i<jsonArray.length();i++){
        			JSONObject jsonObject = jsonArray.getJSONObject(i);
        			PreparedStatement ps = con.prepareStatement(sql);
        			ps.setString(1, jsonObject.getString("article_title"));
        			ps.setString(2, jsonObject.getString("article_tag"));
        			ps.setString(3, jsonObject.getString("view_number"));
        			ps.setString(4, jsonObject.getString("article_content"));
        			ps.setString(5, jsonObject.getString("article_link"));
        			ps.executeUpdate();       
        		}
		} catch (JSONException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}  
	}
	public static void main(String[] args) {
		new insertDataBase().loadDB("F:/Java/code/NLP/Resource/articles_passed.json","articles_passed");
		System.out.println("成功导入");
		new insertDataBase().loadDB("F:/Java/code/NLP/Resource/articles_checking_out.json","articles_checking_out");
		System.out.println("成功导入");
		new insertDataBase().loadDB("F:/Java/code/NLP/Resource/articles_checking_in.json","articles_checking_in");
		System.out.println("成功导入");
	}
}