2014年复试数据库上机之数据库连接

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package scut.film;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
;

/**
 *
 * @author Administrator
 */
public class SCUTFILM {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        String data =  "jdbc:sqlserver://localhost:1433;databaseName=SCUT_FILM";
        try(
            Connection conn = DriverManager.getConnection(data ,"qjy","qjy");
            Statement st = conn.createStatement()){
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            ResultSet rec = st.executeQuery(
            //"select *"+"SQL语句" 
            "select * from 放映厅表"
            );
            while(rec.next()){
                System.out.println( rec.getString(1)+"   "+rec.getString(2)+"   "+rec.getString(3));
        }
            st.close();
            
        }catch(SQLException s){
            System.out.println("SQL error:" + s.toString() + " " +s.getErrorCode() + " " + s.getSQLState());
        }catch(Exception e){
            System.out.println("Error:..." + e.getMessage());
        }
    }
    
}