展开全部
首先导入 mysql-connector-java-5.1.45-bin.jar 包
代码如下:import java.io.*;
import java.sql.*;
public class App {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
// 数据库用户
String user = "root";
// 数据库密码
String password = "";
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_sale", user, password);
Statement stmt = conn.createStatement();
// 查询 , 从数据库 db_sale 的 product 表中查询 id, name, qty 字段
ResultSet rs = stmt.executeQuery("SELECT id, name, qty FROM product");
// 创建输出文32313133353236313431303231363533e4b893e5b19e31333365633936件 result.txt
File file = new File("d://result.txt");
OutputStreamWriter writer = new OutputStreamWriter(n