0
MVCモデル
package jp.co.***.controller;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import jp.co.keyaki.bean.KuyakushoBean;
import jp.co.keyaki.service.Kuyakusho;
public class KuyakushoServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
Kuyakusho kuyakusho = new Kuyakusho();
List<KuyakushoBean> list = kuyakusho.list();
request.setAttribute("LIST", list);
} catch (Exception e) {
e.printStackTrace();
} finally {
ServletContext context = this.getServletContext();
RequestDispatcher dispatcher = context
.getRequestDispatcher("/kuyakusho.jsp");
dispatcher.forward(request, response);
}
}
}
package jp.co.***.service;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import jp.co.***.bean.KuyakushoBean;
public class Kuyakusho {
public KuyakushoBean list() {
try {
Class.forName("org.postgresql.Driver");
Connection connection = DriverManager.getConnection(
"jdbc:postgresql://localhost/lessondb", "***", "***");
String SQL = "SELECT * FROM T_KUYAKUSHO";
PreparedStatement stm = connection.prepareStatement(SQL);
ResultSet resultSet = stm.executeQuery();
if(resultSet.next()) {
KuyakushoBean list = new KuyakushoBean();
list.setId(resultSet.getString("id"));
list.setKU(resultSet.getString("KU"));
list.setZIP(resultSet.getString("ZIP"));
list.setADDRESS(resultSet.getString("ADDRESS"));
list.setTEL(resultSet.getString("TEL"));
return list;
}else {
return null;
}
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
}
package jp.co.***.bean;
public class KuyakushoBean {
private String Id;
public String getId() {
return Id;
}
public void setId (String Id) {
this.Id = Id;
}
public String ku;
public String getKU() {
return ku;
}
public void setKU (String ku) {
this.ku = ku;
}
public String ZIP;
public String getZIP() {
return ZIP;
}
public void setZIP (String ZIP) {
this.ZIP = ZIP;
}
public String ADDRESS;
public String getADDRESS() {
return ADDRESS;
}
public void setADDRESS (String ADDRESS) {
this.ADDRESS = ADDRESS;
}
public String TEL;
public String getTEL() {
return TEL;
}
public void setTEL (String TEL) {
this.TEL = TEL;
}
}
上記のプログラムで23区区役所一覧を出すMVCモデルを書いています。
List<KuyakushoBean> list = kuyakusho.list();の部分が
型の不一致: KuyakushoBean から List<KuyakushoBean> には変換できませんでエラーになります。
教えてください。