jdbc链接sqlserver数据库执行SQL脚本样例

public static void main(String[] args){
        String dr = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String URL = "jdbc:sqlserver://localhost:1433;databaseName=icare";
        String USERNAME = "admin";
        String PASSWORD = "icare";
        try {  
            // 加载驱动  
            Class.forName(dr);  
        } catch (ClassNotFoundException e) {  
            e.printStackTrace();  
        }  
        
        
        Connection conn = null;  
        System.out.println("开始连接数据库");
        try{  
            conn=(Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);  
            
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from ledcode");
           while(rs.next()){
                for(int j = 1; j <= rs.getMetaData().getColumnCount(); j++){
                    System.out.print(rs.getString(j));
                    System.out.print("\t");
                }
                System.out.println();
            }
            
            
            
            conn.close();
        }catch(SQLException e){  
            e.printStackTrace();  
            System.out.println("数据库连接失败！");
            return;
        }  
        System.out.println("数据库连接成功");
    }