mydao.java

java导出Excel,使用jxl,可以完成将Excel内容插入数据库,将数据库内容导出到Excel

package com.xzb.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

import com.xzb.db.DBCon;
import com.xzb.entity.Test;

public class MyDao {
	public int insert(List<Test> list){
		int num=0;
		Connection con=DBCon.getCon();
		String sql="insert into test values(?,?)";
		try {
			PreparedStatement prep=con.prepareStatement(sql);
			for(int i=0;i<list.size();i++){
				Test test=list.get(i);
				prep.setString(1,test.getName());
				prep.setInt(2, test.getAge());
				num+=prep.executeUpdate();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return num;
	}
}