先下好jxl,导入jar包。以下代码是为了读取从第三行起的数据并存入到数据库中的测试代码(前两行是标题行)。存着供参考……
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db","root","");
- String sql1 = "insert into student_info(CREATEDT,FULLNAME,BIRTHDAY,GENDER,MAJOR,REGION,INSTITUTION,MOBILEPHONE,QQNUMBER,EMAIL,FEE,ENTERFOREXTRA) value (?,?,?,?,?,?,?,?,?,?,?,?)";
- PreparedStatement ps1 = conn.prepareStatement(sql1);