Java imports the Excel data into the database in bulk, Java imports the Excel data code as follows
1. Public list<choice> Getfromxls (String xlsname) {
2.
3. list<choice> choices = new arraylist<choice> ();
4. Choice Choice=null;
5. Try {
6. Java.io.File file=new java.io.File (xlsname);
7. Workbook book = workbook.getworkbook (file);
8.
9.//Get the first sheet, the default is three
Sheet Sheet = book.getsheet (0);
11.//How many rows and columns of data are there altogether?
. int rows = Sheet.getrows ();
int columns = Sheet.getcolumns ();
. for (int i = 1; I <rows; i++) {
. Boolean hasText = false;
16.//filter out lines with no text content
. for (int j = 0; j < columns; J + +)
if (Sheet.getcell (J, i). getcontents (). Length ()!=0) {
HasText = true;
break;
21.}
if (HasText) {
. try {
24.
Choice = new Choice ();
Choice.settypeid (Integer.parseint (Sheet.getcell (0, I). getcontents ()));
Choice.setcataid (Sheet.getcell (1, i). getcontents ());
Choice.settitle (Sheet.getcell (2, I). getcontents ());
Choice.seta (Sheet.getcell (3, I). getcontents ());
Choice.setb (Sheet.getcell (4, I). getcontents ());
Choice.setc (Sheet.getcell (5, I). getcontents ());
CHOICE.SETD (Sheet.getcell (6, I). getcontents ());
Choice.setanswer (Sheet.getcell (7, I). getcontents ());
Choices.add (choice);
A.} catch (Exception e) {
//Todo:handle exception
Panax Notoginseng e.printstacktrace ();
38.}
39.
40.}
41.}
Book.close ();
.} catch (Exception e) {
E.printstacktrace ();
45.}
Choices return;
47.}
Batchinsert public int (final list<choice> q,string xlsname) {
//TODO auto-generated method stub
Final list<choice> choices = Getfromxls (xlsname);
Wuyi Final int size = Choices.size ();
52.
. int result=0;
54.//Here should get the question question to insert the database
. String sql = "INSERT into choice (title,typeid,cataid,a,b,c,d,answer)"
+ "VALUES (?,?,?,?,?,?,?,?)";
57.
Conn=jdbconn.getconn ();
try{.
Ps=conn.preparestatement (SQL);
. for (int i=0;i<size;i++) {
Choice Choice = Choices.get (i);
Ps.setstring (1, Choice.gettitle ());
Ps.setint (2,choice.gettypeid ());
Ps.setstring (3, Choice.getcataid ());
Ps.setstring (4, Choice.geta ());
Ps.setstring (5, CHOICE.GETB ());
Ps.setstring (6, choice.getc ());
Ps.setstring (7, choice.getd ());
Ps.setstring (8, Choice.getanswer ());
Ps.executeupdate ();
result++;
73.}
A.} catch (SQLException e) {
E.printstacktrace ();
The.} finally {
JDBCONN.CLOSEDB (conn);
78.}
. return result;
80.}
Java imports Excel data into the database in bulk