通过数据库进行文本格式转化

想根据某个表，生成特定格式的数据“

package com.travel.util;

import java.sql.DriverManager;
import java.sql.ResultSet;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class Test{
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yrlife?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull", "root", "");
			Statement state = (Statement) conn.createStatement();
			ResultSet rs = state.executeQuery("select code_desc,code from travel_flight_comm_attr where type = 'INTcityCN'");
			int i= 0;
			while(rs.next()){
				i++;
				System.out.print("'"+rs.getString(1)+"|"+rs.getString(2)+"',");
				if(i%10 == 0){
					System.out.println();
				}
			}
			System.out.println("数量为："+i);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}