入力した値に対するデータを表示させたい

実現したいこと

ログイン画面にて社員番号を入力してフォーカス移動すると、入力した社員番号でDB検索しデータが存在する場合、社員番号に対する氏名を氏名欄に表示、データが存在しない場合、「該当なし」と表示させたい。

jsp
1<%@ page language="java" contentType="text/html; charset=UTF-8"
2	pageEncoding="UTF-8"%>
3<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
4<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
5<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>
6<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
7
8<%
9	request.setCharacterEncoding("UTF-8");
10	String name = request.getParameter("name");
11%>
12<html>
13<head>
14<meta charset="UTF-8">
15<title>ログイン画面</title>
16</head>
17<body>```ここに言語を入力
18	<form action="<%=request.getContextPath()%>/Accountsearch"
19		method="post">
20		<div align="center">
21			<table>
22
23				<tr>
24					<th>社員番号</th>
25					<td><input type="text" name="syainno" value="" size="16"
26						maxlength="4" tabindex="1" id="syain" required><br></td>
27				</tr>
28				<tr>
29					<th>氏名</th>
30					<td><html:text property="name" name="Account" size="16"
31						maxlength="12" readonly="true"/></td>
32				</tr>
33				<tr>
34					<th>パスワード</th>
35					<td><input type="password" name="password" value="" size="17"
36						maxlength="12" tabindex="2" required><br></td>
37				</tr>
38				<tr>
39					<td colspan="1"><input type="submit" value="ログイン" tabindex="3"><br>
40					</td>
41				</tr>
42			</table>
43			<script type="text/javascript">
44				document.getElementById('syain').focus();
45				//初期フォーカス設定
46			</script>
47		</div>
48	</form>
49</body>
50</html>
51

bean

package model;

import java.io.Serializable;

public class AccountBeans implements Serializable {
    private static final long serialVersionUID = 1L;

    private String syainno;
	private String name;
	private String password;
	private int securitycd;
	private String securitynm;

	public String getSyainno() {
		return syainno;
	}
	public void setSyainno(String syainno) {
		this.syainno = syainno;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public int getSecuritycd() {
		return securitycd;
	}
	public void setSecuritycd(int securitycd) {
		this.securitycd = securitycd;
	}
	public String getSecuritynm() {
		return securitynm;
	}
	public void setSecuritynm(String securitynm) {
		this.securitynm = securitynm;
	}
	public static long getSerialversionuid() {
		return serialVersionUID;
	}

}

dao

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import model.AccountBeans;

public class Login {

	// 接続文字列の設定
	String url = "jdbc:postgresql://localhost:5432/dss";
	String user = "postgres";
	String password = "";

	public AccountBeans findAccount(AccountBeans ab) {

		AccountBeans returnab = new AccountBeans();

		try {
			// postgreSQLのJDBCドライバを読み込み
			Class.forName("org.postgresql.Driver");
		} catch (ClassNotFoundException e) {
			// JDBCドライバが見つからない場合
			e.printStackTrace();
		}

		// PostgreSQLに接続
		try (Connection con = DriverManager.getConnection(url, user, password)) {

			String sql = "SELECT syain_m.syainno,name,password from SYAIN_M where syainno = ? and password = ?";
			PreparedStatement ps = con.prepareStatement(sql);

			ps.setString(1, ab.getSyainno());
			ps.setString(2, ab.getPassword());
			// Statement stmt = con.createStatement();
			ResultSet rs = ps.executeQuery();


			if (rs.next()) {
				// 見つかったアカウント情報を戻り値にセット
				returnab.setSyainno(rs.getString("syainno"));
				returnab.setName(rs.getString("name"));
				returnab.setPassword(rs.getString("password"));
			} else {
				// アカウントがなければnullを返す
				return null;
			}
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}
		return returnab;
	}
}

servlet

package servlet;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import dao.Login;
import model.AccountBeans;


/**
 * Servlet implementation class AccountDAO2
 */
@WebServlet("/AccountSearch")
public class Accountsearch extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public Accountsearch() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub

    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        String syainno = request.getParameter("syainno");
        String password = request.getParameter("password");

        // login.jspから受け取った社員Noとpasswordをセット
        AccountBeans ab = new AccountBeans();
        ab.setSyainno(syainno);
        ab.setPassword(password);

        // アカウントの有無を検索
        // 検索したアカウント情報を取得
        Login ad = new Login();
        AccountBeans returnAb = ad.findAccount(ab);


        if(returnAb != null) {
            // セッションにアカウント情報＆ロールを登録
            HttpSession session = request.getSession();
            session.setAttribute("Account", returnAb);

            RequestDispatcher rd = request.getRequestDispatcher("logon.jsp");
            rd.forward(request, response);

        } else {
            RequestDispatcher rd = request.getRequestDispatcher("error.jsp");
            rd.forward(request, response);
        }
    }
}