学步园

File file = new File("F://test.xls");<br /> Connection conn = getConnection();<br /> Statement st = null;<br /> try {<br /> st = conn.createStatement();<br /> } catch (SQLException e2) {<br /> e2.printStackTrace();<br /> }<br /> Workbook wb;<br /> try {<br /> wb = Workbook.getWorkbook(file);<br /> Sheet sheet = wb.getSheet(0);<br /> for (int i = 0; i < sheet.getRows(); i++) {<br /> String name = sheet.getCell(0, i).getContents();<br /> String pwd = sheet.getCell(1, i).getContents();<br /> String sql = "insert into login values('','" + name + "','"<br /> + pwd + "')";<br /> try {<br /> st.executeUpdate(sql);<br /> } catch (SQLException e) {<br /> e.printStackTrace();<br /> }<br /> }<br /> } catch (BiffException e1) {<br /> e1.printStackTrace();<br /> }