全てを再実装したJdbcAcsessです。
Revision | d98e0a9215bf15e7fc0818589e09884cdcd07d5a (tree) |
---|---|
Time | 2012-03-05 00:32:06 |
Author | shimakazuro |
Commiter | shimakazuro |
Eclipseコードスタイル
@@ -1,4 +1,4 @@ | ||
1 | -#Sun Mar 04 22:42:05 JST 2012 | |
1 | +#Mon Mar 05 00:24:12 JST 2012 | |
2 | 2 | eclipse.preferences.version=1 |
3 | 3 | org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled |
4 | 4 | org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.6 |
@@ -17,18 +17,18 @@ | ||
17 | 17 | org.eclipse.jdt.core.formatter.alignment_for_arguments_in_explicit_constructor_call=82 |
18 | 18 | org.eclipse.jdt.core.formatter.alignment_for_arguments_in_method_invocation=82 |
19 | 19 | org.eclipse.jdt.core.formatter.alignment_for_arguments_in_qualified_allocation_expression=82 |
20 | -org.eclipse.jdt.core.formatter.alignment_for_assignment=2 | |
21 | -org.eclipse.jdt.core.formatter.alignment_for_binary_expression=18 | |
20 | +org.eclipse.jdt.core.formatter.alignment_for_assignment=16 | |
21 | +org.eclipse.jdt.core.formatter.alignment_for_binary_expression=16 | |
22 | 22 | org.eclipse.jdt.core.formatter.alignment_for_compact_if=16 |
23 | -org.eclipse.jdt.core.formatter.alignment_for_conditional_expression=82 | |
23 | +org.eclipse.jdt.core.formatter.alignment_for_conditional_expression=16 | |
24 | 24 | org.eclipse.jdt.core.formatter.alignment_for_enum_constants=0 |
25 | -org.eclipse.jdt.core.formatter.alignment_for_expressions_in_array_initializer=18 | |
25 | +org.eclipse.jdt.core.formatter.alignment_for_expressions_in_array_initializer=16 | |
26 | 26 | org.eclipse.jdt.core.formatter.alignment_for_method_declaration=0 |
27 | 27 | org.eclipse.jdt.core.formatter.alignment_for_multiple_fields=16 |
28 | 28 | org.eclipse.jdt.core.formatter.alignment_for_parameters_in_constructor_declaration=16 |
29 | 29 | org.eclipse.jdt.core.formatter.alignment_for_parameters_in_method_declaration=82 |
30 | 30 | org.eclipse.jdt.core.formatter.alignment_for_resources_in_try=80 |
31 | -org.eclipse.jdt.core.formatter.alignment_for_selector_in_method_invocation=2 | |
31 | +org.eclipse.jdt.core.formatter.alignment_for_selector_in_method_invocation=82 | |
32 | 32 | org.eclipse.jdt.core.formatter.alignment_for_superclass_in_type_declaration=16 |
33 | 33 | org.eclipse.jdt.core.formatter.alignment_for_superinterfaces_in_enum_declaration=16 |
34 | 34 | org.eclipse.jdt.core.formatter.alignment_for_superinterfaces_in_type_declaration=16 |
@@ -69,7 +69,7 @@ | ||
69 | 69 | org.eclipse.jdt.core.formatter.comment.indent_root_tags=true |
70 | 70 | org.eclipse.jdt.core.formatter.comment.insert_new_line_before_root_tags=insert |
71 | 71 | org.eclipse.jdt.core.formatter.comment.insert_new_line_for_parameter=insert |
72 | -org.eclipse.jdt.core.formatter.comment.line_length=80 | |
72 | +org.eclipse.jdt.core.formatter.comment.line_length=120 | |
73 | 73 | org.eclipse.jdt.core.formatter.comment.new_lines_at_block_boundaries=true |
74 | 74 | org.eclipse.jdt.core.formatter.comment.new_lines_at_javadoc_boundaries=true |
75 | 75 | org.eclipse.jdt.core.formatter.comment.preserve_white_space_between_code_and_line_comments=false |
@@ -90,7 +90,7 @@ | ||
90 | 90 | org.eclipse.jdt.core.formatter.indent_statements_compare_to_body=true |
91 | 91 | org.eclipse.jdt.core.formatter.indent_switchstatements_compare_to_cases=true |
92 | 92 | org.eclipse.jdt.core.formatter.indent_switchstatements_compare_to_switch=false |
93 | -org.eclipse.jdt.core.formatter.indentation.size=4 | |
93 | +org.eclipse.jdt.core.formatter.indentation.size=2 | |
94 | 94 | org.eclipse.jdt.core.formatter.insert_new_line_after_annotation_on_field=insert |
95 | 95 | org.eclipse.jdt.core.formatter.insert_new_line_after_annotation_on_local_variable=insert |
96 | 96 | org.eclipse.jdt.core.formatter.insert_new_line_after_annotation_on_method=insert |
@@ -98,10 +98,10 @@ | ||
98 | 98 | org.eclipse.jdt.core.formatter.insert_new_line_after_annotation_on_parameter=do not insert |
99 | 99 | org.eclipse.jdt.core.formatter.insert_new_line_after_annotation_on_type=insert |
100 | 100 | org.eclipse.jdt.core.formatter.insert_new_line_after_label=do not insert |
101 | -org.eclipse.jdt.core.formatter.insert_new_line_after_opening_brace_in_array_initializer=do not insert | |
101 | +org.eclipse.jdt.core.formatter.insert_new_line_after_opening_brace_in_array_initializer=insert | |
102 | 102 | org.eclipse.jdt.core.formatter.insert_new_line_at_end_of_file_if_missing=do not insert |
103 | 103 | org.eclipse.jdt.core.formatter.insert_new_line_before_catch_in_try_statement=do not insert |
104 | -org.eclipse.jdt.core.formatter.insert_new_line_before_closing_brace_in_array_initializer=do not insert | |
104 | +org.eclipse.jdt.core.formatter.insert_new_line_before_closing_brace_in_array_initializer=insert | |
105 | 105 | org.eclipse.jdt.core.formatter.insert_new_line_before_else_in_if_statement=do not insert |
106 | 106 | org.eclipse.jdt.core.formatter.insert_new_line_before_finally_in_try_statement=do not insert |
107 | 107 | org.eclipse.jdt.core.formatter.insert_new_line_before_while_in_do_statement=do not insert |
@@ -272,7 +272,7 @@ | ||
272 | 272 | org.eclipse.jdt.core.formatter.insert_space_between_empty_parens_in_method_declaration=do not insert |
273 | 273 | org.eclipse.jdt.core.formatter.insert_space_between_empty_parens_in_method_invocation=do not insert |
274 | 274 | org.eclipse.jdt.core.formatter.join_lines_in_comments=true |
275 | -org.eclipse.jdt.core.formatter.join_wrapped_lines=true | |
275 | +org.eclipse.jdt.core.formatter.join_wrapped_lines=false | |
276 | 276 | org.eclipse.jdt.core.formatter.keep_else_statement_on_same_line=false |
277 | 277 | org.eclipse.jdt.core.formatter.keep_empty_array_initializer_on_one_line=false |
278 | 278 | org.eclipse.jdt.core.formatter.keep_imple_if_on_one_line=false |
@@ -283,7 +283,7 @@ | ||
283 | 283 | org.eclipse.jdt.core.formatter.number_of_blank_lines_at_beginning_of_method_body=0 |
284 | 284 | org.eclipse.jdt.core.formatter.number_of_empty_lines_to_preserve=1 |
285 | 285 | org.eclipse.jdt.core.formatter.put_empty_statement_on_new_line=true |
286 | -org.eclipse.jdt.core.formatter.tabulation.char=space | |
286 | +org.eclipse.jdt.core.formatter.tabulation.char=tab | |
287 | 287 | org.eclipse.jdt.core.formatter.tabulation.size=4 |
288 | 288 | org.eclipse.jdt.core.formatter.use_on_off_tags=false |
289 | 289 | org.eclipse.jdt.core.formatter.use_tabs_only_for_leading_indentations=true |
@@ -1,4 +1,4 @@ | ||
1 | -#Sun Mar 04 22:38:37 JST 2012 | |
1 | +#Mon Mar 05 00:24:14 JST 2012 | |
2 | 2 | cleanup.add_default_serial_version_id=false |
3 | 3 | cleanup.add_generated_serial_version_id=true |
4 | 4 | cleanup.add_missing_annotations=true |
@@ -12,11 +12,11 @@ | ||
12 | 12 | cleanup.always_use_parentheses_in_expressions=false |
13 | 13 | cleanup.always_use_this_for_non_static_field_access=false |
14 | 14 | cleanup.always_use_this_for_non_static_method_access=false |
15 | -cleanup.convert_to_enhanced_for_loop=false | |
16 | -cleanup.correct_indentation=false | |
15 | +cleanup.convert_to_enhanced_for_loop=true | |
16 | +cleanup.correct_indentation=true | |
17 | 17 | cleanup.format_source_code=true |
18 | 18 | cleanup.format_source_code_changes_only=false |
19 | -cleanup.make_local_variable_final=true | |
19 | +cleanup.make_local_variable_final=false | |
20 | 20 | cleanup.make_parameters_final=false |
21 | 21 | cleanup.make_private_fields_final=true |
22 | 22 | cleanup.make_type_abstract_if_missing_method=false |
@@ -71,7 +71,7 @@ | ||
71 | 71 | sp_cleanup.always_use_parentheses_in_expressions=false |
72 | 72 | sp_cleanup.always_use_this_for_non_static_field_access=false |
73 | 73 | sp_cleanup.always_use_this_for_non_static_method_access=false |
74 | -sp_cleanup.convert_to_enhanced_for_loop=false | |
74 | +sp_cleanup.convert_to_enhanced_for_loop=true | |
75 | 75 | sp_cleanup.correct_indentation=true |
76 | 76 | sp_cleanup.format_source_code=true |
77 | 77 | sp_cleanup.format_source_code_changes_only=true |
@@ -95,6 +95,7 @@ | ||
95 | 95 | |
96 | 96 | getRootPane().getActionMap().put("close", new AbstractAction() { |
97 | 97 | private static final long serialVersionUID = -8760955090381970683L; |
98 | + | |
98 | 99 | @Override |
99 | 100 | public void actionPerformed(ActionEvent e) { |
100 | 101 | CodeAssistView.this.setVisible(false); |
@@ -42,243 +42,285 @@ | ||
42 | 42 | |
43 | 43 | public class Config { |
44 | 44 | |
45 | - private static final String CONFIG_DIR = System.getProperty("user.home") + System.getProperty("file.separator") | |
46 | - + ".jdbcacsess2"; | |
47 | - | |
48 | - private static final String CONFIG_DB = "config.derby"; | |
49 | - private static final String CONFIG_JDBCURL = "jdbc:derby:" + CONFIG_DIR + System.getProperty("file.separator") | |
50 | - + CONFIG_DB + ";create=true"; | |
51 | - private static final String CONFIG_JDBCCLASS = "org.apache.derby.jdbc.EmbeddedDriver"; | |
52 | - private static final String USER = ""; | |
53 | - private static final String PASS = ""; | |
54 | - | |
55 | - private final EntityManager entityManager; | |
56 | - | |
57 | - /** | |
58 | - * コンストラクタ | |
59 | - * | |
60 | - * @throws IOException | |
61 | - * @throws ClassNotFoundException | |
62 | - * @throws SQLException | |
63 | - */ | |
64 | - public Config() throws IOException, ClassNotFoundException, SQLException { | |
65 | - | |
66 | - // コンソールとファイルのハンドラーで使用するログフォーマッター | |
67 | - Formatter oneLine = new OneLinenFormatter(); | |
68 | - | |
69 | - // コンソールハンドラー | |
70 | - Handler consoleHandler = new ConsoleHandler(); | |
71 | - consoleHandler.setFormatter(oneLine); | |
72 | - consoleHandler.setLevel(Level.ALL); | |
73 | - | |
74 | - Jdbcacsess2.logger.addHandler(consoleHandler); | |
75 | - Jdbcacsess2.logger.setUseParentHandlers(false); | |
76 | - Jdbcacsess2.loggerActiveObjects.addHandler(consoleHandler); | |
77 | - Jdbcacsess2.loggerActiveObjects.setUseParentHandlers(false); | |
78 | - | |
79 | - // DB作成 | |
80 | - File configDir = new File(CONFIG_DIR); | |
81 | - if (!configDir.exists()) { | |
82 | - if (!configDir.mkdir()) { | |
83 | - throw new IOException("Couldnt create diretrory:" + configDir.getAbsolutePath()); | |
84 | - } | |
85 | - } | |
86 | - | |
87 | - // ログファイルハンドラー | |
88 | - Handler fileHandler = new FileHandler(CONFIG_DIR + File.separator + "message.log", 1024 * 1024, 5); | |
89 | - fileHandler.setFormatter(oneLine); | |
90 | - fileHandler.setLevel(Level.ALL); | |
91 | - | |
92 | - Jdbcacsess2.logger.addHandler(fileHandler); | |
93 | - Jdbcacsess2.loggerActiveObjects.addHandler(fileHandler); | |
94 | - | |
95 | - Jdbcacsess2.logger.info("file logger start"); | |
96 | - Jdbcacsess2.logger.info("configure directory:" + CONFIG_DIR); | |
97 | - | |
98 | - // システムプロパティを表示する | |
99 | - if (Jdbcacsess2.logger.isLoggable(Level.FINE)) { | |
100 | - Properties prop = System.getProperties(); | |
101 | - ArrayList<String> aList = Collections.list(extracted(prop)); | |
102 | - Collections.sort(aList); | |
103 | - | |
104 | - for (Iterator<String> iterator = aList.iterator(); iterator.hasNext();) { | |
105 | - String string = iterator.next(); | |
106 | - Jdbcacsess2.logger.fine(string + ":" + System.getProperty(string)); | |
107 | - } | |
108 | - } else { | |
109 | - Jdbcacsess2.logger.info(System.getProperty("java.vm.vendor") + " " + System.getProperty("java.vm.name") | |
110 | - + " " + System.getProperty("java.vm.version")); | |
111 | - Jdbcacsess2.logger.info(System.getProperty("java.home")); | |
112 | - Jdbcacsess2.logger.info(System.getProperty("java.class.path")); | |
113 | - Jdbcacsess2.logger.info(System.getProperty("java.library.path")); | |
114 | - Jdbcacsess2.logger.info(System.getProperty("java.ext.dirs")); | |
115 | - } | |
116 | - | |
117 | - // ActibObjectsの初期設定 | |
118 | - Class.forName(CONFIG_JDBCCLASS); | |
119 | - | |
120 | - this.entityManager = new EntityManager(CONFIG_JDBCURL, USER, PASS); | |
121 | - Jdbcacsess2.loggerActiveObjects.setLevel(Level.WARNING); | |
122 | - // Jdbcacsess2.loggerActiveObjects.setLevel(Level.FINE); | |
123 | - | |
124 | - migrate(); | |
125 | - setUpConfigDbms(); | |
126 | - | |
127 | - Jdbcacsess2.logger.info("Config end"); | |
128 | - } | |
129 | - | |
130 | - @SuppressWarnings("unchecked") | |
131 | - private Enumeration<String> extracted(Properties prop) { | |
132 | - return (Enumeration<String>) prop.propertyNames(); | |
133 | - } | |
134 | - | |
135 | - /** | |
136 | - * ActiveObjects の migrate を呼ぶ。SuppressWarningsでワーニングを抑止する為にメソッド抽出。 | |
137 | - * | |
138 | - * @throws SQLException | |
139 | - */ | |
140 | - @SuppressWarnings("unchecked") | |
141 | - private void migrate() throws SQLException { | |
142 | - getEntityManager().migrate(ConfigDbms.class, | |
143 | - ConfigConnect.class, | |
144 | - ConnectView.ConfigViewConnect.class, | |
145 | - MainView.ConfigViewMain.class, | |
146 | - ExecHistory.class); | |
147 | - } | |
148 | - | |
149 | - /** | |
150 | - * {@link ConfigDbms#DBMSNAME}カラム順のDBMSの一覧 | |
151 | - * | |
152 | - * @return {@link ConfigDbms}の配列 | |
153 | - * @throws SQLException | |
154 | - */ | |
155 | - public ConfigDbms[] getConfigDbms() throws SQLException { | |
156 | - return getEntityManager().find(ConfigDbms.class, Query.select().order(ConfigDbms.DBMSNAME)); | |
157 | - } | |
45 | + private static final String CONFIG_DIR = System.getProperty("user.home") + System.getProperty("file.separator") | |
46 | + + ".jdbcacsess2"; | |
158 | 47 | |
159 | - /** | |
160 | - * {@link ConfigConnect#CONNECTNAME}カラム順の接続情報の一覧 | |
161 | - * | |
162 | - * @return {@link ConfigConnect}の配列 | |
163 | - * @throws SQLException | |
164 | - */ | |
165 | - public ConfigConnect[] getConfigConnect() throws SQLException { | |
166 | - return getEntityManager().find(ConfigConnect.class, Query.select()); | |
167 | - } | |
168 | - | |
169 | - /** | |
170 | - * 接続名称で検索し、存在する・しないに関わらず、保存用の{@link ConfigConnect}を返却します。 | |
171 | - * | |
172 | - * @param connectName | |
173 | - * 接続名称 | |
174 | - * @return データがあった場合は検索結果の{@link ConfigConnect}、なかった場合は挿入用の | |
175 | - * {@link ConfigConnect} | |
176 | - * @throws SQLException | |
177 | - */ | |
178 | - public ConfigConnect getConfigConnectRow(String connectName) throws SQLException { | |
179 | - ConfigConnect[] configConnects = getEntityManager().find(ConfigConnect.class, | |
180 | - Query.select().where(ConfigConnect.CONNECTNAME + "=?", | |
181 | - connectName)); | |
182 | - | |
183 | - ConfigConnect rtn; | |
184 | - if (configConnects.length == 0l) { | |
185 | - rtn = getEntityManager().create(ConfigConnect.class, new DBParam(ConfigConnect.CONNECTNAME, connectName)); | |
186 | - } else { | |
187 | - rtn = configConnects[0]; | |
188 | - } | |
189 | - return rtn; | |
190 | - } | |
191 | - | |
192 | - /** | |
193 | - * component属性を保管するテーブル検索し、先頭1件だけに絞る。 | |
194 | - * | |
195 | - * @param <T> | |
196 | - * @param <K> | |
197 | - * @param type | |
198 | - * 検索対象componentのテーブルクラス | |
199 | - * @return データが存在しない時は、 | |
200 | - * {@link EntityManager#create(Class, net.java.ao.DBParam...)} | |
201 | - * を実行し空行を取得します。 | |
202 | - * @throws SQLException | |
203 | - */ | |
204 | - public <T extends RawEntity<K>, K> T getConfigWindow(Class<T> type) throws SQLException { | |
205 | - T[] e = getEntityManager().find(type); | |
206 | - if (e.length != 0) { | |
207 | - return e[0]; | |
208 | - } | |
209 | - return getEntityManager().create(type); | |
210 | - } | |
48 | + private static final String CONFIG_DB = "config.derby"; | |
49 | + private static final String CONFIG_JDBCURL = "jdbc:derby:" + CONFIG_DIR + System.getProperty("file.separator") | |
50 | + + CONFIG_DB + ";create=true"; | |
51 | + private static final String CONFIG_JDBCCLASS = "org.apache.derby.jdbc.EmbeddedDriver"; | |
52 | + private static final String USER = ""; | |
53 | + private static final String PASS = ""; | |
211 | 54 | |
212 | - /** | |
213 | - * @throws SQLException | |
214 | - */ | |
215 | - private void setUpConfigDbms() throws SQLException { | |
216 | - String[] colnames = { ConfigDbms.DBMSNAME, ConfigDbms.SUBPROTOCOL, ConfigDbms.SUBNAME, ConfigDbms.DRIVERCLASS, | |
217 | - ConfigDbms.URLOPTION }; | |
218 | - String[][] rows = { | |
219 | - { "PostgreSQL", "postgresql", "//%HostName%%PortNumber%/%DataBaseName%", | |
220 | - "org.postgresql.Driver", "" }, | |
221 | - { "MySQL", "mysql", "//%HostName%%PortNumber%/%DataBaseName%", "org.gjt.mm.mysql.Driver", "" }, | |
222 | - { "MySQL(com)", "mysql", "//%HostName%%PortNumber%/%DataBaseName%", "com.mysql.jdbc.Driver", | |
223 | - "" }, | |
224 | - { "HSQL", "hsqldb:hsql", "//%HostName%%PortNumber%/%DataBaseName%", "org.hsqldb.jdbcDriver", | |
225 | - "" }, | |
226 | - { "Oracle(TYPE4:Pure Java)", "oracle:thin", "@%HostName%%PortNumber%:%DataBaseName%", | |
227 | - "oracle.jdbc.driver.OracleDriver", "" }, | |
228 | - { "Oracle(TYPE2:NET)", "oracle:oci", "@%DataBaseName%", "oracle.jdbc.driver.OracleDriver", | |
229 | - "" }, | |
230 | - { "Oracle(TYPE2:NET8)", "oracle:oci8", "@%DataBaseName%", "oracle.jdbc.driver.OracleDriver", | |
231 | - "" }, | |
232 | - { "DB2(TYPE4:Universal)", "db2", "//%HostName%%PortNumber%/%DataBaseName%", | |
233 | - "com.ibm.db2.jcc.DB2Driver", "" }, | |
234 | - { "DB2(TYPE2:Universal)", "db2", "%DataBaseName%", "com.ibm.db2.jcc.DB2Driver", "" }, | |
235 | - { "DB2(TYPE2:App)", "db2", "%DataBaseName%", "COM.ibm.db2.jdbc.app.DB2Driver", "" }, | |
236 | - { "DB2(TYPE3:Net)", "db2", "//%HostName%%PortNumber%/%DataBaseName%", | |
237 | - "COM.ibm.db2.jdbc.net.DB2Driver", "" }, | |
238 | - { "SQL Server", "sqlserver", "//%HostName%%PortNumber%;databaseName=%DataBaseName%", | |
239 | - "com.microsoft.sqlserver.jdbc.SQLServerDriver", "" }, | |
240 | - { "SQL Server(2000)", "microsoft:sqlserver", | |
241 | - "//%HostName%%PortNumber%;databaseName=%DataBaseName%", | |
242 | - "com.microsoft.jdbc.sqlserver.SQLServerDriver", "" }, | |
243 | - { "Derby(Embedded)", "derby", "%DataBaseName%", "org.apache.derby.jdbc.EmbeddedDriver", "" }, | |
244 | - { "Derby(Client)", "derby", "%DataBaseName%", "org.apache.derby.jdbc.ClientDriver", "" }, | |
245 | - { "SQLite", "sqlite", "/%DataBaseName%", "org.sqlite.JDBC", "" }, | |
246 | - { "Firebird", "firebirdsql", "//%HostName%%PortNumber%/%DataBaseName%", | |
247 | - "org.firebirdsql.jdbc.FBDriver", "" }, | |
248 | - { "Symfoware", "symford", "//%HostName%%PortNumber%/%DataBaseName%", | |
249 | - "com.fujitsu.symfoware.jdbc.SYMDriver", "" }, | |
250 | - { "HiRDB", "hitachi:hirdb", "//DBID=%PortNumberRAW%,DBHOST=%HostName%", | |
251 | - "JP.co.Hitachi.soft.HiRDB.JDBC.HiRDBDriver", "" }, | |
252 | - { "ODBC(TYPE1)", "odbc", "%DataBaseName%", "sun.jdbc.odbc.JdbcOdbcDriver", "" }, | |
253 | - { "free format", "", "", "", "" } }; | |
55 | + private final EntityManager entityManager; | |
254 | 56 | |
255 | - for (int i = 0; i < rows.length; i++) { | |
256 | - ConfigDbms[] dbms = getEntityManager().find(ConfigDbms.class, | |
257 | - Query.select().where(ConfigDbms.DBMSNAME + "=?", rows[i][0])); | |
258 | - if (dbms.length == 0) { | |
259 | - Map<String, Object> m = new HashMap<String, Object>(); | |
260 | - for (int j = 0; j < colnames.length; j++) { | |
261 | - m.put(colnames[j], rows[i][j]); | |
262 | - } | |
263 | - getEntityManager().create(ConfigDbms.class, m); | |
264 | - Jdbcacsess2.logger.info("not exists:" + rows[i][0]); | |
265 | - } | |
266 | - } | |
267 | - } | |
57 | + /** | |
58 | + * コンストラクタ | |
59 | + * | |
60 | + * @throws IOException | |
61 | + * @throws ClassNotFoundException | |
62 | + * @throws SQLException | |
63 | + */ | |
64 | + public Config() throws IOException, ClassNotFoundException, SQLException { | |
268 | 65 | |
269 | - /** | |
270 | - * 設定情報保管用のDBをクローズ | |
271 | - */ | |
272 | - public void close() { | |
273 | - getEntityManager().flushAll(); | |
274 | - getEntityManager().getProvider().dispose(); | |
275 | - } | |
66 | + // コンソールとファイルのハンドラーで使用するログフォーマッター | |
67 | + Formatter oneLine = new OneLinenFormatter(); | |
276 | 68 | |
277 | - /** | |
278 | - * @return entityManager | |
279 | - */ | |
280 | - public EntityManager getEntityManager() { | |
281 | - return entityManager; | |
282 | - } | |
69 | + // コンソールハンドラー | |
70 | + Handler consoleHandler = new ConsoleHandler(); | |
71 | + consoleHandler.setFormatter(oneLine); | |
72 | + consoleHandler.setLevel(Level.ALL); | |
73 | + | |
74 | + Jdbcacsess2.logger.addHandler(consoleHandler); | |
75 | + Jdbcacsess2.logger.setUseParentHandlers(false); | |
76 | + Jdbcacsess2.loggerActiveObjects.addHandler(consoleHandler); | |
77 | + Jdbcacsess2.loggerActiveObjects.setUseParentHandlers(false); | |
78 | + | |
79 | + // DB作成 | |
80 | + File configDir = new File(CONFIG_DIR); | |
81 | + if (!configDir.exists()) { | |
82 | + if (!configDir.mkdir()) { | |
83 | + throw new IOException("Couldnt create diretrory:" + configDir.getAbsolutePath()); | |
84 | + } | |
85 | + } | |
86 | + | |
87 | + // ログファイルハンドラー | |
88 | + Handler fileHandler = new FileHandler(CONFIG_DIR + File.separator + "message.log", 1024 * 1024, 5); | |
89 | + fileHandler.setFormatter(oneLine); | |
90 | + fileHandler.setLevel(Level.ALL); | |
91 | + | |
92 | + Jdbcacsess2.logger.addHandler(fileHandler); | |
93 | + Jdbcacsess2.loggerActiveObjects.addHandler(fileHandler); | |
94 | + | |
95 | + Jdbcacsess2.logger.info("file logger start"); | |
96 | + Jdbcacsess2.logger.info("configure directory:" + CONFIG_DIR); | |
97 | + | |
98 | + // システムプロパティを表示する | |
99 | + if (Jdbcacsess2.logger.isLoggable(Level.FINE)) { | |
100 | + Properties prop = System.getProperties(); | |
101 | + ArrayList<String> aList = Collections.list(extracted(prop)); | |
102 | + Collections.sort(aList); | |
103 | + | |
104 | + for (Iterator<String> iterator = aList.iterator(); iterator.hasNext();) { | |
105 | + String string = iterator.next(); | |
106 | + Jdbcacsess2.logger.fine(string + ":" + System.getProperty(string)); | |
107 | + } | |
108 | + } else { | |
109 | + Jdbcacsess2.logger.info(System.getProperty("java.vm.vendor") + " " + System.getProperty("java.vm.name") | |
110 | + + " " + System.getProperty("java.vm.version")); | |
111 | + Jdbcacsess2.logger.info(System.getProperty("java.home")); | |
112 | + Jdbcacsess2.logger.info(System.getProperty("java.class.path")); | |
113 | + Jdbcacsess2.logger.info(System.getProperty("java.library.path")); | |
114 | + Jdbcacsess2.logger.info(System.getProperty("java.ext.dirs")); | |
115 | + } | |
116 | + | |
117 | + // ActibObjectsの初期設定 | |
118 | + Class.forName(CONFIG_JDBCCLASS); | |
119 | + | |
120 | + this.entityManager = new EntityManager(CONFIG_JDBCURL, USER, PASS); | |
121 | + Jdbcacsess2.loggerActiveObjects.setLevel(Level.WARNING); | |
122 | + // Jdbcacsess2.loggerActiveObjects.setLevel(Level.FINE); | |
123 | + | |
124 | + migrate(); | |
125 | + setUpConfigDbms(); | |
126 | + | |
127 | + Jdbcacsess2.logger.info("Config end"); | |
128 | + } | |
129 | + | |
130 | + @SuppressWarnings("unchecked") | |
131 | + private Enumeration<String> extracted(Properties prop) { | |
132 | + return (Enumeration<String>) prop.propertyNames(); | |
133 | + } | |
134 | + | |
135 | + /** | |
136 | + * ActiveObjects の migrate を呼ぶ。SuppressWarningsでワーニングを抑止する為にメソッド抽出。 | |
137 | + * | |
138 | + * @throws SQLException | |
139 | + */ | |
140 | + @SuppressWarnings("unchecked") | |
141 | + private void migrate() throws SQLException { | |
142 | + getEntityManager().migrate(ConfigDbms.class, | |
143 | + ConfigConnect.class, | |
144 | + ConnectView.ConfigViewConnect.class, | |
145 | + MainView.ConfigViewMain.class, | |
146 | + ExecHistory.class); | |
147 | + } | |
148 | + | |
149 | + /** | |
150 | + * {@link ConfigDbms#DBMSNAME}カラム順のDBMSの一覧 | |
151 | + * | |
152 | + * @return {@link ConfigDbms}の配列 | |
153 | + * @throws SQLException | |
154 | + */ | |
155 | + public ConfigDbms[] getConfigDbms() throws SQLException { | |
156 | + return getEntityManager().find(ConfigDbms.class, Query.select().order(ConfigDbms.DBMSNAME)); | |
157 | + } | |
158 | + | |
159 | + /** | |
160 | + * {@link ConfigConnect#CONNECTNAME}カラム順の接続情報の一覧 | |
161 | + * | |
162 | + * @return {@link ConfigConnect}の配列 | |
163 | + * @throws SQLException | |
164 | + */ | |
165 | + public ConfigConnect[] getConfigConnect() throws SQLException { | |
166 | + return getEntityManager().find(ConfigConnect.class, Query.select()); | |
167 | + } | |
168 | + | |
169 | + /** | |
170 | + * 接続名称で検索し、存在する・しないに関わらず、保存用の{@link ConfigConnect}を返却します。 | |
171 | + * | |
172 | + * @param connectName | |
173 | + * 接続名称 | |
174 | + * @return データがあった場合は検索結果の{@link ConfigConnect}、なかった場合は挿入用の {@link ConfigConnect} | |
175 | + * @throws SQLException | |
176 | + */ | |
177 | + public ConfigConnect getConfigConnectRow(String connectName) throws SQLException { | |
178 | + ConfigConnect[] configConnects = getEntityManager().find(ConfigConnect.class, | |
179 | + Query.select().where(ConfigConnect.CONNECTNAME + "=?", | |
180 | + connectName)); | |
181 | + | |
182 | + ConfigConnect rtn; | |
183 | + if (configConnects.length == 0l) { | |
184 | + rtn = getEntityManager().create(ConfigConnect.class, new DBParam(ConfigConnect.CONNECTNAME, connectName)); | |
185 | + } else { | |
186 | + rtn = configConnects[0]; | |
187 | + } | |
188 | + return rtn; | |
189 | + } | |
190 | + | |
191 | + /** | |
192 | + * component属性を保管するテーブル検索し、先頭1件だけに絞る。 | |
193 | + * | |
194 | + * @param <T> | |
195 | + * @param <K> | |
196 | + * @param type | |
197 | + * 検索対象componentのテーブルクラス | |
198 | + * @return データが存在しない時は、 {@link EntityManager#create(Class, net.java.ao.DBParam...)} を実行し空行を取得します。 | |
199 | + * @throws SQLException | |
200 | + */ | |
201 | + public <T extends RawEntity<K>, K> T getConfigWindow(Class<T> type) throws SQLException { | |
202 | + T[] e = getEntityManager().find(type); | |
203 | + if (e.length != 0) { | |
204 | + return e[0]; | |
205 | + } | |
206 | + return getEntityManager().create(type); | |
207 | + } | |
208 | + | |
209 | + /** | |
210 | + * @throws SQLException | |
211 | + */ | |
212 | + private void setUpConfigDbms() throws SQLException { | |
213 | + String[] colnames = { | |
214 | + ConfigDbms.DBMSNAME, ConfigDbms.SUBPROTOCOL, ConfigDbms.SUBNAME, ConfigDbms.DRIVERCLASS, | |
215 | + ConfigDbms.URLOPTION | |
216 | + }; | |
217 | + String[][] rows = { | |
218 | + { | |
219 | + "PostgreSQL", "postgresql", "//%HostName%%PortNumber%/%DataBaseName%", | |
220 | + "org.postgresql.Driver", "" | |
221 | + }, | |
222 | + { | |
223 | + "MySQL", "mysql", "//%HostName%%PortNumber%/%DataBaseName%", "org.gjt.mm.mysql.Driver", "" | |
224 | + }, | |
225 | + { | |
226 | + "MySQL(com)", "mysql", "//%HostName%%PortNumber%/%DataBaseName%", "com.mysql.jdbc.Driver", | |
227 | + "" | |
228 | + }, | |
229 | + { | |
230 | + "HSQL", "hsqldb:hsql", "//%HostName%%PortNumber%/%DataBaseName%", "org.hsqldb.jdbcDriver", | |
231 | + "" | |
232 | + }, | |
233 | + { | |
234 | + "Oracle(TYPE4:Pure Java)", "oracle:thin", "@%HostName%%PortNumber%:%DataBaseName%", | |
235 | + "oracle.jdbc.driver.OracleDriver", "" | |
236 | + }, | |
237 | + { | |
238 | + "Oracle(TYPE2:NET)", "oracle:oci", "@%DataBaseName%", "oracle.jdbc.driver.OracleDriver", | |
239 | + "" | |
240 | + }, | |
241 | + { | |
242 | + "Oracle(TYPE2:NET8)", "oracle:oci8", "@%DataBaseName%", "oracle.jdbc.driver.OracleDriver", | |
243 | + "" | |
244 | + }, | |
245 | + { | |
246 | + "DB2(TYPE4:Universal)", "db2", "//%HostName%%PortNumber%/%DataBaseName%", | |
247 | + "com.ibm.db2.jcc.DB2Driver", "" | |
248 | + }, | |
249 | + { | |
250 | + "DB2(TYPE2:Universal)", "db2", "%DataBaseName%", "com.ibm.db2.jcc.DB2Driver", "" | |
251 | + }, | |
252 | + { | |
253 | + "DB2(TYPE2:App)", "db2", "%DataBaseName%", "COM.ibm.db2.jdbc.app.DB2Driver", "" | |
254 | + }, | |
255 | + { | |
256 | + "DB2(TYPE3:Net)", "db2", "//%HostName%%PortNumber%/%DataBaseName%", | |
257 | + "COM.ibm.db2.jdbc.net.DB2Driver", "" | |
258 | + }, | |
259 | + { | |
260 | + "SQL Server", "sqlserver", "//%HostName%%PortNumber%;databaseName=%DataBaseName%", | |
261 | + "com.microsoft.sqlserver.jdbc.SQLServerDriver", "" | |
262 | + }, | |
263 | + { | |
264 | + "SQL Server(2000)", "microsoft:sqlserver", | |
265 | + "//%HostName%%PortNumber%;databaseName=%DataBaseName%", | |
266 | + "com.microsoft.jdbc.sqlserver.SQLServerDriver", "" | |
267 | + }, | |
268 | + { | |
269 | + "Derby(Embedded)", "derby", "%DataBaseName%", "org.apache.derby.jdbc.EmbeddedDriver", "" | |
270 | + }, | |
271 | + { | |
272 | + "Derby(Client)", "derby", "%DataBaseName%", "org.apache.derby.jdbc.ClientDriver", "" | |
273 | + }, | |
274 | + { | |
275 | + "SQLite", "sqlite", "/%DataBaseName%", "org.sqlite.JDBC", "" | |
276 | + }, | |
277 | + { | |
278 | + "Firebird", "firebirdsql", "//%HostName%%PortNumber%/%DataBaseName%", | |
279 | + "org.firebirdsql.jdbc.FBDriver", "" | |
280 | + }, | |
281 | + { | |
282 | + "Symfoware", "symford", "//%HostName%%PortNumber%/%DataBaseName%", | |
283 | + "com.fujitsu.symfoware.jdbc.SYMDriver", "" | |
284 | + }, | |
285 | + { | |
286 | + "HiRDB", "hitachi:hirdb", "//DBID=%PortNumberRAW%,DBHOST=%HostName%", | |
287 | + "JP.co.Hitachi.soft.HiRDB.JDBC.HiRDBDriver", "" | |
288 | + }, | |
289 | + { | |
290 | + "ODBC(TYPE1)", "odbc", "%DataBaseName%", "sun.jdbc.odbc.JdbcOdbcDriver", "" | |
291 | + }, | |
292 | + { | |
293 | + "free format", "", "", "", "" | |
294 | + } | |
295 | + }; | |
296 | + | |
297 | + for (int i = 0; i < rows.length; i++) { | |
298 | + ConfigDbms[] dbms = getEntityManager().find(ConfigDbms.class, | |
299 | + Query.select().where(ConfigDbms.DBMSNAME + "=?", rows[i][0])); | |
300 | + if (dbms.length == 0) { | |
301 | + Map<String, Object> m = new HashMap<String, Object>(); | |
302 | + for (int j = 0; j < colnames.length; j++) { | |
303 | + m.put(colnames[j], rows[i][j]); | |
304 | + } | |
305 | + getEntityManager().create(ConfigDbms.class, m); | |
306 | + Jdbcacsess2.logger.info("not exists:" + rows[i][0]); | |
307 | + } | |
308 | + } | |
309 | + } | |
310 | + | |
311 | + /** | |
312 | + * 設定情報保管用のDBをクローズ | |
313 | + */ | |
314 | + public void close() { | |
315 | + getEntityManager().flushAll(); | |
316 | + getEntityManager().getProvider().dispose(); | |
317 | + } | |
318 | + | |
319 | + /** | |
320 | + * @return entityManager | |
321 | + */ | |
322 | + public EntityManager getEntityManager() { | |
323 | + return entityManager; | |
324 | + } | |
283 | 325 | |
284 | 326 | } |
@@ -25,7 +25,7 @@ | ||
25 | 25 | |
26 | 26 | /** |
27 | 27 | * @author sima |
28 | - * | |
28 | + * | |
29 | 29 | */ |
30 | 30 | public class FontZoom { |
31 | 31 |
@@ -67,19 +67,17 @@ | ||
67 | 67 | /* |
68 | 68 | * (非 Javadoc) |
69 | 69 | * |
70 | - * @see | |
71 | - * java.awt.event.MouseWheelListener#mouseWheelMoved(java.awt.event. | |
72 | - * MouseWheelEvent) | |
70 | + * @see java.awt.event.MouseWheelListener#mouseWheelMoved(java.awt.event. MouseWheelEvent) | |
73 | 71 | */ |
74 | 72 | @Override |
75 | 73 | public void mouseWheelMoved(MouseWheelEvent e) { |
76 | 74 | if (!e.isControlDown()) { |
77 | 75 | return; |
78 | 76 | } |
79 | - Component c = e.getComponent(); | |
77 | + final Component c = e.getComponent(); | |
80 | 78 | |
81 | - Font font = c.getFont(); | |
82 | - float size = font.getSize() + (e.getWheelRotation() * -1); | |
79 | + final Font font = c.getFont(); | |
80 | + final float size = font.getSize() + (e.getWheelRotation() * -1); | |
83 | 81 | if (4 < size && size < 30) { |
84 | 82 | c.setFont(font.deriveFont(size)); |
85 | 83 | } |
@@ -121,11 +121,11 @@ | ||
121 | 121 | |
122 | 122 | super.getTreeCellRendererComponent(tree, |
123 | 123 | o.isCaching() ? "LOADONG... " + o.getSummary() : o.getSummary(), |
124 | - selected, | |
125 | - expanded, | |
126 | - leaf, | |
127 | - row, | |
128 | - hasFocus); | |
124 | + selected, | |
125 | + expanded, | |
126 | + leaf, | |
127 | + row, | |
128 | + hasFocus); | |
129 | 129 | return this; |
130 | 130 | } |
131 | 131 | } |
@@ -154,7 +154,8 @@ | ||
154 | 154 | SwingUtilities.invokeLater(new Runnable() { |
155 | 155 | @Override |
156 | 156 | public void run() { |
157 | - DefaultTreeTableModel treeTableModel = (DefaultTreeTableModel) getJXTreetableDBObjects().getTreeTableModel(); | |
157 | + DefaultTreeTableModel treeTableModel = | |
158 | + (DefaultTreeTableModel) getJXTreetableDBObjects().getTreeTableModel(); | |
158 | 159 | |
159 | 160 | for (DBObject dbObject : dbObjects.getDBObjects()) { |
160 | 161 | DBobjectMutableTreeTableNode child = new DBobjectMutableTreeTableNode(dbObject, |
@@ -57,7 +57,7 @@ | ||
57 | 57 | import org.fife.ui.rtextarea.RTextScrollPane; |
58 | 58 | |
59 | 59 | public class JPanelSql extends JPanel implements SqlExecutedListener, DataBaseConnectionListener, |
60 | -DataBaseTransactionListener { | |
60 | + DataBaseTransactionListener { | |
61 | 61 | |
62 | 62 | // ------------------------------------------------------------------------- |
63 | 63 | // ------------------------------------------------------------------------- |
@@ -72,8 +72,7 @@ | ||
72 | 72 | /* |
73 | 73 | * (非 Javadoc) |
74 | 74 | * |
75 | - * @see | |
76 | - * jdbcacsess2.sqlService.DataBaseConnectionListener#dataBaseConnectionOpened | |
75 | + * @see jdbcacsess2.sqlService.DataBaseConnectionListener#dataBaseConnectionOpened | |
77 | 76 | * (jdbcacsess2.sqlService.DataBaseConnection) |
78 | 77 | */ |
79 | 78 | @Override |
@@ -105,9 +104,7 @@ | ||
105 | 104 | /* |
106 | 105 | * (非 Javadoc) |
107 | 106 | * |
108 | - * @see | |
109 | - * jdbcacsess2.sqlService.DataBaseConnectionListener#dataBaseConnectionClosing | |
110 | - * () | |
107 | + * @see jdbcacsess2.sqlService.DataBaseConnectionListener#dataBaseConnectionClosing () | |
111 | 108 | */ |
112 | 109 | @Override |
113 | 110 | public void dataBaseConnectionClosing(DataBaseConnection dataBaseConnection) { |
@@ -127,9 +124,7 @@ | ||
127 | 124 | /* |
128 | 125 | * (非 Javadoc) |
129 | 126 | * |
130 | - * @see | |
131 | - * jdbcacsess2.sqlService.DataBaseConnectionListener#dataBaseConnectionClosed | |
132 | - * () | |
127 | + * @see jdbcacsess2.sqlService.DataBaseConnectionListener#dataBaseConnectionClosed () | |
133 | 128 | */ |
134 | 129 | @Override |
135 | 130 | public void dataBaseConnectionClosed(DataBaseConnection dataBaseConnection) { |
@@ -151,9 +146,7 @@ | ||
151 | 146 | /* |
152 | 147 | * (非 Javadoc) |
153 | 148 | * |
154 | - * @see | |
155 | - * jdbcacsess2.sqlService.DataBaseTransactionListener#autoCommitChange(boolean | |
156 | - * ) | |
149 | + * @see jdbcacsess2.sqlService.DataBaseTransactionListener#autoCommitChange(boolean ) | |
157 | 150 | */ |
158 | 151 | @Override |
159 | 152 | public void autoCommitChange(DataBaseConnection dataBaseConnection, final boolean autoCommit) { |
@@ -291,12 +284,11 @@ | ||
291 | 284 | * 例外発生時に処理を継続するか |
292 | 285 | */ |
293 | 286 | private boolean exceptionContinue; |
287 | + | |
294 | 288 | /* |
295 | 289 | * (非 Javadoc) |
296 | 290 | * |
297 | - * @see | |
298 | - * jdbcacsess2.sqlService.SqlExecutedListener#taskAccept(jdbcacsess2.sqlService | |
299 | - * .SqlExecuteTask) | |
291 | + * @see jdbcacsess2.sqlService.SqlExecutedListener#taskAccept(jdbcacsess2.sqlService .SqlExecuteTask) | |
300 | 292 | */ |
301 | 293 | @Override |
302 | 294 | public void taskAccept(SqlExecuteTask sqlExecuteTask) { |
@@ -316,8 +308,7 @@ | ||
316 | 308 | /* |
317 | 309 | * (非 Javadoc) |
318 | 310 | * |
319 | - * @see | |
320 | - * jdbcacsess2.sqlService.SqlExecutedListener#executBegin(jdbcacsess2.sqlService | |
311 | + * @see jdbcacsess2.sqlService.SqlExecutedListener#executBegin(jdbcacsess2.sqlService | |
321 | 312 | * .SqlExecuteSentencies.SqlExecuteSentence) |
322 | 313 | */ |
323 | 314 | @Override |
@@ -337,7 +328,7 @@ | ||
337 | 328 | } |
338 | 329 | |
339 | 330 | writeGuiLog("\nstart sql\n" |
340 | - + sqlExecuteSentence.getSqlSentence()); | |
331 | + + sqlExecuteSentence.getSqlSentence()); | |
341 | 332 | } |
342 | 333 | }); |
343 | 334 | } |
@@ -357,8 +348,8 @@ | ||
357 | 348 | public void run() { |
358 | 349 | getJToggleButtonExecution().setEnabled(true); |
359 | 350 | writeGuiLog("normal end sql" + counrMessage + " " |
360 | - + Integer.toString(rowCnt) + " row " + sqlExecuteTask.getExecutionTime() | |
361 | - + "ms"); | |
351 | + + Integer.toString(rowCnt) + " row " + sqlExecuteTask.getExecutionTime() | |
352 | + + "ms"); | |
362 | 353 | } |
363 | 354 | }); |
364 | 355 | } |
@@ -366,9 +357,7 @@ | ||
366 | 357 | /* |
367 | 358 | * (非 Javadoc) |
368 | 359 | * |
369 | - * @see | |
370 | - * jdbcacsess2.sqlService.SqlExecutedListener#executeException(java.lang | |
371 | - * .Throwable) | |
360 | + * @see jdbcacsess2.sqlService.SqlExecutedListener#executeException(java.lang .Throwable) | |
372 | 361 | */ |
373 | 362 | @Override |
374 | 363 | public void executeException(final Throwable t) { |
@@ -380,7 +369,7 @@ | ||
380 | 369 | public void run() { |
381 | 370 | getJToggleButtonExecution().setEnabled(true); |
382 | 371 | writeGuiLog("abnormal end " + counrMessage + "\n " |
383 | - + t.getLocalizedMessage()); | |
372 | + + t.getLocalizedMessage()); | |
384 | 373 | } |
385 | 374 | }); |
386 | 375 | ShowDialog.errorMessage(t); |
@@ -391,7 +380,9 @@ | ||
391 | 380 | SwingUtilities.invokeAndWait(new Runnable() { |
392 | 381 | @Override |
393 | 382 | public void run() { |
394 | - Object[] options = { "はい、後続のSQL実行を中断", "いいえ、以降の全エラーを無視" }; | |
383 | + Object[] options = { | |
384 | + "はい、後続のSQL実行を中断", "いいえ、以降の全エラーを無視" | |
385 | + }; | |
395 | 386 | int n = JOptionPane.showOptionDialog(null, |
396 | 387 | "残りのSQL実行は中断しますか?", |
397 | 388 | "まだ実行予定のSQLが残ってます", |
@@ -423,8 +414,7 @@ | ||
423 | 414 | /* |
424 | 415 | * (非 Javadoc) |
425 | 416 | * |
426 | - * @see | |
427 | - * jdbcacsess2.sqlService.SqlExecutedListener#resultHeader(java.util.List) | |
417 | + * @see jdbcacsess2.sqlService.SqlExecutedListener#resultHeader(java.util.List) | |
428 | 418 | */ |
429 | 419 | @Override |
430 | 420 | public void resultHeader(final List<ColumnAttributeResult> header) { |
@@ -440,8 +430,7 @@ | ||
440 | 430 | /* |
441 | 431 | * (非 Javadoc) |
442 | 432 | * |
443 | - * @see jdbcacsess2.sqlService.SqlExecutedListener#resultDetail(int, | |
444 | - * java.util.List) | |
433 | + * @see jdbcacsess2.sqlService.SqlExecutedListener#resultDetail(int, java.util.List) | |
445 | 434 | */ |
446 | 435 | @Override |
447 | 436 | public void resultDetail(int seq, List<Object> detail) { |
@@ -34,7 +34,7 @@ | ||
34 | 34 | |
35 | 35 | /** |
36 | 36 | * @author sima |
37 | - * | |
37 | + * | |
38 | 38 | */ |
39 | 39 | public class JmyTable extends JXTable { |
40 | 40 |
@@ -173,8 +173,10 @@ | ||
173 | 173 | sql = jPanelSql.getRSyntaxTextAreaSql().getText(); |
174 | 174 | } |
175 | 175 | |
176 | - SqlAsyncExecute sqlAsyncExecute = new SqlAsyncExecute(sql, | |
177 | - ((SentenceSeparator) jPanelSql.getJComboBoxSentenceSeparator().getSelectedItem()).getRegVal()); | |
176 | + SqlAsyncExecute sqlAsyncExecute = | |
177 | + new SqlAsyncExecute(sql, | |
178 | + ((SentenceSeparator) jPanelSql.getJComboBoxSentenceSeparator() | |
179 | + .getSelectedItem()).getRegVal()); | |
178 | 180 | if (sqlAsyncExecute.isDuplxSelect()) { |
179 | 181 | ShowDialog.warningMessage("複数のSELECT文は実行出来ません", "複数のSELECT文"); |
180 | 182 | jPanelSql.getJToggleButtonExecution().setSelected(false); |
@@ -370,7 +372,6 @@ | ||
370 | 372 | // 画面状態の復元 |
371 | 373 | view.setViewMainPanelSesion(jPanelSession, getConfigViewMain()); |
372 | 374 | |
373 | - | |
374 | 375 | // tabに追加してから、HierarchyListenerを登録 |
375 | 376 | JTabbedPane jTabbedPane = view.getJTabbedPaneSession(); |
376 | 377 | jTabbedPane.setSelectedComponent(jTabbedPane.add(dbc.getConnectName(), jPanelSession)); |
@@ -382,7 +383,6 @@ | ||
382 | 383 | jTabbedPane.setTabComponentAt(jTabbedPane.indexOfComponent(jPanelSession), tabComponent); |
383 | 384 | jPanelSession.addHierarchyListener(eventHierarchyParentChanged); |
384 | 385 | |
385 | - | |
386 | 386 | // SQL実行履歴のフィルタをjtableのオブジェクト単位に作成 |
387 | 387 | TableRowSorter<HistryTableModel> sorter = new TableRowSorter<HistryTableModel>(histryTableModel); |
388 | 388 | sorter.setRowFilter(RowFilter.regexFilter("^" + dbc.getConnectName() + "$", |
@@ -405,7 +405,7 @@ | ||
405 | 405 | jPanelSession.getJTabbedPaneSql().add(jPanelHIstory, "History", 0); |
406 | 406 | |
407 | 407 | jPanelSession.jLabelStatus.setText("NAME=" + dbc.getConnectName() + " " + "URL=" + dbc.getUrl() |
408 | - + " " + "USER=" + dbc.getUser()); | |
408 | + + " " + "USER=" + dbc.getUser()); | |
409 | 409 | |
410 | 410 | // SQLパネルの表示 |
411 | 411 | try { |
@@ -421,7 +421,8 @@ | ||
421 | 421 | |
422 | 422 | DBObjectsRoot o = new DBObjectsRoot(dbc.getMetaData()); |
423 | 423 | DBobjectMutableTreeTableNode root = new DBobjectMutableTreeTableNode(o.getDBObjects().get(0), true); |
424 | - DefaultTreeTableModel model = (DefaultTreeTableModel) jPanelSession.getJXTreetableDBObjects().getTreeTableModel(); | |
424 | + DefaultTreeTableModel model = | |
425 | + (DefaultTreeTableModel) jPanelSession.getJXTreetableDBObjects().getTreeTableModel(); | |
425 | 426 | model.setRoot(root); |
426 | 427 | |
427 | 428 | jPanelSession.addChildren(root); |
@@ -443,7 +444,8 @@ | ||
443 | 444 | |
444 | 445 | @Override |
445 | 446 | public void dataBaseConnectionClosed(DataBaseConnection dbc) { |
446 | - Jdbcacsess2.logger.info(jPanelSession.getDataBaseConnection() + " " + jPanelSession.getDataBaseConnection().getUrl()); | |
447 | + Jdbcacsess2.logger.info(jPanelSession.getDataBaseConnection() + " " | |
448 | + + jPanelSession.getDataBaseConnection().getUrl()); | |
447 | 449 | } |
448 | 450 | |
449 | 451 | @Override |
@@ -600,7 +602,6 @@ | ||
600 | 602 | } |
601 | 603 | }; |
602 | 604 | |
603 | - | |
604 | 605 | /** |
605 | 606 | * データベースオブジェクトツリーの再構築を行う |
606 | 607 | */ |
@@ -658,7 +659,7 @@ | ||
658 | 659 | /** |
659 | 660 | * データベースオブジェクトツリーのリーフを展開する |
660 | 661 | */ |
661 | - private final TreeWillExpandListener eventObjectExpand = new TreeWillExpandListener(){ | |
662 | + private final TreeWillExpandListener eventObjectExpand = new TreeWillExpandListener() { | |
662 | 663 | @Override |
663 | 664 | public void treeWillCollapse(TreeExpansionEvent arg0) throws ExpandVetoException { |
664 | 665 | } |
@@ -804,7 +805,6 @@ | ||
804 | 805 | view.getJMenuTabbedSessionReNew().addActionListener(actionReNewPanelSession); |
805 | 806 | view.getJMenuTabbedSessionClose().addActionListener(actionClosePanelSession); |
806 | 807 | |
807 | - | |
808 | 808 | // GUIのコンポーネント属性を復元 |
809 | 809 | view.setViewMain(getConfigViewMain()); |
810 | 810 | view.setVisible(true); |
@@ -30,67 +30,66 @@ | ||
30 | 30 | */ |
31 | 31 | public class ShowDialog { |
32 | 32 | |
33 | - /** | |
34 | - * 例外発生時のメッセージ出力。画面表示とログ出力を行います。画面表示は、SwingUtilities. | |
35 | - * invokeLaterを使用しEDTで実行されます。 | |
36 | - * | |
37 | - * @param t | |
38 | - * 例外 | |
39 | - */ | |
40 | - public static void errorMessage(final Throwable t) { | |
41 | - try { | |
42 | - SQLException nextSqlException = null; | |
43 | - if (t instanceof SQLException) { | |
44 | - nextSqlException = ((SQLException) t).getNextException(); | |
45 | - } | |
46 | - | |
47 | - Jdbcacsess2.logger.log(Level.SEVERE, "ERROR", t.getStackTrace()); | |
48 | - | |
49 | - final String msg = t.toString() + (nextSqlException != null ? "\n" + nextSqlException.toString() : ""); | |
50 | - | |
51 | - // EDT以外で呼ばれる事も想定し、EDTで実行する。 | |
52 | - SwingUtilities.invokeLater(new Runnable() { | |
53 | - public void run() { | |
54 | - JOptionPane.showMessageDialog(null, msg, "ERRORが発生しました", JOptionPane.ERROR_MESSAGE); | |
55 | - } | |
56 | - }); | |
57 | - } catch (Throwable e) { | |
58 | - // ダイアログ表示時はエラーは全て握りつぶす | |
59 | - e.printStackTrace(); | |
60 | - } | |
61 | - } | |
33 | + /** | |
34 | + * 例外発生時のメッセージ出力。画面表示とログ出力を行います。画面表示は、SwingUtilities. invokeLaterを使用しEDTで実行されます。 | |
35 | + * | |
36 | + * @param t | |
37 | + * 例外 | |
38 | + */ | |
39 | + public static void errorMessage(final Throwable t) { | |
40 | + try { | |
41 | + SQLException nextSqlException = null; | |
42 | + if (t instanceof SQLException) { | |
43 | + nextSqlException = ((SQLException) t).getNextException(); | |
44 | + } | |
62 | 45 | |
63 | - /** | |
64 | - * インフォレベルの画面表示。ログ出力も行います。画面表示は、SwingUtilities.invokeLaterを使用しEDTで実行されます。 | |
65 | - * | |
66 | - * @param message | |
67 | - * メッセージ本文 | |
68 | - * @param title | |
69 | - * メッセージタイトル | |
70 | - */ | |
71 | - public static void infomationMessage(final Component component, final String message, final String title) { | |
72 | - Jdbcacsess2.logger.info("(" + title + ")" + message); | |
73 | - SwingUtilities.invokeLater(new Runnable() { | |
74 | - public void run() { | |
75 | - JOptionPane.showMessageDialog(component, message, title, JOptionPane.INFORMATION_MESSAGE); | |
76 | - } | |
77 | - }); | |
78 | - } | |
46 | + Jdbcacsess2.logger.log(Level.SEVERE, "ERROR", t.getStackTrace()); | |
79 | 47 | |
80 | - /** | |
81 | - * ワーニングレベルの画面表示。ログ出力も行います。画面表示は、SwingUtilities.invokeLaterを使用しEDTで実行されます。 | |
82 | - * | |
83 | - * @param message | |
84 | - * メッセージ本文 | |
85 | - * @param title | |
86 | - * メッセージタイトル | |
87 | - */ | |
88 | - public static void warningMessage(final String message, final String title) { | |
89 | - Jdbcacsess2.logger.warning("(" + title + ")" + message); | |
90 | - SwingUtilities.invokeLater(new Runnable() { | |
91 | - public void run() { | |
92 | - JOptionPane.showMessageDialog(null, message, title, JOptionPane.WARNING_MESSAGE); | |
93 | - } | |
94 | - }); | |
95 | - } | |
48 | + final String msg = t.toString() + (nextSqlException != null ? "\n" + nextSqlException.toString() : ""); | |
49 | + | |
50 | + // EDT以外で呼ばれる事も想定し、EDTで実行する。 | |
51 | + SwingUtilities.invokeLater(new Runnable() { | |
52 | + public void run() { | |
53 | + JOptionPane.showMessageDialog(null, msg, "ERRORが発生しました", JOptionPane.ERROR_MESSAGE); | |
54 | + } | |
55 | + }); | |
56 | + } catch (Throwable e) { | |
57 | + // ダイアログ表示時はエラーは全て握りつぶす | |
58 | + e.printStackTrace(); | |
59 | + } | |
60 | + } | |
61 | + | |
62 | + /** | |
63 | + * インフォレベルの画面表示。ログ出力も行います。画面表示は、SwingUtilities.invokeLaterを使用しEDTで実行されます。 | |
64 | + * | |
65 | + * @param message | |
66 | + * メッセージ本文 | |
67 | + * @param title | |
68 | + * メッセージタイトル | |
69 | + */ | |
70 | + public static void infomationMessage(final Component component, final String message, final String title) { | |
71 | + Jdbcacsess2.logger.info("(" + title + ")" + message); | |
72 | + SwingUtilities.invokeLater(new Runnable() { | |
73 | + public void run() { | |
74 | + JOptionPane.showMessageDialog(component, message, title, JOptionPane.INFORMATION_MESSAGE); | |
75 | + } | |
76 | + }); | |
77 | + } | |
78 | + | |
79 | + /** | |
80 | + * ワーニングレベルの画面表示。ログ出力も行います。画面表示は、SwingUtilities.invokeLaterを使用しEDTで実行されます。 | |
81 | + * | |
82 | + * @param message | |
83 | + * メッセージ本文 | |
84 | + * @param title | |
85 | + * メッセージタイトル | |
86 | + */ | |
87 | + public static void warningMessage(final String message, final String title) { | |
88 | + Jdbcacsess2.logger.warning("(" + title + ")" + message); | |
89 | + SwingUtilities.invokeLater(new Runnable() { | |
90 | + public void run() { | |
91 | + JOptionPane.showMessageDialog(null, message, title, JOptionPane.WARNING_MESSAGE); | |
92 | + } | |
93 | + }); | |
94 | + } | |
96 | 95 | } |
@@ -52,8 +52,7 @@ | ||
52 | 52 | import javax.swing.plaf.basic.BasicButtonUI; |
53 | 53 | |
54 | 54 | /** |
55 | - * Component to be used as tabComponent; Contains a JLabel to show the text and | |
56 | - * a JButton to close the tab it belongs to | |
55 | + * Component to be used as tabComponent; Contains a JLabel to show the text and a JButton to close the tab it belongs to | |
57 | 56 | */ |
58 | 57 | public class TabComponent extends JPanel { |
59 | 58 |
@@ -71,6 +70,7 @@ | ||
71 | 70 | // make JLabel read titles from JTabbedPane |
72 | 71 | JLabel label = new JLabel() { |
73 | 72 | private static final long serialVersionUID = 6611567392269299460L; |
73 | + | |
74 | 74 | @Override |
75 | 75 | public String getText() { |
76 | 76 | int i = pane.indexOfTabComponent(TabComponent.this); |
@@ -23,7 +23,7 @@ | ||
23 | 23 | |
24 | 24 | /** |
25 | 25 | * @author sima |
26 | - * | |
26 | + * | |
27 | 27 | */ |
28 | 28 | public class TabbedPaneMousePointer extends MouseMotionAdapter { |
29 | 29 | private volatile int x; |
@@ -34,6 +34,7 @@ | ||
34 | 34 | this.jTabbedPane = jTabbedPane; |
35 | 35 | jTabbedPane.addMouseMotionListener(this); |
36 | 36 | } |
37 | + | |
37 | 38 | @Override |
38 | 39 | public void mouseMoved(MouseEvent e) { |
39 | 40 | x = e.getX(); |
@@ -42,7 +42,7 @@ | ||
42 | 42 | * |
43 | 43 | */ |
44 | 44 | public class TableColumnFit implements TableColumnModelListener, TableModelListener, MouseMotionListener, |
45 | -PropertyChangeListener { | |
45 | + PropertyChangeListener { | |
46 | 46 | |
47 | 47 | private final JTable jTable; |
48 | 48 | private boolean autoFit = false; |
@@ -113,9 +113,7 @@ | ||
113 | 113 | /* |
114 | 114 | * (非 Javadoc) |
115 | 115 | * |
116 | - * @see | |
117 | - * java.awt.event.MouseMotionListener#mouseDragged(java.awt.event.MouseEvent | |
118 | - * ) | |
116 | + * @see java.awt.event.MouseMotionListener#mouseDragged(java.awt.event.MouseEvent ) | |
119 | 117 | */ |
120 | 118 | @Override |
121 | 119 | public void mouseDragged(MouseEvent e) { |
@@ -126,9 +124,7 @@ | ||
126 | 124 | /* |
127 | 125 | * (非 Javadoc) |
128 | 126 | * |
129 | - * @see | |
130 | - * javax.swing.event.TableColumnModelListener#columnAdded(javax.swing.event | |
131 | - * .TableColumnModelEvent) | |
127 | + * @see javax.swing.event.TableColumnModelListener#columnAdded(javax.swing.event .TableColumnModelEvent) | |
132 | 128 | */ |
133 | 129 | @Override |
134 | 130 | public void columnAdded(TableColumnModelEvent e) { |
@@ -141,8 +137,7 @@ | ||
141 | 137 | /* |
142 | 138 | * (非 Javadoc) |
143 | 139 | * |
144 | - * @seejavax.swing.event.TableModelListener#tableChanged(javax.swing.event. | |
145 | - * TableModelEvent) | |
140 | + * @seejavax.swing.event.TableModelListener#tableChanged(javax.swing.event. TableModelEvent) | |
146 | 141 | */ |
147 | 142 | @Override |
148 | 143 | public void tableChanged(TableModelEvent event) { |
@@ -261,7 +256,7 @@ | ||
261 | 256 | */ |
262 | 257 | private int preferredWidth(JComponent jComponent) { |
263 | 258 | int rtn = jComponent.getPreferredSize().width + jComponent.getInsets().left + jComponent.getInsets().right |
264 | - + jTable.getIntercellSpacing().width; | |
259 | + + jTable.getIntercellSpacing().width; | |
265 | 260 | return rtn; |
266 | 261 | } |
267 | 262 |
@@ -280,8 +275,7 @@ | ||
280 | 275 | /* |
281 | 276 | * (非 Javadoc) |
282 | 277 | * |
283 | - * @see java.beans.PropertyChangeListener#propertyChange(java.beans. | |
284 | - * PropertyChangeEvent) | |
278 | + * @see java.beans.PropertyChangeListener#propertyChange(java.beans. PropertyChangeEvent) | |
285 | 279 | */ |
286 | 280 | @Override |
287 | 281 | public void propertyChange(PropertyChangeEvent evt) { |
@@ -294,8 +288,7 @@ | ||
294 | 288 | /* |
295 | 289 | * (非 Javadoc) |
296 | 290 | * |
297 | - * @see | |
298 | - * java.awt.event.MouseMotionListener#mouseMoved(java.awt.event.MouseEvent) | |
291 | + * @see java.awt.event.MouseMotionListener#mouseMoved(java.awt.event.MouseEvent) | |
299 | 292 | */ |
300 | 293 | @Override |
301 | 294 | public void mouseMoved(MouseEvent e) { |
@@ -304,9 +297,7 @@ | ||
304 | 297 | /* |
305 | 298 | * (非 Javadoc) |
306 | 299 | * |
307 | - * @see | |
308 | - * javax.swing.event.TableColumnModelListener#columnMarginChanged(javax. | |
309 | - * swing.event.ChangeEvent) | |
300 | + * @see javax.swing.event.TableColumnModelListener#columnMarginChanged(javax. swing.event.ChangeEvent) | |
310 | 301 | */ |
311 | 302 | @Override |
312 | 303 | public void columnMarginChanged(ChangeEvent e) { |
@@ -315,9 +306,7 @@ | ||
315 | 306 | /* |
316 | 307 | * (非 Javadoc) |
317 | 308 | * |
318 | - * @see | |
319 | - * javax.swing.event.TableColumnModelListener#columnMoved(javax.swing.event | |
320 | - * .TableColumnModelEvent) | |
309 | + * @see javax.swing.event.TableColumnModelListener#columnMoved(javax.swing.event .TableColumnModelEvent) | |
321 | 310 | */ |
322 | 311 | @Override |
323 | 312 | public void columnMoved(TableColumnModelEvent e) { |
@@ -326,9 +315,7 @@ | ||
326 | 315 | /* |
327 | 316 | * (非 Javadoc) |
328 | 317 | * |
329 | - * @see | |
330 | - * javax.swing.event.TableColumnModelListener#columnRemoved(javax.swing. | |
331 | - * event.TableColumnModelEvent) | |
318 | + * @see javax.swing.event.TableColumnModelListener#columnRemoved(javax.swing. event.TableColumnModelEvent) | |
332 | 319 | */ |
333 | 320 | @Override |
334 | 321 | public void columnRemoved(TableColumnModelEvent e) { |
@@ -337,13 +324,10 @@ | ||
337 | 324 | /* |
338 | 325 | * (非 Javadoc) |
339 | 326 | * |
340 | - * @see | |
341 | - * javax.swing.event.TableColumnModelListener#columnSelectionChanged(javax | |
342 | - * .swing.event.ListSelectionEvent) | |
327 | + * @see javax.swing.event.TableColumnModelListener#columnSelectionChanged(javax .swing.event.ListSelectionEvent) | |
343 | 328 | */ |
344 | 329 | @Override |
345 | 330 | public void columnSelectionChanged(ListSelectionEvent e) { |
346 | 331 | } |
347 | 332 | |
348 | - | |
349 | 333 | } |