java_jar_exe.docVIP

工程结构： Service： package com.huawei.service; import java.sql.SQLException; import com.huawei.dao.PlayDao; import com.huawei.util.DBUtil; import com.mysql.jdbc.Connection; public class PlayService { public void getFile() { Connection conn = DBUtil.getConnection(); PlayDao dao = new PlayDao(conn); dao.getFile(); try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void setStatus() { Connection conn = DBUtil.getConnection(); PlayDao dao = new PlayDao(conn); dao.setStatus(); try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } Dao package com.huawei.dao; import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement; public class PlayDao { private Connection conn; public PlayDao(Connection conn) { super(); this.conn = conn; } public void getFile() { // TODO Auto-generated method stub FileWriter fw = null; BufferedWriter bw = null; Statement st = null; ResultSet rs = null; String sql = select fname from pipleline where is_clean = 0; try { fw = new FileWriter(E:/list.txt, false); bw = new BufferedWriter(fw); st = (Statement) conn.createStatement(); rs = st.executeQuery(sql); while(rs.next()) { // byte[] bytes = rs.getString(1).getBytes(); bw.write(rs.getString(1)); bw.newLine(); } } catch (SQLException | IOException e) { e.printStackTrace(); } finally { try { bw.flush(); fw.flush(); bw.close(); fw.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public void setStatus() { // TODO Auto-generated me