JAVA读取数据库数据保存到Excel中

1.jar包选择

2.数据库表

3.JDBC连接数据库工具类

package Test;

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

public class DBhepler {
	String url ="jdbc:mysql://192.168.0.109:3306/javenforexcel?useUnicode=true&characterEncoding=utf-8";

	String user="root";
	String pwd="123456";
	Connection conn=null;
	ResultSet rs=null;
	
	public void DataBase() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn=DriverManager.getConnection(url, user, pwd);
		} catch (ClassNotFoundException e) {