java 跪求 用jxl 将EXcel中数据 导入 MYSQL的源码~

来源:百度知道 编辑:UC知道 时间:2024/06/03 21:16:30
RT

看下吧..

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