import java.sql.*;
import java.io.*; 
 import jxl.*;
 import jxl.write.*; 
 public class CreateSQL {
     public static void main(String args[]){
    	 Connection conn = null;
    	 Statement stmt = null;
    	 ResultSet rs = null;
    	 try{
    		 Class.forName("com.mysql.jdbc.Driver");
    	 }catch(ClassNotFoundException e){
    		 e.printStackTrace();
    	 }
    	 try{
    		 conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/text","root","123456");
    		 stmt = conn.createStatement();
    		 rs = stmt.executeQuery("select * from myclass");
    	 }catch(SQLException e){
    		 e.printStackTrace();
    	 }
    	 try{
    		 WritableWorkbook book = Workbook.createWorkbook(new File("测试2.xls"));
    		 //创建工作簿
    		 WritableSheet sheet = book.createSheet("第一页", 0);
    		 //创建工作表
    		 while(rs.next()){
    		 Label label = new Label(0,0,"test");
    		 //生成一个label对象
    		 sheet.addCell(label);
    		 //把对象加入到工作表中
    		 }
    		 jxl.write.Number number = new jxl.write.Number(1,0,789.123);
    		 sheet.addCell(number);
    		 book.write();
    		 book.close();
    	 }catch(Exception e){
    		 System.out.println(e);
    	 }
     }
}