百度搜索圈T社区免费行业视频教程www.aiquanti.com

package com.asima

import java.io.FileInputStream

import java.sql.Connection

import java.sql.DriverManager

import java.sql.PreparedStatement

import org.apache.poi.hssf.usermodel.HSSFCell

import org.apache.poi.hssf.usermodel.HSSFRow

import org.apache.poi.hssf.usermodel.HSSFSheet

import org.apache.poi.hssf.usermodel.HSSFWorkbook

public class XlsToAccess

return result

}

中

public void insertIntoTable() throws Exception

{

//创建对Excel工作簿文件的引用

HSSFWorkbook workbook=

new HSSFWorkbook(new FileInputStream('D:/temp/test.xls'))

//拿一张床单

globalSheet=workbook.getSheetAt(0)

String value1=readCellValue('c1')

String value2=readCellValue('c2')

String value3=readCellValue('c3')

String value4=readCellValue('c4')

System.out.println(value1)

System.out.println(value2)

Class.forName('sun.jdbc.odbc.JdbcOdbcDriver')

String url='jdbc:odbc:asima'

Connection conn=DriverManager.getConnection(url)

PreparedStatement stmt=

conn.prepareStatement('insert into custom values(?)？)”)

//定义查询的SQL语句

支撑。value1 setString (1)

支撑。value2 setString (2)

支撑。value3 setString (3)

支撑。value4 setString (4)

stmt.executeUpdate

java怎么操作excel转xml文件推荐知识