Java 写文件 写excel

Java写txt

 

package com.yundui;

import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class WtTxt {

	public static void main(String[] args) throws SQLException, IOException {
		// TODO Auto-generated method stub
		Connection conn = null;
		Statement st = null;
		ResultSet rSet = null;
		FileWriter fos = new FileWriter(System
					.getProperty("user.dir") + "\\lib\\b.txt");
		BufferedWriter bfw = new BufferedWriter(fos);
		

		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager
					.getConnection("jdbc:mysql://localhost:3306/weixindata",
							"root", "*****");
			st = conn.createStatement();
			if (conn != null) {
				System.out.println("连接数据库成功");
			}

			String querySql = "select wxNumber,wxName,wxopenId,wxFunction,"
					+ "wxConfirm,wxEssay,wxEssayTime,wxEssayBiz from data";
			rSet = st.executeQuery(querySql);

		} catch (Exception e) { // TODO: handle exception
			System.out.println("连接数据库失败!" + e.getMessage());
		}

		while (rSet.next()) {
			/*bfw.write(rSet.getString("wxNumber")+"|"+rSet.getString("wxName")+"|"
					+rSet.getString("wxopenId")+"|"+rSet.getString("wxFunction")+"|"
					+ rSet.getString("wxConfirm")+"|"+rSet.getString("wxEssay")+"|"
					+rSet.getString("wxEssayTime")+"|"+rSet.getString("wxEssayBiz"));*/
			bfw.write(rSet.getString("wxNumber")+"|"+rSet.getString("wxName")+"|"
					+rSet.getString("wxopenId")+"|"+rSet.getString("wxFunction")+"|"
					+rSet.getString("wxEssayBiz"));
		     bfw.newLine();
		}

		try {
			System.out.println("操作完成");
			bfw.close();
			fos.close();
			rSet.close();
			st.close();
			conn.close();
			System.out.println("关闭连接");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("关闭数据库连接错误" + e.getMessage());
		}
	}

}

Java 写excel

package com.yundui8;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import jxl.*;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class WtExcel {

	public static void main(String[] args) throws BiffException, IOException,
			RowsExceededException, WriteException {

		Connection conn = null;
		Statement st = null;
		ResultSet rSet = null;
		WritableWorkbook workbook = null;
		WritableSheet sheet = null;

		// TODO Auto-generated method stub
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO: handle exception
			System.out.println("加载数据库驱动失败!");
		}

		try {
			conn = DriverManager
					.getConnection("jdbc:mysql://localhost:3306/weixindata",
							"root", "****");
			st = conn.createStatement();
			if (conn != null) {
				System.out.println("连接数据库成功");
			}

		} catch (SQLException e) { // TODO: handle exception
			System.out.println("连接数据库失败!");
		}

		String querySql = "select wxNumber,wxName,wxopenId,wxFunction,"
				+ "wxConfirm,wxEssay,wxEssayTime,wxEssayBiz from data";

		try {
			workbook = Workbook.createWorkbook(new File(System
					.getProperty("user.dir") + "\\lib\\a.xls"));
			if (workbook != null) {
				sheet = workbook.createSheet("data", 0);
			}
			int count = 0;
			Label lb0, lb1, lb2, lb3, lb4, lb5, lb6, lb7;
			rSet = st.executeQuery(querySql);
			while (rSet.next()) {
				count++;
				lb0 = new Label(0, count, rSet.getString("wxNumber"));
				lb1 = new Label(1, count, rSet.getString("wxName"));
				lb2 = new Label(2, count, rSet.getString("wxopenId"));
				lb3 = new Label(3, count, rSet.getString("wxFunction"));
				lb4 = new Label(4, count, rSet.getString("wxConfirm"));
				lb5 = new Label(5, count, rSet.getString("wxEssay"));
				lb6 = new Label(6, count, rSet.getString("wxEssayTime"));
				lb7 = new Label(7, count, rSet.getString("wxEssayBiz"));
				sheet.addCell(lb0);
				sheet.addCell(lb1);
				sheet.addCell(lb2);
				sheet.addCell(lb3);
				sheet.addCell(lb4);
				sheet.addCell(lb5);
				sheet.addCell(lb6);
				sheet.addCell(lb7);
				
				
				lb0 = null;
				lb1 = null;
				lb2 = null;
				lb3 = null;
				lb4 = null;
				lb5 = null;
				lb6 = null;
				lb7 = null;
			//	System.out.println("第" + count + "个");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("查询和写入excel问题" + e.getMessage());
		}
		try {
			workbook.write();
			workbook.close();
			st.close();
			conn.close();
			System.out.println("关闭连接");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("关闭数据库连接错误" + e.getMessage());
		}
	}

}