| | |
Jsp page to insert data
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved
![]() |
•
•
Join Date: Sep 2007
Posts: 23
Reputation:
Solved Threads: 0
Hi. Me again. I was wondering how could i code my jsp page when i want the following page.
I have the main contract page where you can see the certain property that is in that contract. Contract and Property are connected by contractproperty which contains both contractID and propertyID.
I need to make form to add a new property to the contract. And i need the contractId to be automatically selected when i start to insert the new property to the contract.
It seems simple to do it with just the JSP page that access the database directly, but when i use java classes to access the database then how should i write the query to allow me to do the following. Currently when i begin to add the new contract i have to select the contract ID manually. So how can i do it automatically.(I cut out not so important parts of the code)
Well this is the form to insert the new property to the contract.
This is the contractproperty class file.
contract view jsp
How should i edit the class/new contractproperty.jsp to make the webapp to as i want?
Since the code is netbeans generated i'm little behind of understanding it, but i'm doing my best to chew trought it...
I have the main contract page where you can see the certain property that is in that contract. Contract and Property are connected by contractproperty which contains both contractID and propertyID.
I need to make form to add a new property to the contract. And i need the contractId to be automatically selected when i start to insert the new property to the contract.
It seems simple to do it with just the JSP page that access the database directly, but when i use java classes to access the database then how should i write the query to allow me to do the following. Currently when i begin to add the new contract i have to select the contract ID manually. So how can i do it automatically.(I cut out not so important parts of the code)
Well this is the form to insert the new property to the contract.
JSP Syntax (Toggle Plain Text)
---code-- <h:outputText value="PropertyID:"/> <h:selectOneMenu id="propertyID" value="#{contractProperty.contractProperty.propertyID}" title="PropertyID" required="true" requiredMessage="The propertyID field is required." > <f:selectItems value="#{property.propertyItemsAvailableSelectOne}"/> </h:selectOneMenu> <h:outputText value="ContractID:"/> <h:selectOneMenu id="contractID" value="#{contractProperty.contractProperty.contractID}" title="ContractID" required="true" requiredMessage="The contractID field is required." > <f:selectItems value="#{contract.contractItemsAvailableSelectOne}"/> </h:selectOneMenu> <br /> <h:commandLink action="#{contractProperty.create}" value="Create"/> <br /> --code---
JSP Syntax (Toggle Plain Text)
@Entity @Table(name = "contract_property", catalog = "varad1", schema = "") @NamedQueries({@NamedQuery(name = "ContractProperty.findAll", query = "SELECT c FROM ContractProperty c"), @NamedQuery(name = "ContractProperty.findByContractpropertyID", query = "SELECT c FROM ContractProperty c WHERE c.contractpropertyID" + " = :contractpropertyID"), @NamedQuery(name = "ContractProperty.findByCreated", query = "SELECT c FROM ContractProperty c WHERE c.created = :created"), @NamedQuery(name = "ContractProperty.findByUpdated", query = "SELECT c FROM ContractProperty c WHERE c.updated = :updated")}) public class ContractProperty implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Basic(optional = false) @Column(name = "contract_property_ID") private Integer contractpropertyID; @Basic(optional = false) @Column(name = "created") @Temporal(TemporalType.TIMESTAMP) private Date created; @Column(name = "updated") @Temporal(TemporalType.DATE) private Date updated; @JoinColumn(name = "property_ID", referencedColumnName = "property_ID") @ManyToOne(optional = false) private Property propertyID; @JoinColumn(name = "contract_ID", referencedColumnName = "contract_ID") @ManyToOne(optional = false) private Contract contractID; @JoinColumn(name = "created_by", referencedColumnName = "employee_ID") @ManyToOne(optional = false) private Employee createdBy; @JoinColumn(name = "updated_by", referencedColumnName = "employee_ID") @ManyToOne private Employee updatedBy; public ContractProperty() { } public ContractProperty(Integer contractpropertyID) { this.contractpropertyID = contractpropertyID; } public ContractProperty(Integer contractpropertyID, Date created) { this.contractpropertyID = contractpropertyID; this.created = created; } public Integer getContractpropertyID() { return contractpropertyID; } public void setContractpropertyID(Integer contractpropertyID) { this.contractpropertyID = contractpropertyID; } -more stuff- public Property getPropertyID() { return propertyID; } public void setPropertyID(Property propertyID) { this.propertyID = propertyID; } public Contract getContractID() { return contractID; } public void setContractID(Contract contractID) { this.contractID = contractID; } @Override public int hashCode() { int hash = 0; hash += (contractpropertyID != null ? contractpropertyID.hashCode() : 0); return hash; } @Override public boolean equals(Object object) { // TODO: Warning - this method won't work in the case the id fields are not set if (!(object instanceof ContractProperty)) { return false; } ContractProperty other = (ContractProperty) object; if ((this.contractpropertyID == null && other.contractpropertyID != null) || (this.contractpropertyID != null && !this.contractpropertyID.equals(other.contractpropertyID))) { return false; } return true; } }
JSP Syntax (Toggle Plain Text)
---some other stuff---- <h:outputText value="ContractPropertyCollection:" /> <h:panelGroup> <h:outputText rendered="#{empty contract.contract.contractPropertyCollection}" value="(No Items)"/> <h:dataTable value="#{contract.contract.contractPropertyCollection}" var="item" border="0" cellpadding="2" cellspacing="0" rowClasses="jsfcrud_odd_row,jsfcrud_even_row" rules="all" style="border:solid 1px" rendered="#{not empty contract.contract.contractPropertyCollection}"> <h:column> <f:facet name="header"> <h:outputText value="ContractpropertyID"/> </f:facet> <h:outputText value=" #{item.contractpropertyID}"/> </h:column> <h:column> <f:facet name="header"> <h:outputText value="PropertyID"/> </f:facet> <h:outputText value=" #{item.propertyID}"/> </h:column> <h:column> <f:facet name="header"> <h:outputText value="ContractID"/> </f:facet> <h:outputText value=" #{item.contractID}"/> </h:column> <h:column> <f:facet name="header"> <h:outputText escape="false" value=" "/> </f:facet> <h:commandLink value="Show" action="#{contractProperty.detailSetup}"> <f:param name="jsfcrud.currentContract" value="#{jsfcrud_class['jpa.util.JsfUtil'].jsfcrud_method['getAsConvertedString'][contract.contract][contract.converter].jsfcrud_invoke}"/> <f:param name="jsfcrud.currentContractProperty" value="#{jsfcrud_class['jpa.util.JsfUtil'].jsfcrud_method['getAsConvertedString'][item][contractProperty.converter].jsfcrud_invoke}"/> <f:param name="jsfcrud.relatedController" value="contract" /> <f:param name="jsfcrud.relatedControllerType" value="jpa.ContractController" /> </h:commandLink> <h:outputText value=" "/> <h:commandLink value="Edit" action="#{contractProperty.editSetup}"> <f:param name="jsfcrud.currentContract" value="#{jsfcrud_class['jpa.util.JsfUtil'].jsfcrud_method['getAsConvertedString'][contract.contract][contract.converter].jsfcrud_invoke}"/> <f:param name="jsfcrud.currentContractProperty" value="#{jsfcrud_class['jpa.util.JsfUtil'].jsfcrud_method['getAsConvertedString'][item][contractProperty.converter].jsfcrud_invoke}"/> <f:param name="jsfcrud.relatedController" value="contract" /> <f:param name="jsfcrud.relatedControllerType" value="jpa.ContractController" /> </h:commandLink> <h:outputText value=" "/> <h:commandLink value="Destroy" action="#{contractProperty.destroy}"> <f:param name="jsfcrud.currentContract" value="#{jsfcrud_class['jpa.util.JsfUtil'].jsfcrud_method['getAsConvertedString'][contract.contract][contract.converter].jsfcrud_invoke}"/> <f:param name="jsfcrud.currentContractProperty" value="#{jsfcrud_class['jpa.util.JsfUtil'].jsfcrud_method['getAsConvertedString'][item][contractProperty.converter].jsfcrud_invoke}"/> <f:param name="jsfcrud.relatedController" value="contract" /> <f:param name="jsfcrud.relatedControllerType" value="jpa.ContractController" /> </h:commandLink> </h:column> </h:dataTable> </h:panelGroup>
Since the code is netbeans generated i'm little behind of understanding it, but i'm doing my best to chew trought it...
Last edited by kohuke; Aug 27th, 2008 at 1:04 pm.
![]() |
Similar Threads
- How to insert data into database? (JSP)
- Please help with JSP mysql update query (JSP)
- mysql+jsp (JSP)
- Displaying Images( buffered data ) from the Database using Java (Java)
- problem in inserting data in msaccess (JSP)
- Problem adding registration data to mysql database (JSP)
- Problem inserting data into database (JSP)
- Inserting uft8 strings into MySQL from jsp page (JSP)
- Please help(Problem in insertion data to database) (JSP)
Other Threads in the JSP Forum
- Previous Thread: LoginScript using JSP-Session
- Next Thread: jsp exception
| Thread Tools | Search this Thread |
apache backbutton combobox connection database development directorystructure dynamicpagetitles eclipse frames glassfish imagetodatabse imageupload internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 network parameters passing ping printinserverinsteadofclient redirect request.getparameter response servlet servletdopost()readxml sessions software ssl state_saving_method stocks sun tomcat tutorial video web





