Problem in Icefaces Input binding attribute

[syruss kumar]

Hi all,

I have developed a application using jsf and icefaces.
The probelm is i have a page where i want to show the logged username and stored that in a database.

i have created a iface page to show the users like this

  <ice:form>
 	
 	
 	
 		<table align="middle">
 			<tr>
 			<h5 style="color:#000000;font-size:15px;font-weight:bold;font-family:Arial;text-align:center;"></h5>
 			<td><ice:outputText value="User Name:" style="color:#0066CC;font-size:11px;font-weight:bold;text-align:center"/></td>
 			<td><ice:inputText id="userName"  value="#{projectContext.user.name}"/></td>
 			</tr>
 			<tr>
 				<td><ice:outputText value="Schema Name:" style="color:#0066CC;font-size:11px;font-family:Arial;font-weight:bold;" /></td>
 				<td><ice:inputText id="schema" value="#{projectContext.project.projectName}" readonly="true"  /></td>
 			</tr>
 			<tr>
 				<td><ice:outputText value="Rating:" style="color:#0066CC;font-size:11px;font-family:Arial;font-weight:bold;" /></td>
 				
 				<td><ice:selectOneMenu value="#{DBBean.rating}" id="rating">
 				<f:selectItem itemValue="Excellent"/>
 				<f:selectItem itemValue="Better"/>
 				<f:selectItem itemValue="Good"/>
 				</ice:selectOneMenu>
 				</td>
 			</tr>
 			<tr>
 				<td><ice:outputText value="Analysis Name:" style="color:#0066CC;font-size:11px;font-weight:bold;text-align:center"/></td>
 				<td><ice:inputText id="analysisname" value="#{analysisBean.analysisTitle}"   readonly="true" style="color:#0066CC;font-size:11px;font-family:Arial;font-weight:bold;" /></td>
 			</tr>
 			<tr>
 				<td><ice:outputText value="Comment:" style="color:#0066CC;font-size:11px;font-weight:bold;text-align:center"/></td>
 				<td><ice:inputTextarea id="byclassification" value="#{DBBean.byclassification}"  cols="45" rows="2" /></td>
 			</tr>
 			
 			<tr>
 			<td>
 			</td>
 				<td><ice:commandButton action="#{DBBean.insertByClassification}"
 					value="Post comments" type="submit" />
 
 					<ice:commandButton action="back"
 					value="Cancel"  /></td>
 			</tr>
 			
 				
 			
 		</table>
 		
 	</ice:form>
 and my db bean is 
 
 
 public class DBBean
 {
     private String userName;
     private String schema;
     private String rating;
 
     public String getUserName()
     {
         return userName;
     }
 
     public void setUserName(String userName)
     {
         this.userName = userName;
     }
 
     public String getSchema()
     {
         return schema;
     }
 
     public void setSchema(String schema)
     {
         this.schema = schema;
     }
 
     public String getRating()
     {
         return rating;
     }
 
     public void setRating(String rating)
     {
         this.rating = rating;
     }
 
      public String insertByClassification()
     {
         String forward = "failure";
         String analysisName = "ByClassification";
         Calendar cal = new GregorianCalendar();
         String query = (new StringBuilder()).append("insert into reportfeedback values('").append(getUserName()).append("','").append(getSchema()).append("','").append(analysisName).append("','").append(getByclassification()).append("','").append(cal.getTime()).append("','").append(getRating()).append("')").toString();
         try
         {
             Class.forName("com.mysql.jdbc.Driver").newInstance();
             connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/liferaytags", "root", "admin");
             ptsmt = connection.prepareStatement(query);
             boolean result = ptsmt.execute();
             if(!result)
             {
                 forward = "success";
             }
         }
         catch(ClassNotFoundException e)
         {
             e.printStackTrace();
         }
         catch(SQLException e)
         {
             e.printStackTrace();
         }
         catch(InstantiationException e)
         {
             e.printStackTrace();
         }
         catch(IllegalAccessException e)
         {
             e.printStackTrace();
         }
         return forward;
     }
 }  

how can i set this value(value="#{projectContext.user.name}") to a dbbean.userName and entered into database.

I have tried binding attribute in inputtext but its not working

Please suggest me .

[Stephan Hartmann]

Hi,

first you have to declare your DBBean in faces-confiog.xml:

<managed-bean>
<managed-bean-name>dbBean</managed-bean-name>
<managed-bean-class>package.dbBean</managed-bean-class>
<managed-bean-scope>reauest</managed-bean-scope>
</managed-bean>

then you will refer the managed bean in value in your .xhtml : "#{dbBean.userName}"

.. that's it...

...the code above is a sample and not to be copied, check yourself and write yourself to avoid errors...

regards
Stephan