java 跪求 用jxl 将EXcel中数据 导入 MYSQL的源码~
来源:百度知道 编辑:UC知道 时间:2024/06/03 21:16:30
看下吧..
import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import Bean.DBClass;
import Bean.DBContr;
public class Test {
static String UserName = "newExcel"; // 生成的数据库名字
private static Connection conn = null;
private static String drive = "com.mysql.jdbc.Driver";
private static String DBurl ="jdbc:mysql://localhost:3306/muren";
private static String name = "sa"; //数据库账号
private static String pwd = "sa"; //数据库,密码
private static Statement st=null;
public static void main(String[] args) {