??????д???????excel?????????????????????????????????????С??????в??????????????
?????????????????????????????飬??????????У??????ò???y????????й??????excel?????????ο???http://blog.csdn.net/trsli/article/details/17392943

????????????????????????????????????????????????db.                            ????????????????????
???????????????????????????????????????????????????sql???????и???????????????????????????????
/**??execl????????????
* @author trsli
* */
public class CreateDBTable {
private static Connection conn;
private static String sql="";
private static StringBuffer buf=new StringBuffer();
static{
conn=DBConnection.getConnection();
}
public static void main(String[] args) {
//????.xls???·??
System.out.println("???????·????");
String filename=new Scanner(System.in).nextLine();
//????????????????????????
Object[][] contents=new PoiUtil().getmessage(filename);
//???????????????????
Object[] titles=new PoiUtil().gettitles(filename);
System.out.println("?????????????");
String fname=new Scanner(System.in).nextLine();
try {
String ziduan="";
String blank="";
PreparedStatement stmt=conn.prepareStatement(sql);
buf.append("create table "+fname+"( id int primary key auto_increment");
//??????????????????????????????????????????????????
<span style="color:#ff6666;">for(int i=0;i<titles.length;i++){
buf.append("??"+titles[i]+"  varchar(20)");
if(i==titles.length-1){//??????β???“??”
ziduan+=titles[i]+"";
blank+="?";
}else{
ziduan+=titles[i]+"??";
blank+="???";
}
}
</span>         //sql?????????
sql="insert into "+fname+"("+ziduan+") values ("+ blank+")";
buf.append(" );");
stmt.executeUpdate(buf.toString());
System.out.println("?????...");
try {
Thread.sleep(2000);//???????????????????
System.out.println("??????...");
} catch (InterruptedException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
<span style="color:#ff6666;">for(int i=0;i<contents.length;i++){
Object[] content=contents[i];//??????????
PreparedStatement insert=conn.prepareStatement(sql);
for(int j=0;j<content.length;j++){
insert.setString(j+1?? content[j].toString());//?????????
}
insert.executeUpdate();//????????
System.out.println("??"+i+"?г??...");
try {
Thread.sleep(500);
} catch (InterruptedException e) {
e.printStackTrace();
}
</span>         }
System.out.println("???????????");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}