Write the Excel file content to the database-gentle

1. Package com. Zhupan. Spring;
3. Import java. Io. file;
5. Import javax. servlet. http. httpservletrequest;
6. Import javax. servlet. http. httpservletresponse;
8. Import jxl. sheet;
9. Import jxl. workbook;
11. Import org. springframework. validation. bindexception;
12. Import org. springframework. Web. multipart. multipartfile;
13. Import org. springframework. Web. multipart. multiparthttpservletrequest;
14. Import org. springframework. Web. servlet. modelandview;
15. Import org. springframework. Web. servlet. MVC. simpleformcontroller;
17. Import com. ctgusec. model. student_info;
18. Import com. ctgusec. Service. istudent_infomanage;
20. /***/
21. /**
22. * @ Author Zhupan
23. *
24. */
25. Public class estudentinsertexcelcontroller extends simpleformcontroller {
27. Private istudent_infomanage studentmanage;
29. @ Override
30. Protected modelandview onsubmit (httpservletrequest request,
31. Httpservletresponse response, object command, bindexception errors)
32. Throws exception {
33. Student_info = (student_info) command;
34. Try {
35. Multiparthttpservletrequest multipartrequest = (multiparthttpservletrequest) request;
36. Multipartfile file = multipartrequest. GetFile ("excelfile"); // obtain the file:
37. File tofile = new file ("C: // student information overview file .xls"); // generate file names and empty files
38. File. transferto (tofile); // File Upload
39. Workbook book = Workbook. getworkbook (tofile); // get the work thin
40. Sheet sheet = book. getsheet (0); // obtain the first worksheet object
41. Int ROW = sheet. getrows (); // obtain the number of rows for this sheet.
42. Int column = sheet. getcolumns (); // obtain the number of columns for this sheet.
43. System. Out. println ("number of data rows =" + row );
44. System. Out. println ("Data columns =" + column );
45. For (INT I = 1; I <row; I ++ ){
46. For (Int J = 0; j <column; j ++ ){
47. System. Out. println ("J =" + J );
48. Sheet. getcell (J, I). getcontents (); // obtain the class capacity of cells in row I of column J.
49. Student_info
50. . Setstudentid (sheet. getcell (J, I). getcontents ());
51. Student_info.setname (sheet. getcell (++ J, I). getcontents ());
52. Student_info.setsex (sheet. getcell (++ J, I). getcontents ());
53. Student_info.setunit (sheet. getcell (++ J, I). getcontents ());
54. Student_info.setclass _ (sheet. getcell (++ J, I). getcontents ());
55. Student_info.setspecialty (sheet. getcell (++ J, I)
56. . Getcontents ());
57. Student_info.setremark (sheet. getcell (++ J, I). getcontents ());
58. }
59. If (this. studentmanage. getstudentbystudentid (
60. Student_info.getstudentid (). Size ()! = 0)
61. Return new modelandview ("Education/e-studentinfoadderror ");
62. This. studentmanage. insertstudent_info (student_info );
63. }
64. Book. Close ();
65. Return new modelandview ("Education/e-studentinfoaddexcelsuccess ",
66. "Row", new INTEGER (Row-1 ));
67. } Catch (exception e ){
68. E. printstacktrace ();
69. }
70. Return new modelandview ("Education/e-studentinfoaddexcelerror ");
71. }
73. Public void setstudentmanage (istudent_infomanage studentmanage ){
74. This. studentmanage = studentmanage;
75. }
76. }