java操作数据库

java操作数据库

操作数据库前的数据准备,可以直接跳过,看第二部分代码

package main;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;

public class Fij {

	public static void createDistanceMatrix(String dataFile) throws IOException {
		BufferedReader reader = new BufferedReader(// 读取器读取文件模板
				new InputStreamReader(new FileInputStream(dataFile)));
		int cityCount = 1;

		for (int i = 0; i < cityCount; i++) {
			String line = reader.readLine();// 一次读取一行
			String[] values = line.split(" ");// 分割:用空格把数据分隔开
			System.out.println(line);
		}
		reader.close();

	}

	public void ACO(String dataFile) {
		try {
			Fij.createDistanceMatrix(dataFile);
			// Util.createDistanceMatrix(dataFile);
		} catch (IOException e) {
			System.out.println("读取数据文件的时候,产生了异常");
			e.printStackTrace();
		}
	}
}

package main;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {

	public static void main(String[] args)
			throws ClassCastException, SQLException, ClassNotFoundException, IOException {
		Class.forName("com.mysql.cj.jdbc.Driver");
		// 连接MySql数据库，用户名和密码都是root
		String url = "jdbc:mysql://localhost:3306/s_t?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT";
		String username = "root";
		String password = "123456";

		Connection con = DriverManager.getConnection(url, username, password);
		Statement statement = con.createStatement();
		ResultSet resultset = statement.executeQuery("select * from student");
		System.out.println("Sno Sname Ssex Sage Sdept");
		while (resultset.next()) {
			System.out.println(resultset.getString(1) + " " + resultset.getString(2) + " " + resultset.getString(3)
					+ " " + resultset.getString(4) + " " + resultset.getString(5));
		}
		System.out.println("数据库连接成功");
		BufferedReader reader = new BufferedReader(// 读取器读取文件模板
				new InputStreamReader(new FileInputStream("F:\\FeigeDownload\\UserBehavior.csv~\\UserBehavior.csv")));

		String sql = "INSERT INTO `s_t`.`taobao` (`col1`, `col2`, `col3`, `col4`, `col5`) VALUES ('%s', '%s', '%s', '%s', '%s')";
		for (int i = 0; i < 100; i++) {
			String[] values = reader.readLine().split(",");
			String sql1 = String.format(sql, values[0], values[1], values[2], values[3], values[4]);
			statement.execute(sql1); //
			String line = reader.readLine(); // System.out.println(line); }
		}
		statement.close();
		con.close();
	}
}