不知道lz说的是不是这个意思 jsp: <html:text property="username"> <html:text property="password"> --------------------------------------------------------- LoginForm: public class LoginForm extends ActionForm { private String username; private String password; public ActionErrors validate(ActionMapping mapping,HttpServletRequest request) { // TODO Auto-generated method stub return null; } public void reset(ActionMapping mapping, HttpServletRequest request) { // TODO Auto-generated method stub } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } } -------------------------------------------- LoginAction: LoginForm loginForm = (LoginForm) form; loginForm.getUsername(); loginForm.getPassword();
可以用模糊查询 like (%%)
有几个查询条件就like几次。不管从网页上得来的值是否为空,在后面的where条件中用关键字like作为查询条件。 比如:有三个查询条件: select * from table1 where id like (:id) and username like (:username) and password like (:password)
jsp:
<html:text property="username">
<html:text property="password">
---------------------------------------------------------
LoginForm:
public class LoginForm extends ActionForm {
private String username;
private String password;
public ActionErrors validate(ActionMapping mapping,HttpServletRequest request) {
// TODO Auto-generated method stub
return null;
} public void reset(ActionMapping mapping, HttpServletRequest request) {
// TODO Auto-generated method stub
} public String getPassword() {
return password;
} public void setPassword(String password) {
this.password = password;
} public String getUsername() {
return username;
} public void setUsername(String username) {
this.username = username;
}
}
--------------------------------------------
LoginAction:
LoginForm loginForm = (LoginForm) form;
loginForm.getUsername();
loginForm.getPassword();
like (%%)
比如:有三个查询条件:
select * from table1 where id like (:id) and username like (:username) and password like (:password)