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) {