java爬虫mysql

import java.net.HttpURLConnection;
import java.net.URL;

public class Crawler {
    public static void main(String[] args) throws Exception {
        URL url = new URL("http://example.com");
        HttpURLConnection connection = (HttpURLConnection) url.openConnection();
        connection.setRequestMethod("GET");
        connection.setRequestProperty("User-Agent", "Mozilla/5.0");
        connection.setConnectTimeout(5000);
        connection.setReadTimeout(5000);
        int responseCode = connection.getResponseCode();
        System.out.println("Response Code: " + responseCode);
    }
}

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

public class Database {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=UTF-8";
        String user = "root";
        String password = "password";
        Connection connection = DriverManager.getConnection(url, user, password);
        String sql = "INSERT INTO mytable (name) VALUES (?)";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.setString(1, "中文");
        statement.executeUpdate();
        statement.close();
        connection.close();
    }
}

import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;

public class MultiThreadCrawler {
    public static void main(String[] args) {
        ExecutorService executorService = Executors.newFixedThreadPool(10);
        for (int i = 0; i < 100; i++) {
            executorService.submit(new CrawlerTask("http://example.com/" + i));
        }
        executorService.shutdown();
    }
}

class CrawlerTask implements Runnable {
    private String url;

    public CrawlerTask(String url) {
        this.url = url;
    }

    @Override
    public void run() {
        // 爬虫逻辑
    }
}