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());
}
}
}