我正在研究一个JSF表单原型,以使用AJAX数据验证将数据插入数据库表中。这是JSF页面:
<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"
xmlns:h="http://java.sun.com/jsf/html"
xmlns:f="http://java.sun.com/jsf/core"
xmlns:ui="http://java.sun.com/jsf/facelets">
<h:head>
<ui:insert name="header">
<ui:include src="header.xhtml"/>
</ui:insert>
</h:head>
<h:body>
<h1><img src="resources/css/images/icon.png" alt="NVIDIA.com" /> History Center</h1>
<!-- layer for black background of the buttons -->
<div id="toolbar" style="margin: 0 auto; width:1180px; height:30px; position:relative; background-color:black">
<!-- Include page Navigation -->
<ui:insert name="Navigation">
<ui:include src="Navigation.xhtml"/>
</ui:insert>
</div>
<div id="logodiv" style="position:relative; top:35px; left:0px;">
<h:graphicImage alt="Demo Insert Form" style="position:relative; top:-20px; left:9px;" value="resources/images/logo_databasez.png" />
</div>
<div id="main" style="margin: 0 auto; width:1190px; height:700px; position:absolute; background-color:transparent; top:105px">
<div id="mainpage" style="margin: 0 auto; width:1190px; height:500px; position:absolute; background-color:transparent; top:80px">
<div id="settingsHashMap" style="width:350px; height:400px; position:absolute; background-color:r; top:20px; left:1px">
<h:form>
<div id="settingsdiv" style="width:750px; height:400px; position:absolute; background-color:r; top:20px; left:1px">
<h:panelGrid columns="2">
<h:panelGroup>Session ID</h:panelGroup>
<h:panelGroup>
<h:inputText id="sessionid" value="#{DatabaseController.formMap['sessionid']}" >
<f:validateLength minimum="0" maximum="15"/>
<f:ajax render="sessionidvalidate" event="blur"/>
</h:inputText>
<h:outputText id="sessionidvalidate" rendered="#{DatabaseController.validateSessionid}" value="session is already registered" />
</h:panelGroup>
<h:panelGroup>User ID</h:panelGroup>
<h:panelGroup>
<h:inputText id="userid" value="#{DatabaseController.formMap['userid']}" >
<f:validateLength minimum="0" maximum="15"/>
</h:inputText>
</h:panelGroup>
<h:panelGroup>Login Time</h:panelGroup>
<h:panelGroup>
<h:inputText id="logintime" value="#{DatabaseController.formMap['logintime']}" >
<f:validateLength minimum="0" maximum="35"/>
</h:inputText>
</h:panelGroup>
<h:panelGroup>Last Refresh Time</h:panelGroup>
<h:panelGroup>
<h:inputText id="lastrefreshtime" value="#{DatabaseController.formMap['lastrefreshtime']}" >
<f:validateLength minimum="0" maximum="35"/>
</h:inputText>
</h:panelGroup>
<h:panelGroup>User IP</h:panelGroup>
<h:panelGroup>
<h:inputText id="userip" value="#{DatabaseController.formMap['userip']}" >
<f:validateLength minimum="0" maximum="15"/>
</h:inputText>
</h:panelGroup>
</h:panelGrid>
</div>
<div id="settingstwodiv" style="width:150px; height:60px; position:absolute; background-color:transparent; top:380px; left:800px">
<h:commandButton value="Create User" action="#{DatabaseController.saveData}"/>
</div>
</h:form>
</div>
</div>
</div>
</h:body>
</html>
这是托管bean:
import java.io.Serializable;
import javax.enterprise.context.SessionScoped;
// or import javax.faces.bean.SessionScoped;
import javax.inject.Named;
/* include SQL Packages */
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.HashMap;
import javax.annotation.PostConstruct;
import javax.sql.DataSource;
import javax.annotation.Resource;
import javax.faces.context.FacesContext;
import javax.inject.Inject;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
// or import javax.faces.bean.ManagedBean;
import org.glassfish.osgicdi.OSGiService;
// Demo Insert Form
@Named("DatabaseController")
@SessionScoped
public class Database implements Serializable {
private HashMap<String, String> formMap = new HashMap<>();
public Database() {
}
/* Call the Oracle JDBC Connection driver */
@Resource(name = "jdbc/Oracle")
private DataSource ds;
public HashMap<String, String> getformMap() {
return formMap;
}
/*
CREATE TABLE ACTIVESESSIONS(
SESSIONID VARCHAR2(30 ) NOT NULL,
USERID VARCHAR2(30 ) NOT NULL,
LOGINTIME TIMESTAMP(6),
LASTREFRESHTIME TIMESTAMP(6),
USERIP VARCHAR2(30 )
)
/
*/
@PostConstruct
public void hashMapGenerate() {
/* Initialize the hashmap */
formMap.put("sessionid", null);
formMap.put("userid", null);
formMap.put("logintime", null);
formMap.put("lastrefreshtime", null);
formMap.put("userip", null);
}
public int saveData() throws SQLException, java.text.ParseException {
// formMap = new HashMap<String, String>();
String SqlStatement = null;
if (ds == null) {
throw new SQLException();
}
Connection conn = ds.getConnection();
if (conn == null) {
throw new SQLException();
}
PreparedStatement ps = null;
/*
CREATE TABLE ACTIVESESSIONS(
SESSIONID VARCHAR2(30 ) NOT NULL,
USERID VARCHAR2(30 ) NOT NULL,
LOGINTIME TIMESTAMP(6),
LASTREFRESHTIME TIMESTAMP(6),
USERIP VARCHAR2(30 )
)
/
*/
try {
conn.setAutoCommit(false);
boolean committed = false;
try { /* insert into Oracle the default system(Linux) time */
SqlStatement = "INSERT INTO ACTIVESESSIONS"
+ " (SESSIONID, USERID, LOGINTIME, LASTREFRESHTIME, USERIP)"
+ " VALUES (?, ?, ?, ?, ?)";
ps = conn.prepareStatement(SqlStatement);
ps.setString(1, formMap.get("sessionid"));
ps.setString(2, formMap.get("userid"));
ps.setTimestamp(3, toTimeStamp(formMap.get("logintime")));
ps.setTimestamp(4, toTimeStamp(formMap.get("lastrefreshtime")));
ps.setString(5, formMap.get("userip"));
ps.executeUpdate();
conn.commit();
committed = true;
}
finally
{
if (!committed) {
conn.rollback();
}
}
} finally {
/* Release the resources */
ps.close();
conn.close();
}
return 0;
}
private Timestamp toTimeStamp(String s) throws java.text.ParseException
{
Timestamp ts = null;
java.util.Date date = null;
if (s == null || s.trim().isEmpty()) return ts;
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss.S");
date = (java.util.Date) sdf.parse(s);
ts = new Timestamp(date.getTime());
return ts;
}
/* Validators section */
public boolean getvalidateSessionid(){
//do SQL query
return true;
}
}
我在实施表单验证时遇到困难。我想将使用过的字符串输入,并将其检查到数据库中,该值是否已进入数据库表中。在这里,我正在调用Java方法来检查值:
<h:panelGroup>
<h:inputText id="sessionid" value="#{DatabaseController.formMap['sessionid']}" >
<f:validateLength minimum="0" maximum="15"/>
<f:ajax render="sessionidvalidate" event="blur"/>
</h:inputText>
<h:outputText id="sessionidvalidate" rendered="#{DatabaseController.validateSessionid}" value="session is already registered" />
</h:panelGroup>
如何将插入的值发送到Java方法?
最好的祝愿
您需要创建一个Validator
。
开球示例:
@FacesValidator("sessionIdValidator")
public class SessionIdValidator implements Validator {
@Override
public void validate(FacesContext context, UIComponent component, Object value) throws ValidatorException {
// ...
if (yourDataService.existSessionId(value)) {
throw new ValidatorException(new FacesMessage(FacesMessage.SEVERITY_ERROR,
"Session ID is already in use, please choose another.", null));
}
}
}
如下使用它:
<h:inputText id="sessionid" value="#{DatabaseController.formMap['sessionid']}">
<f:validateLength minimum="0" maximum="15" />
<f:validator validatorId="sessionIdValidator" />
<f:ajax event="blur" render="sessionidMessage" />
</h:inputText>
<h:message id="sessionidMessage" for="sessionid" />
请注意,您应该使用<h:message>
显示验证消息。您认为没有任何人。将其应用于所有其他字段:
<h:inputText id="userid" value="#{DatabaseController.formMap['userid']}">
<f:validateLength minimum="0" maximum="15" />
<f:ajax event="blur" render="useridMessage" />
</h:inputText>
<h:message id="useridMessage" for="userid" />
如果你想使用@Resource
或@EJB
或@Inject
在验证,则更换@FacesValidator
的注解@ManagedBean
或(如你似乎使用CDI出于某种原因)@Named
:
@Named
public class SessionIdValidator implements Validator {
@Resource
private DataSource dataSource;
@Inject
private YourDataService yourDataService;
// ...
}
并如下使用它
<f:validator binding="#{sessionIdValidator}" />
主要内容:实例以下代码显示了如何使用创建表。 打开NetBeans,创建一个名称为:UIRepeat 的Web项目,其结构如下所示 - 实例 以下是文件: 文件中的代码 - 以下是文件: 文件中的代码 - 运行项目 在UIRepeat 项目上点击右键,选择 【运行】,在Tomcat启动完成后,打开浏览器访问以下地址: 如果程序没有错误,应该会看到如下界面 -
本文向大家介绍如何使用CSS和JavaScript创建密码验证表单?,包括了如何使用CSS和JavaScript创建密码验证表单?的使用技巧和注意事项,需要的朋友参考一下 要使用CSS和JavaScript创建密码验证表单,代码如下- 示例 输出结果 上面的代码将产生以下输出- 在输入用户名和密码-
我必须使用laravelajax将数据保存在具有userid的数据库表中。谁能帮我解决这个问题 我的控制器代码 它得到的反应是 我必须保存登录用户ID提交......我user_id空我怎么存储user_id请帮帮我。 提前谢谢
首先,我很抱歉在这里问这样的问题,但是如果您以前从未参与过symfony项目,symfony文档不会提供太多完整的示例。 因此,我已经安装了symfony/security包,并且在本教程中开始了类似的工作https://symfony.com/doc/current/security/form_login_setup.html 包裹/security.yaml 登录路径和检查路径是我的安全控制器
问题内容: 当组件失去使用ajax的焦点而不是等待手动提交表单时,如何在输入组件上触发验证? 问题答案: 在组件中放置一个,可重新呈现与该组件相关联的。 另请参阅有关Eclipse和Tomcat的JSF 2.0教程- 视图 和微调验证
我这样创建了自己的存储库: 那么问题是如何自动为此创建cassandra表呢?目前Spring注入,它试图将实体插入到不存在的表中。 那么,有没有办法在Spring容器启动期间创建卡桑德拉表(如果它们不存在)? P.S.如果只有config boolean属性,而没有添加xml行和创建类似BeanFactory等的东西,那将非常好:-)