package com.lsf;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.sql.*;
import java.io.*;
import java.util.ArrayList;
import java.sql.Connection;
public class ReadExcelTest
{
private Connection con;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String DBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String USER="sa";
String PWD="sa";
private ArrayList listFirstColum = new ArrayList();
private ArrayList listSecondColum = new ArrayList();
// 连接数据库
public ReadExcelTest() throws Exception
{
try
{
Class.forName(DBDriver);
con=DriverManager.getConnec