シンボルが見つけられない

package movie;

import java.util.*;
import java.sql.*;
import java.util.HashMap;

                       public class Model {
	        　　　　　　　private String q;
                       private String c;
                       private Connection conn = null;
                       private PreparedStatement stmt = null;
                       private ResultSet resultSet = null;
                       private HashMap<Integer,TitleListResult>Title_hash;
               
                    
                       public void execute(){
                       System.out.println("Hello");  
		
                   try {      
                        conn = ConnectUtilMy.connectDatabase();
	        
      	                        
			// 住所の検索
			PreparedStatement pstmt = conn.prepareStatement(
				"SELECT title_name,years_publication,performance_income,production_cost,public_evaluation,screening_time,genre_name,original_name,cast_n　　　　　　　　　　　　　　ame,directed_name " +
                 	"FROM movie inner join original_list on movie.original_number=original_list.original_number "+ 
                        "inner join genre_list on movie.genre_number=genre_list.genre_number "+ 
                        "inner join directed_list on movie.directed_number=directed_list.directed_number "+
                        "inner join cast_list on movie.cast_number=cast_list.cast_number where title_name like ? or directed_name 　　　　　　　　　　　　　　like ?");
			pstmt.setString(1, q + "%");
			pstmt.setMaxRows(50);
			ResultSet rs = pstmt.executeQuery();
                     
			// 検索結果の取得
			
                        HashMap<Integer, String[]> results = new HashMap<Integer, String[]>();           
                        int i = 0;
                        while (rs.next()) {
                        String[] result = new String[10];
                        result[0] = rs.getString("movie_number");
                        result[1] = rs.getString("years_publication");
                        result[2] = rs.getString("performance_income");
                        result[3] = rs.getString("production_cost");
                        result[4] = rs.getString("public_evaluation");                               
                        result[5] = rs.getString("screening_time");
                        result[6] = rs.getString("genre_number");
                        result[7] = rs.getString("directed_number");
                        result[8] = rs.getString("original_number");
                        result[9] = rs.getString("cast_number");
                        results.put(i++, result);
                        }

			// 切断
			rs.close();
			pstmt.close();
			conn.close();
		}
		catch (Exception ex) {
			ex.printStackTrace();
		}
	}

	public HashMap<Integer, String[]> getResults() {
		return results;
	}

	public void setQ(String q) {
		this.q = q;
	}

        public void setC(String c) {
               this.c = c;
        }



}

こちらをコンパイルすると

movie\Model.java:65: エラー: シンボルを見つけられません
return results;
^
シンボル: 変数 results
場所: クラス Model
エラー1個

と出てしまいます。
正しい形と
なぜシンボルが見つからないのか分かる方いらったいましたらお願いします。

行動規範の内容に同意します

回答2件

ベストアンサー

executeメソッド内にて定義している

java
1HashMap<Integer, String[]> results = new HashMap<Integer, String[]>();

を、クラスのフィールドに移動すれば解決できますね。宣言されている qやcと同じ扱いです。

java
1import java.sql.Connection;
2import java.sql.PreparedStatement;
3import java.sql.ResultSet;
4import java.util.HashMap;
5
6public class Model {
7	private String q;
8	private String c;
9	private Connection conn = null;
10	private PreparedStatement stmt = null;
11	private ResultSet resultSet = null;
12	private HashMap<Integer, TitleListResult> Title_hash;
13	HashMap<Integer, String[]> results = new HashMap<Integer, String[]>();
14	public void execute() {
15		System.out.println("Hello");
16
17		try {
18			conn = ConnectUtilMy.connectDatabase();
19
20			// 住所の検索
21			PreparedStatement pstmt = conn.prepareStatement(
22					"SELECT title_name,years_publication,performance_income,production_cost,public_evaluation,screening_time,genre_name,original_name,cast_n　　　　　　　　　　　　　　ame,directed_name "
23							+
24							"FROM movie inner join original_list on movie.original_number=original_list.original_number "
25							+
26							"inner join genre_list on movie.genre_number=genre_list.genre_number " +
27							"inner join directed_list on movie.directed_number=directed_list.directed_number " +
28							"inner join cast_list on movie.cast_number=cast_list.cast_number where title_name like ? or directed_name 　　　　　　　　　　　　　　like ?");
29			pstmt.setString(1, q + "%");
30			pstmt.setMaxRows(50);
31			ResultSet rs = pstmt.executeQuery();
32
33			// 検索結果の取得
34
35
36			int i = 0;
37			while (rs.next()) {
38				String[] result = new String[10];
39				result[0] = rs.getString("movie_number");
40				result[1] = rs.getString("years_publication");
41				result[2] = rs.getString("performance_income");
42				result[3] = rs.getString("production_cost");
43				result[4] = rs.getString("public_evaluation");
44				result[5] = rs.getString("screening_time");
45				result[6] = rs.getString("genre_number");
46				result[7] = rs.getString("directed_number");
47				result[8] = rs.getString("original_number");
48				result[9] = rs.getString("cast_number");
49				results.put(i++, result);
50			}
51
52			// 切断
53			rs.close();
54			pstmt.close();
55			conn.close();
56		} catch (Exception ex) {
57			ex.printStackTrace();
58		}
59	}
60
61	public HashMap<Integer, String[]> getResults() {
62		return results;
63	}
64
65	public void setQ(String q) {
66		this.q = q;
67	}
68
69	public void setC(String c) {
70		this.c = c;
71	}
72}