Ajax4JSFを利用したデータ検証

CREATE TABLE OE.Catalog(CatalogID VARCHAR(25) 
  PRIMARY KEY, Journal VARCHAR(25), Publisher VARCHAR(25), 
  Edition VARCHAR(25), Title Varchar(255), Author Varchar(25));

INSERT INTO OE.Catalog VALUES('catalog1', 'Oracle Magazine', 
  'Oracle Publishing', 'July-August 2006', 
  'Evolving Grid Management', 'David Baum');

INSERT INTO OE.Catalog VALUES('catalog2', 'Oracle Magazine', 
  'Oracle Publishing', 'July-August 2005',
  'Tuning Undo Tablespace', 'Kimberly Floss');

<?xml version="1.0" encoding="windows-1252"?>
<!DOCTYPE faces-config PUBLIC
  "-//Sun Microsystems, Inc.//DTD JavaServer Faces Config 1.1//EN"
  "http://java.sun.com/dtd/web-facesconfig_1_1.dtd">
<faces-config xmlns="http://java.sun.com/JSF/Configuration">
  <managed-bean>
    <managed-bean-name>backing_input</managed-bean-name>
    <managed-bean-class>ajaxjsf.backing.Input</managed-bean-class>
    <managed-bean-scope>request</managed-bean-scope>
    <!--oracle-jdev-comment:managed-bean-jsp-link:1input.jsp-->
  </managed-bean>
  <navigation-rule>
    <from-view-id>/input.jsp</from-view-id>
      <navigation-case>
        <from-outcome>catalog</from-outcome>
        <to-view-id>/catalog.jsp</to-view-id>
      </navigation-case>
      <navigation-case>
        <from-outcome>error</from-outcome>
        <to-view-id>/error.jsp</to-view-id>
      </navigation-case>
  </navigation-rule>
</faces-config>

