jsonrreader java_使用java读取json数据

packagecn.itcast.day04.test;import java.io.*;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.Arrays;importjava.util.List;importjava.util.regex.Matcher;importjava.util.regex.Pattern;public classConMysql {public static voidmain(String[] args) {

String[][] strings= writeToDat("E:\\Java\\basic-code\\day04-code\\src\\cn\\itcast\\day04\\test\\en_ch.js");//getConnection("jdbc:mysql://localhost:3306","db1","root","root");

insertIntoTable("jdbc:mysql://localhost:3306", "db1", "root", "root", "user", strings);

}private static String url_unic = "?useUnicode=true&characterEncoding=utf8";//读文件

public staticString[][] writeToDat(String path) {

File file= newFile(path);

List list = new ArrayList();

String[][] strings= null;try{

InputStreamReader isr= new InputStreamReader(new FileInputStream(file), "utf8");

BufferedReader bw= newBufferedReader(isr);

String line= null;while ((line = bw.readLine()) != null) {if (!line.equals("")) {

list.add(line);

}

}

bw.close();

}catch(IOException e) {

e.printStackTrace();

}

list= list.subList(1, list.size() - 1);

strings= new String[list.size()][2];//System.out.println(list);

for (int a = 0; a < list.size(); a++) {

String[] split= list.get(a).split(":");//System.out.println(Arrays.toString(split));

for (int b = 0; b < split.length; b++) {

Pattern p= Pattern.compile(",|\\s*|\t|\r|\n");

Matcher m=p.matcher(split[b]);

split[b]= m.replaceAll("");if (a != list.size() - 1) {if (b == split.length - 1) {

String substring= split[b].substring(0, split[b].length());

strings[a][b]=substring;

}else{

strings[a][b]=split[b];

}

}else{

strings[a][b]=split[b];

}

}

}//for (int i = 0; i < list.size(); i++) {//String[] st = list.get(i).split("\t");//

//for (int j = 0; j < st.length; j++) {//Pattern p = Pattern.compile(",|\\s*|\t|\r|\n");//Matcher m = p.matcher(st[j]);//st[j] = m.replaceAll("");//st[j] = st[j].replaceAll(":",",");//strings[i][j] = st[j];// //System.out.println(strings[i][j]);//}//}//[['11','one'],['22','two']]

System.out.println("load data success!");returnstrings;

}//连接数据库

public staticConnection getConnection(String url, String dataBase, String user, String pwd) {

Connection conn= null;try{

Class.forName("com.mysql.jdbc.Driver");

String url_total= url + "/" + dataBase +url_unic;//System.out.println(url_total);

conn =DriverManager.getConnection(url_total, user, pwd);

System.out.println("connection success!");

}catch(Exception e) {

System.out.println("connection fail!");

e.printStackTrace();

}returnconn;

}//关闭数据库连接

public static voidcloseCon(Connection con) {if (con != null) {try{

con.close();

}catch(Exception e) {

e.printStackTrace();

}

}

}//插入数据

public static booleaninsertIntoTable(String url, String dataBase, String user, String pwd, String table, String[][] str) {

Connection conn=getConnection(url, dataBase, user, pwd);try{

String sql= "insert into " + table + " (" + "uid,uname"

+ ")" + " values " + "(?,?)";

PreparedStatement pstmt=conn.prepareStatement(sql);for (int i = 0; i < str.length; i++) {

pstmt.setInt(1, Integer.parseInt(str[i][0]));//System.out.println(str[i][0]);

for (int j = 1; j < str[i].length; j++) {//System.out.println(str[i][j]);

pstmt.setString(j + 1, str[i][j]);

}

pstmt.executeUpdate();

}

System.out.println("insert data success!");

closeCon(conn);return true;

}catch(SQLException e) {

e.printStackTrace();

System.out.println("insert data fail!");

closeCon(conn);return false;

}

}

}