Question

我能够输出我的桌子,但我却不拿桌头,在我的档案被拯救到我的系统时,我想显示头脑。

这是我使用的java法典:

import java.io.*;
import java.sql.*;

public class ExportData {

    public static void main(String args[]) {
        String Driver;
        Statement stmt;
        Driver = "com.mysql.jdbc.Driver";
        Connection con = null;

        try {
            Class.forName(Driver);
            con = DriverManager.getConnection(
                  "jdbc:mysql://localhost/emp", "root", "");
            if (!con.isClosed()) {
                System.out.println("Successfully connected to MySQL DataBase 
");
                stmt = con.createStatement();
                String filename = "C:/2.txt";
                String tablename = "employees";
                String sql;
                stmt.executeUpdate("SELECT * INTO OUTFILE ""
                        + filename + "" FROM " + tablename);
            }
        } catch (Exception e) {
            System.err.println("Exception: " + e.getMessage());
        } finally {
            try {
                if (con != null) {
                    con.close();
                }
            } catch (SQLException e) {
            }
        }
    }
}

Answer 1

举一个例子,作为有关MySQL手册页的评论:

select  idPago , fecha , lead , idAlumno , idTipoPago , idGpo ,
     idTaller , idDocente , pagoImporte , NoFactura , facturaImporte ,
     mes , formaPago , observaciones  union all
(select id_control_pagos, fecha, lead, id_alumno, id_concepto_pago, id_Gpo,id_Taller,
    id_docente, Pagoimporte, NoFactura, FacturaImporte, Mensualidad_No, FormaPago,
    Observaciones from control_pagos
    into outfile  c:\data.csv 
    FIELDS TERMINATED BY  , 
    OPTIONALLY ENCLOSED BY  " 
    LINES TERMINATED BY  
 );

简言之,你必须逐手增加一栏标签。

Answer 2

http://docs.oracle.com/javase/1.4.2/docs/api/java/sql/ResultSetMetaData.html ResultSetMetaData

友情链接