JDBC读取数据库，生成csv文件

最新推荐文章于 2022-12-09 22:59:30 发布

佛了菜鸟

最新推荐文章于 2022-12-09 22:59:30 发布

阅读量1.2k

点赞数

分类专栏： JDBC 文件导出文章标签： JDCB读取数据库，验证是否为手机号，导出csv文件

本文链接：https://blog.youkuaiyun.com/weixin_41346864/article/details/103295504

版权

本文档介绍如何通过Java JDBC连接到数据库，验证数据中的字段是否符合手机号码格式，并将符合条件的数据导出为CSV文件。步骤包括设置数据库连接，执行SQL查询，验证手机号码，以及使用Java IO流生成CSV文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public static void test4() throws ClassNotFoundException, SQLException {
   String fileName = "";
  ArrayList<DDebtorInfo> ddList = new ArrayList<DDebtorInfo>();
  FileOutputStream out = null;
  FileOutputStream out1 = null;
  FileOutputStream out2 = null;
  FileOutputStream out3 = null;
  FileOutputStream out4 = null;
  FileOutputStream out5 = null;
  StringBuilder sb = new StringBuilder();
  StringBuilder sb1 = new StringBuilder();
  StringBuilder sb2 = new StringBuilder();
  StringBuilder sb3 = new StringBuilder();
  StringBuilder sb4 = new StringBuilder();
  StringBuilder sb5 = new StringBuilder();
  try {
   out = new FileOutputStream(new File(fileName+ "remark.sql"));
   out1 = new FileOutputStream(new File(fileName+ "remark1.sql"));
   out2 = new FileOutputStream(new File(fileName+ "remark2.sql"));
   out3 = new FileOutputStream(new File(fileName+ "remark3.sql"));
   out4 = new FileOutputStream(new File(fileName+ "remark4.sql"));
   out5 = new FileOutputStream(new File(fileName+ "remark5.sql"));
  } catch (FileNotFoundException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }
  
  String remark = "";
  String remark1 = "";
  String remark2 = "";
  String remark3 = "";
  String remark4 = "";
  String remark5 = "";
  String URL="数据库地址";
     String USER="用户";
     String PASSWORD="密码";
      //1.加载驱动程序
   Class.forName("com.mysql.jdbc.Driver");
   System.out.println("加载驱动=============");
    //2.获得数据库链接
         Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);
         System.out.println("获取连接=============");
         //3.通过数据库的连接操作数据库，实现增删改查（使用Statement类）
         PreparedStatement  st= null;
         Resu

最低0.47元/天解锁文章