質問編集履歴
3
codeに入ってない文字があったので修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -146,7 +146,8 @@
|
|
|
146
146
|
|
|
147
147
|
|
|
148
148
|
中身のcreate tableです
|
|
149
|
+
```
|
|
149
|
-
|
|
150
|
+
create table movie(
|
|
150
151
|
movie_number int,
|
|
151
152
|
title_name varchar(400) not null,
|
|
152
153
|
years_publication char(4) not null,
|
2
create tableを追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -139,14 +139,73 @@
|
|
|
139
139
|
|
|
140
140
|
|
|
141
141
|
|
|
142
|
-
|
|
143
|
-
|
|
144
142
|
```
|
|
145
143
|
このようなエラーが出てしまいます。
|
|
146
144
|
|
|
147
145
|
前方一致の検索なのですがsql構文をどうしたらうまく通るでしょうか？
|
|
148
146
|
|
|
149
147
|
|
|
148
|
+
中身のcreate tableです
|
|
149
|
+
```create table movie(
|
|
150
|
+
movie_number int,
|
|
151
|
+
title_name varchar(400) not null,
|
|
152
|
+
years_publication char(4) not null,
|
|
153
|
+
performance_income varchar(50) not null,
|
|
154
|
+
production_cost varchar(50) not null,
|
|
155
|
+
public_evaluation double not null,
|
|
156
|
+
screening_time varchar(10) not null,
|
|
157
|
+
genre_number int not null,
|
|
158
|
+
directed_number int not null,
|
|
159
|
+
original_number varchar(400) not null,
|
|
160
|
+
cast_number int not null,
|
|
161
|
+
constraint MV primary key(movie_number),
|
|
162
|
+
constraint FK_1 foreign key(genre_number) references genre_list(genre_number),
|
|
163
|
+
|
|
164
|
+
constraint FK_2 foreign key(directed_number) references directed_list(directed_number),
|
|
165
|
+
|
|
166
|
+
constraint FK_3 foreign key(original_number) references original_list(original_number),
|
|
167
|
+
constraint FK_4 foreign key(cast_number) references cast_list(cast_number));
|
|
150
168
|
|
|
169
|
+
|
|
170
|
+
|
|
171
|
+
|
|
172
|
+
|
|
173
|
+
|
|
174
|
+
create table genre_list(
|
|
175
|
+
genre_name varchar(400) not null ,
|
|
176
|
+
genre_number int auto_increment ,
|
|
177
|
+
constraint GN primary key(genre_number));
|
|
178
|
+
|
|
179
|
+
|
|
180
|
+
|
|
181
|
+
create table directed_list(
|
|
182
|
+
directed_name varchar(400) not null ,
|
|
183
|
+
directed_number int auto_increment ,
|
|
184
|
+
constraint DI primary key(directed_number));
|
|
185
|
+
|
|
186
|
+
create table original_list(
|
|
187
|
+
original_name varchar(400) not null ,
|
|
188
|
+
original_number int auto_increment ,
|
|
189
|
+
constraint OI primary key(original_number));
|
|
190
|
+
|
|
191
|
+
|
|
192
|
+
|
|
193
|
+
create table prodction_list(
|
|
194
|
+
prodction_name varchar(400) not null ,
|
|
195
|
+
prodction_number int auto_increment,
|
|
196
|
+
constraint PR primary key(prodction_number));
|
|
197
|
+
|
|
198
|
+
|
|
199
|
+
|
|
200
|
+
|
|
201
|
+
|
|
202
|
+
|
|
203
|
+
create table cast_list(
|
|
204
|
+
cast_name varchar(400) not null ,
|
|
205
|
+
cast_number int auto_increment,
|
|
206
|
+
constraint MA primary key(cast_number));
|
|
207
|
+
```
|
|
208
|
+
|
|
209
|
+
|
|
151
210
|
検索画面はこのようなイメージです
|
|
152
211
|
|
1
トムキャットのエラーコードをcodeに修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -98,8 +98,55 @@
|
|
|
98
98
|
|
|
99
99
|
こちらのModel.javaファイルを実行するとトムキャットに
|
|
100
100
|
|
|
101
|
+
```
|
|
102
|
+
Hello
|
|
103
|
+
java.sql.SQLSyntaxErrorException: SQL構文エラーです。バージョンに対応するマニュアルを参照して正しい構文を確認してください。 : 'title_name like 'ア%'' 付近 1 行目
|
|
104
|
+
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
|
105
|
+
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
|
|
106
|
+
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
107
|
+
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
108
|
+
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
|
|
109
|
+
at movie.Model.execute(Model.java:55)
|
|
101
|
-
|
|
110
|
+
at movie.Controller.doPost(Controller.java:33)
|
|
111
|
+
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
|
|
112
|
+
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
|
|
113
|
+
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
|
|
114
|
+
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
115
|
+
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
116
|
+
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
|
|
117
|
+
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
|
|
118
|
+
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
|
|
119
|
+
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
|
|
120
|
+
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
121
|
+
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
|
|
122
|
+
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
123
|
+
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
|
|
124
|
+
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
|
|
125
|
+
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
|
|
126
|
+
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
|
|
127
|
+
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
128
|
+
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
|
|
129
|
+
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
|
|
130
|
+
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
131
|
+
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
|
|
132
|
+
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
|
|
133
|
+
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
134
|
+
at java.base/java.lang.Thread.run(Thread.java:832)
|
|
102
135
|
|
|
136
|
+
|
|
137
|
+
|
|
138
|
+
|
|
139
|
+
|
|
140
|
+
|
|
141
|
+
|
|
142
|
+
|
|
143
|
+
|
|
144
|
+
```
|
|
103
145
|
このようなエラーが出てしまいます。
|
|
104
146
|
|
|
105
|
-
前方一致の検索なのですがsql構文をどうしたらうまく通るでしょうか？
|
|
147
|
+
前方一致の検索なのですがsql構文をどうしたらうまく通るでしょうか？
|
|
148
|
+
|
|
149
|
+
|
|
150
|
+
|
|
151
|
+
検索画面はこのようなイメージです
|
|
152
|
+
|