2014年复试数据库上机之数据库连接+导出数据到文件中

package scut.film;

import java.io.File;
import java.io.FileWriter;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SCUTFILM {
  
//-----------------------------------------------------------------数据库连接部分
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            String data ="jdbc:sqlserver://localhost:1433;databaseName=SCUT_FILM";
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            conn = DriverManager.getConnection(data ,"qjy","qjy");
            stmt = conn.createStatement();
        }catch (SQLException ex) {
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: "     + ex.getSQLState());
            System.out.println("VendorError: "  + ex.getErrorCode());
        }
  // -------------------------------------------------------------------查询部分
        try {

            rs = stmt.executeQuery("select * from 放映厅表");
            System.out.println("执行结果如下所示:");
            while (rs.next()) {
                String sno   = rs.getString("放映厅号");
                String sname = rs.getString("放映厅名");
                String sseat = rs.getString("座位数");
                newFile("E:\查询结果.txt",sno+"   "+sname+"   "+sseat);
                System.out.println( sno + "	" + sname + "	" + sseat);
            }
            rs.close();
            conn.close();

        }catch (Exception e) {
            e.printStackTrace();
        }
    }
//----------------------------------------------------------------------文件部分
    public static void newFile(String filePathAndName, String fileContent) {
        try {

            File myFilePath = new File(filePathAndName);
            if (!myFilePath.exists()) {
                myFilePath.createNewFile();
            }

            FileWriter resultFile = new FileWriter(myFilePath, true);
            PrintWriter myFile = new PrintWriter(resultFile);
            myFile.println(fileContent);  
            resultFile.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}