java将数据库查询结果写入文本

亦凉 2024-04-18 22:12 68阅读 0赞

核心思想：

1.  执行sql，list封装查询结果。
2.  创建一个文件。指定好文件的路径和名称。
3.  迭代遍历list，文件流写入文件。

代码示例：

public static void exportTxt() throws IOException{
    		Calendar cal = Calendar.getInstance();
    		cal.add(Calendar.DATE,-1);
    		Date edate = cal.getTime();
    		Date date = new Date();
    		SimpleDateFormat tempyyyymmdd = new SimpleDateFormat("yyyyMMdd");
    		String stime = tempyyyymmdd.format(edate);
    		String etime = tempyyyymmdd.format(date);
    		String sql = "select t.transno,t.offerid,t.offername,t.effdate,t.expdate, t1.username,t1.useridcode,t1.userbirth,t1.useraddress"
    				+ ",t1.vicecardflag,t1.hallno,t1.halladdress,t1.prodfinishdate,t1.inserttime,t1.cellphone "
    				+ " from SHJK_OFFERINFO t left join SHJK_USERINFO t1 on t.transno=t1.transno "
    				+ " where t.inserttime >= TO_DATE('"+stime+"','yyyyMMdd') and "
    				+ " t.inserttime <= TO_DATE('"+etime+"','yyyyMMdd')";
    		List list = SqlQuery.findList(sql);
    		//以上代码均是为了sql查询数据
    		String filename = FtpConstant.shjkfilename;
    		filename = filename.replace("YYYYMMDD", stime);
    	    File writename = new File("H://temp//"+filename);//修改成你想要放的路径
    	    writename.createNewFile(); // 如果不存在，创建新文件  
            //以上代码为创建文件，下面代码为写入的过程
    	    BufferedWriter out = new BufferedWriter(new FileWriter(writename)); //new一个写入对象，new FileWriter 指定写入的文件,通过字节写入
    	    out.write("交易流水,");
    	    out.write("销售品id,");
    	    out.write("销售品名称,");
    	    out.write("生效日期,");
    	    out.write("失效日期,");
    	    out.write("客户姓名,");
    	    out.write("客户身份证,");
    	    out.write("客户生日,");
    	    out.write("联系地址,");
    	    out.write("是否竣工,");
    	    out.write("受理营业厅编码,");
    	    out.write("受理营业厅名称,");
    	    out.write("开卡时间,");
    	    out.write("办理时间,");
    	    out.write("电话号码");
    	    out.write("\r\n"); //转义换行
    		//转存为txt
    		 Iterator itr = list.iterator();
    	        while(itr.hasNext()){
    	        	String[] strArray = (String[])itr.next();//存一行记录的一个字段
    	        	out.write(strArray[0]+",");
    	        	out.write(strArray[1]+",");
    	        	out.write(strArray[2]+",");
    	        	out.write(strArray[3]+",");
    	        	out.write(strArray[4]+",");
    	        	out.write(strArray[5]+",");
    	        	out.write(strArray[6]+",");
    	        	out.write(strArray[7]+",");
    	        	out.write(strArray[8]+",");
    	        	out.write(strArray[9]+",");
    	        	out.write(strArray[10]+",");
    	        	out.write(strArray[11]+",");
    	        	out.write(strArray[12]+",");
    	        	out.write(strArray[13]+",");
    	        	out.write(strArray[14]);
    	        	out.write("\r\n");
    	        }
    	        out.flush(); 
                out.close(); //关闭流对象
    	}