Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to use Java to import the data in excel into mysql. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Idea: first take out the data in excel, and then transfer the data to the database. Jxl.jar is needed to operate excel, and the most basic jdbc can be used to operate the database. Mysql-connector-java-5.0.8-bin.jar is needed as a jar package.

Let's take a look at the screenshot of excel:

Let's take a look at the final effect:

The entire code is posted below:

Package browser; import java.io.File; import java.sql.*; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; public class PushExcelToMysql {public static void main (String [] args) throws Exception {Sheet sheet; Workbook workbook; Cell [] [] cells=new Cell [3] [3]; try {workbook=Workbook.getWorkbook (new File ("E:\\ lalala.xls")); sheet=workbook.getSheet (0); for

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.