<?xml version = '1.0' encoding = 'windows-1252'?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation=
  "http://java.sun.com/xml/ns/j2ee 
  http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
  version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee">
  <description>Empty web.xml file for Web Application
  </description>
    <context-param>
      <param-name>javax.faces.STATE_SAVING_METHOD</param-name>
      <param-value>server</param-value>
    </context-param>
    <filter>
      <display-name>Ajax4jsf Filter</display-name>
      <filter-name>ajax4jsf</filter-name>
      <filter-class>org.ajax4jsf.Filter</filter-class>
    </filter>
    <filter-mapping>
      <filter-name>ajax4jsf</filter-name>
      <servlet-name>Faces Servlet</servlet-name>
      <dispatcher>REQUEST</dispatcher>
      <dispatcher>FORWARD</dispatcher>
      <dispatcher>INCLUDE</dispatcher>
    </filter-mapping>
    <listener>
      <listener-class>com.sun.faces.config.ConfigureListener
      </listener-class>
    </listener>
    <servlet>
      <servlet-name>Faces Servlet</servlet-name>
      <servlet-class>javax.faces.webapp.FacesServlet
      </servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
      <servlet-name>Faces Servlet</servlet-name>
        <url-pattern>/faces/*</url-pattern>
    </servlet-mapping>
    <session-config>
      <session-timeout>35</session-timeout>
    </session-config>
    <mime-mapping>
      <extension>html</extension>
        <mime-type>text/html</mime-type>
    </mime-mapping>
    <mime-mapping>
      <extension>txt</extension>
        <mime-type>text/plain</mime-type>
    </mime-mapping>
    <resource-ref>
      <res-ref-name>jdbc/OracleDBConnectionDS</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
    </resource-ref>
</web-app>

<h:inputText binding="#{backing_input.inputText1}"
  id="inputText1">
  <a4j:support event="onkeyup" action=
    "#{backing_input.inputText_action}"
    reRender=
    "inputText2,inputText3,inputText4,inputText5,inputText6,
    commandButton1,outputText1" />
</h:inputText>

<%@ taglib uri="https://ajax4jsf.dev.java.net/ajax" 
  prefix="a4j"%>

<h:commandButton value="Submit"
  binding="#{backing_input.commandButton1}" action=
  "#{backing_input.commandButton_action}"
  id="commandButton1"/>

InitialContext initialContext = new InitialContext();
 javax.sql.DataSource ds = 
 (javax.sql.DataSource)initialContext.lookup(
 "java:comp/env/jdbc/OracleDBConnectionDS");
 java.sql.Connection connection = ds.getConnection();

Statement stmt = connection.createStatement(
  ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

String catalogID = (String)inputText1.getValue();
  String query = "SELECT * from Catalog WHERE CATALOGID=" + "'" + 
  catalogID + "'";

rs = stmt.executeQuery(query);

if (rs.next()) {
  inputText2.setValue(rs.getString(2));
  inputText3.setValue(rs.getString(3));
  inputText4.setValue(rs.getString(4));
  inputText5.setValue(rs.getString(5));
  inputText6.setValue(rs.getString(6));
  outputText1.setValue(new String("Catalog Id is not Valid"));

  commandButton1.setDisabled(true);

}

else {
  inputText2.setValue(new String());
  inputText3.setValue(new String());
  inputText4.setValue(new String());
  inputText5.setValue(new String());
  inputText6.setValue(new String());
  outputText1.setValue(new String("Catalog Id is Valid"));

  commandButton1.setDisabled(false);
}

<%@ taglib uri="https://ajax4jsf.dev.java.net/ajax" prefix="a4j"%>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
<f:view>
  <html>
    <head>
      <meta http-equiv="Content-Type" content="text/html; 
        charset=windows-1252"/>
      <title>input</title>
      <h3>Catalog Entry Form</h3>
    </head>
    <body><h:form binding="#{backing_input.form1}" id="form1">
      <h:panelGrid columns="2" binding=
        "#{backing_input.panelGrid1}" id="panelGrid1">
        <h:outputLabel value="Catalog ID"
          binding="#{backing_input.outputLabel1}"
          id="outputLabel1"/>
        <h:inputText binding="#{backing_input.inputText1}"
          id="inputText1">
          <a4j:support event="onkeyup" action=
            "#{backing_input.inputText_action}"
            reRender="inputText2,inputText3,inputText4,inputText5,
            inputText6,commandButton1,outputText1" />
        </h:inputText>
        <h:outputLabel value="Journal" binding=
          "#{backing_input.outputLabel2}" id="outputLabel2"/>
        <h:inputText binding="#{backing_input.inputText2}" 
          id="inputText2"/>
        <h:outputLabel value="Publisher"
          binding="#{backing_input.outputLabel3}"
          id="outputLabel3"/>
        <h:inputText binding="#{backing_input.inputText3}" 
          id="inputText3"/>
        <h:outputLabel value="Edition" binding=
          "#{backing_input.outputLabel4}"
          id="outputLabel4"/>
        <h:inputText binding="#{backing_input.inputText4}" 
          id="inputText4"/>
        <h:outputLabel value="Title" binding=
          "#{backing_input.outputLabel5}"
          id="outputLabel5"/>
        <h:inputText binding="#{backing_input.inputText5}" 
          id="inputText5"/>
        <h:outputLabel value="Author" binding=
          "#{backing_input.outputLabel6}"
          id="outputLabel6"/>
        <h:inputText binding="#{backing_input.inputText6}" 
          id="inputText6"/>
        <h:commandButton value="Submit"
          binding="#{backing_input.commandButton1}" action=
          "#{backing_input.commandButton_action}"
          id="commandButton1"/>
        <h:outputText  binding="#{backing_input.outputText1}"
          id="outputText1"/>
      </h:panelGrid>
    </h:form></body>
  </html>
</f:view>
<%-- oracle-jdev-comment:auto-binding-backing-bean-
  name:backing_input--%>

package ajaxjsf.backing;

import java.sql.*;

import javax.faces.component.html.HtmlCommandButton;
import javax.faces.component.html.HtmlForm;
import javax.faces.component.html.HtmlInputText;
import javax.faces.component.html.HtmlOutputLabel;
import javax.faces.component.html.HtmlOutputText;
import javax.faces.component.html.HtmlPanelGrid;

import javax.naming.InitialContext;

public class Input {
  private HtmlForm form1;
  private HtmlPanelGrid panelGrid1;
  private HtmlOutputLabel outputLabel1;
  private HtmlInputText inputText1;
  private HtmlOutputLabel outputLabel2;
  private HtmlInputText inputText2;
  private HtmlOutputLabel outputLabel3;
  private HtmlInputText inputText3;
  private HtmlOutputLabel outputLabel4;
  private HtmlInputText inputText4;
  private HtmlOutputLabel outputLabel5;
  private HtmlInputText inputText5;
  private HtmlOutputLabel outputLabel6;
  private HtmlInputText inputText6;
  private HtmlCommandButton commandButton1;
  private HtmlOutputText outputText1;

  public void setForm1(HtmlForm form1) {
    this.form1 = form1;
  }

  public HtmlForm getForm1() {
    return form1;
  }

  public void setPanelGrid1(HtmlPanelGrid panelGrid1) {
    this.panelGrid1 = panelGrid1;
  }

  public HtmlPanelGrid getPanelGrid1() {
    return panelGrid1;
  }

  public void setOutputLabel1(HtmlOutputLabel outputLabel1) {
    this.outputLabel1 = outputLabel1;
  }

  public HtmlOutputLabel getOutputLabel1() {
    return outputLabel1;
  }

  public void setInputText1(HtmlInputText inputText1) {
    this.inputText1 = inputText1;
  }

  public HtmlInputText getInputText1() {
    return inputText1;
  }

  public void setOutputLabel2(HtmlOutputLabel outputLabel2) {
    this.outputLabel2 = outputLabel2;
  }

  public HtmlOutputLabel getOutputLabel2() {
    return outputLabel2;
  }

  public void setInputText2(HtmlInputText inputText2) {
    this.inputText2 = inputText2;
  }

  public HtmlInputText getInputText2() {
    return inputText2;
  }

  public void setOutputLabel3(HtmlOutputLabel outputLabel3) {
    this.outputLabel3 = outputLabel3;
  }

  public HtmlOutputLabel getOutputLabel3() {
    return outputLabel3;
  }

  public void setInputText3(HtmlInputText inputText3) {
    this.inputText3 = inputText3;
  }

  public HtmlInputText getInputText3() {
    return inputText3;
  }

  public void setOutputLabel4(HtmlOutputLabel outputLabel4) {
    this.outputLabel4 = outputLabel4;
  }

  public HtmlOutputLabel getOutputLabel4() {
    return outputLabel4;
  }

  public void setInputText4(HtmlInputText inputText4) {
    this.inputText4 = inputText4;
  }

  public HtmlInputText getInputText4() {
    return inputText4;
  }

  public void setOutputLabel5(HtmlOutputLabel outputLabel5) {
    this.outputLabel5 = outputLabel5;
  }

  public HtmlOutputLabel getOutputLabel5() {
    return outputLabel5;
  }

  public void setInputText5(HtmlInputText inputText5) {
    this.inputText5 = inputText5;
  }

  public HtmlInputText getInputText5() {
    return inputText5;
  }

  public void setOutputLabel6(HtmlOutputLabel outputLabel6) {
    this.outputLabel6 = outputLabel6;
  }

  public HtmlOutputLabel getOutputLabel6() {
    return outputLabel6;
  }

  public void setInputText6(HtmlInputText inputText6) {
    this.inputText6 = inputText6;
  }

  public HtmlInputText getInputText6() {
    return inputText6;
  }

  public void setCommandButton1(
    HtmlCommandButton commandButton1) {
    this.commandButton1 = commandButton1;
  }

  public HtmlCommandButton getCommandButton1() {
    return commandButton1;
  }

  public void setOutputText1(HtmlOutputText outputText1) {
    this.outputText1 = outputText1;
  }

  public HtmlOutputText getOutputText1() {
    return outputText1;
  }

  public String inputText_action() {
    ResultSet rs = null;
      try {
        InitialContext initialContext = new InitialContext();
        javax.sql.DataSource ds = 
        (javax.sql.DataSource)initialContext.lookup(
        "java:comp/env/jdbc/OracleDBConnectionDS");
        java.sql.Connection connection = ds.getConnection();

          Statement stmt = connection.createStatement(
            ResultSet.TYPE_SCROLL_INSENSITIVE, 
            ResultSet.CONCUR_READ_ONLY);

            String catalogID = (String)inputText1.getValue();

            String query = "SELECT * from Catalog WHERE 
              CATALOGID=" + "'" + catalogID + "'";
            rs = stmt.executeQuery(query);
            if (rs.next()) {
              inputText2.setValue(rs.getString(2));
              inputText3.setValue(rs.getString(3));
              inputText4.setValue(rs.getString(4));
              inputText5.setValue(rs.getString(5));
              inputText6.setValue(rs.getString(6));
              outputText1.setValue(new String(
                "Catalog Id is not Valid"));

              commandButton1.setDisabled(true);

            } else {
              inputText2.setValue(new String());
              inputText3.setValue(new String());
              inputText4.setValue(new String());
              inputText5.setValue(new String());
              inputText6.setValue(new String());
              outputText1.setValue(new String(
                "Catalog Id is Valid"));

              commandButton1.setDisabled(false);
            }

      } catch (SQLException e) {
        System.out.println(e.getMessage());
      } catch (javax.naming.NamingException e) {
        System.out.println(e.getMessage());
    }
    return null;
  }

  public String commandButton_action() {
    try {
      //Obtain Connection
      InitialContext initialContext = new InitialContext();
      javax.sql.DataSource ds = 
        (javax.sql.DataSource)initialContext.lookup(
        "java:comp/env/jdbc/OracleDBConnectionDS");
        java.sql.Connection conn = ds.getConnection();

        String catalogId = (String)inputText1.getValue();
        String journal = (String)inputText2.getValue();
        String publisher = (String)inputText3.getValue();
        String edition = (String)inputText4.getValue();
        String title = (String)inputText5.getValue();
        String author = (String)inputText6.getValue();

        Statement stmt = conn.createStatement();
        String sql = 
          "INSERT INTO Catalog VALUES(
          " + "¥'" + catalogId + "¥'" + "," + "¥'" + journal + 
          "¥'" + "," + "¥'" + publisher + "¥'" + "," + "¥'" + 
          edition + "¥'" + "," + "¥'" + title + "¥'" + "," + 
          "¥'" + author + "¥'" + ")";

          stmt.execute(sql);

          stmt.close();
          conn.close();

    } catch (javax.naming.NamingException e) {
      return "error";
    } catch (SQLException e) {
      return "error";
    }

      return "catalog";

    }
}