高校成绩管理系统

package grade; import java.io.*; import java.sql.*; import jxl.Workbook; import jxl.write.*; public class WriteExcel { public WriteExcel() {} public void Create(String cid) { try { String sql="select * from ginfo where cid="+cid; System.out.print(sql); String name="grade"+cid; WritableWorkbook book=Workbook.createWorkbook(new File(name+".xls")); WritableSheet sheet=book.createSheet("page1", 0); String driverName="com.mysql.jdbc.Driver"; String userName="root"; String userPassword="Nicholas2015whf"; String dbName="grade"; String url="jdbc:mysql://localhost:3306/"+dbName+"?useSSL=false"; Connection con=null; Statement s; ResultSet rs; try{ Class.forName(driverName).newInstance(); }catch(ClassNotFoundException e){ System.out.print("没有程序找得到Error loading Driver"); } try{ con=DriverManager.getConnection(url,userName,userPassword); }catch(SQLException er){ System.out.print("Error getConnection"); } try{ s=con.createStatement(); rs=s.executeQuery(sql); int i=1; Label label; label=new Label(0,0,"学号"); sheet.addCell(label); label=new Label(1,0,"课程号"); sheet.addCell(label); label=new Label(2,0,"平时成绩"); sheet.addCell(label); label=new Label(3,0,"期末成绩"); sheet.addCell(label); label=new Label(4,0,"实验成绩"); sheet.addCell(label); label=new Label(5,0,"补考成绩"); sheet.addCell(label); label=new Label(6,0,"清考成绩"); sheet.addCell(label); label=new Label(7,0,"最终成绩"); sheet.addCell(label); while(rs.next()){ label=new Label(0,i,rs.getString("id")); sheet.addCell(label); label=new Label(1,i,rs.getString("cid")); sheet.addCell(label); label=new Label(2,i,rs.getString("ng")); sheet.addCell(label); label=new Label(3,i,rs.getString("tg")); sheet.addCell(label); label=new Label(4,i,rs.getString("eg")); sheet.addCell(label); label=new Label(5,i,rs.getString("sg")); sheet.addCell(label); label=new Label(6,i,rs.getString("lg")); sheet.addCell(label); label=new Label(7,i,rs.getString("fg")); sheet.addCell(label); i++; } rs.close(); s.close(); con.close(); }catch(SQLException er){ System.err.println("Error executeQuery"); } book.write(); book.close(); System.out.print("生成excel"); }catch(Exception e) { } } }