📄 addrecord.jsp
字号:
<%-- tpl:insert page="/template/jsfTemplate.jtpl" --%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
<%@taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
<%@taglib uri="http://www.ibm.com/jsf/html_extended" prefix="hx"%>
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<META name="GENERATOR" content="IBM Software Development Platform">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK href="../theme/Master.css" rel="stylesheet" type="text/css">
<LINK href="../theme/new.css" rel="stylesheet">
<LINK rel="stylesheet" type="text/css" href="../theme/stylesheet.css" title="Style">
<%-- tpl:put name="headarea" --%>
<title>addRecord.jsp</title>
<%-- /tpl:put --%>
<LINK rel="stylesheet" type="text/css" href="/JSFandSDO/theme/stylesheet.css" title="Style">
</HEAD>
<f:view>
<BODY>
<TABLE class="title" cellpadding="0">
<TBODY>
<TR>
<TD class="noBorder" background="../images/gradient.jpg"
align="CENTER"><IMG border="0" src="../images/title.jpg"></TD>
</TR>
<TR>
<TD class="noBorder" align="RIGHT"><A href="/JSFandSDO">Return to Main Menu</A></TD>
</TR>
</TBODY>
</TABLE>
<%-- tpl:put name="bodyarea" --%>
<hx:scriptCollector id="scriptCollector1">
<h:form styleClass="form" id="form1">
<H2>Adding a Database Record using Auto-Key Generation</H2>This sample demonstrates how to use JavaServer Faces (JSF) combined with a relational record to automatically generate a primary key when a new record is added to the database.<BR>
<BR>
Enter the student information and click "Add Record" to add this record to the database with an auto-generated key.<BR>
<BR>
<TABLE border="1">
<TBODY>
<TR>
<TD class="td25">Student Name:</TD>
<TD class="border"><h:inputText id="nameInput" value="#{pc_AddRecord.addRecord.STUDENT_NAME}" styleClass="inputText">
</h:inputText></TD>
</TR>
<TR>
<TD class="td25">Math Grade (int):</TD>
<TD class="border"><h:inputText id="mathInput" value="#{pc_AddRecord.addRecord.MATH}" styleClass="inputText">
<f:convertNumber />
<f:validateDoubleRange minimum="0.0" maximum="100.0"></f:validateDoubleRange>
</h:inputText><h:message for="mathInput" styleClass="errorMessage"></h:message></TD>
</TR>
<TR>
<TD class="td25">Science Grade (int):</TD>
<TD class="border"><h:inputText id="scienceInput" value="#{pc_AddRecord.addRecord.SCIENCE}" styleClass="inputText">
<f:convertNumber />
<f:validateDoubleRange minimum="0.0" maximum="100.0"></f:validateDoubleRange>
</h:inputText><h:message for="scienceInput" styleClass="errorMessage"></h:message></TD>
</TR>
<TR>
<TD class="td25">History Grade (int):</TD>
<TD class="border"><h:inputText id="historyInput" value="#{pc_AddRecord.addRecord.HISTORY}" styleClass="inputText">
<f:convertNumber />
<f:validateDoubleRange minimum="0.0" maximum="100.0"></f:validateDoubleRange>
</h:inputText><h:message for="historyInput" styleClass="errorMessage"></h:message></TD>
</TR>
<TR>
<TD class="td25">Writing Grade (int):</TD>
<TD class="border"><h:inputText id="writingInput" value="#{pc_AddRecord.addRecord.WRITING}" styleClass="inputText">
<f:convertNumber />
<f:validateDoubleRange minimum="0.0" maximum="100.0"></f:validateDoubleRange>
</h:inputText><h:message for="writingInput" styleClass="errorMessage"></h:message></TD>
</TR>
<TR>
<TD class="td25">Art Grade (int):</TD>
<TD class="border"><h:inputText id="artInput" value="#{pc_AddRecord.addRecord.ART}" styleClass="inputText">
<f:convertNumber />
<f:validateDoubleRange minimum="0.0" maximum="100.0"></f:validateDoubleRange>
</h:inputText><h:message for="artInput" styleClass="errorMessage"></h:message></TD>
</TR>
<TR>
<TD class="td25"><hx:commandExButton id="button1" styleClass="commandExButton2" type="submit" value="Add Record" action="#{pc_AddRecord.doAddRecordUpdateAction}">
</hx:commandExButton></TD>
<TD class="border"><BR></TD>
</TR>
</TBODY>
</TABLE><H4>Student Record Table</H4>
<h:dataTable id="table1" value="#{pc_AddRecord.viewRecords}" var="varviewRecords" styleClass="dataTable" headerClass="headerClass" footerClass="footerClass" rowClasses="rowClass1, rowClass2" columnClasses="columnClass1" border="1" cellpadding="2" cellspacing="0">
<h:column id="column1">
<f:facet name="header">
<h:outputText styleClass="outputText" value="Student ID (Key)" id="text8"></h:outputText>
</f:facet>
<h:outputText id="text9" value="#{varviewRecords.STUDENT_ID}" styleClass="outputText">
<f:convertNumber />
</h:outputText>
</h:column>
<h:column id="column2">
<f:facet name="header">
<h:outputText styleClass="outputText" value="Student Name" id="text10"></h:outputText>
</f:facet>
<h:outputText id="text11" styleClass="outputText" value="#{varviewRecords.STUDENT_NAME}">
</h:outputText>
</h:column>
<h:column id="column3">
<f:facet name="header">
<h:outputText styleClass="outputText" value="Math" id="text12"></h:outputText>
</f:facet>
<h:outputText id="text13" value="#{varviewRecords.MATH}" styleClass="outputText">
<f:convertNumber type="number" />
</h:outputText>
</h:column>
<h:column id="column4">
<f:facet name="header">
<h:outputText styleClass="outputText" value="Science" id="text14"></h:outputText>
</f:facet>
<h:outputText id="text15" value="#{varviewRecords.SCIENCE}" styleClass="outputText">
<f:convertNumber type="number" />
</h:outputText>
</h:column>
<h:column id="column5">
<f:facet name="header">
<h:outputText styleClass="outputText" value="History" id="text16"></h:outputText>
</f:facet>
<h:outputText id="text17" value="#{varviewRecords.HISTORY}" styleClass="outputText">
<f:convertNumber />
</h:outputText>
</h:column>
<h:column id="column6">
<f:facet name="header">
<h:outputText styleClass="outputText" value="Writing" id="text18"></h:outputText>
</f:facet>
<h:outputText id="text19" value="#{varviewRecords.WRITING}" styleClass="outputText">
<f:convertNumber />
</h:outputText>
</h:column>
<h:column id="column7">
<f:facet name="header">
<h:outputText styleClass="outputText" value="Art" id="text20"></h:outputText>
</f:facet>
<h:outputText id="text21" value="#{varviewRecords.ART}" styleClass="outputText">
<f:convertNumber />
</h:outputText>
</h:column>
</h:dataTable>
<P></P>
<H4>How It works:</H4>
To use auto-key generation your database must contain a separate table to store key values. This table requires two columns; an identity column (integer type) and an incrementor column (long integer type). The Identity column identifies the row in the table used to generate the next key. The incrementor column is the starting value for the key generation.<BR>
<BR>When creating an relational record you click the "Auto generate key" link at the last step and it opens a "Key genneration" window. You then need to assign the incrementor and identity values to columns in your table. If you already have a relational record and would like to add auto-key generation, you can right-click on the SDO object corresponding to your relational record in the Page Data View and select "Configure."<BR>
<BR>
All code required to add the records to the database is generated automatically when you add a new relational record to the page and select "Creating a new Record".<H4>Files
and Resources of Interest:</H4>
<UL>
<LI><B>WebContent/addRecord/addRecord.java</B> - (This Page) The page where the JSF tags to create these tables is located.</LI><LI><B>addRecord SDO Object -</B> To see where Key Generation is turned on look in the "addRecord" SDO object found in the Page Data View of the <B>WebContent/addRecord/addRecord.jsp</B> file by right-clicking on it and selecting "Configure". To access the Configure menu your server must be stopped. The name of our key
generation table is STUDENT.KEYVALUE.</LI>
<LI><B>src/pagecode.addRecord.AddRecord.java</B> - Where the auto-generated code to add new records to the database is created. Can also be seen by going to the Quick Edit View of the "Add Record" button.</LI>
</UL>
</h:form>
</hx:scriptCollector>
<%-- /tpl:put --%>
<TABLE class="title" cellpadding="0">
<TBODY>
<TR>
<TD class="noBorder" align="RIGHT"><A href="/JSFandSDO">Return to Main Menu</A></TD>
</TR>
</TBODY>
</TABLE>
</BODY>
</f:view>
</HTML><%-- /tpl:insert --%>
<%-- jsf:pagecode language="java" location="/src/pagecode/addRecord/AddRecord.java" --%><%-- /jsf:pagecode --%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -