关于struts数据库的问题，在线等，麻烦高手指点一下。

yb1682003 2004-11-22 11:16:21

http://community.csdn.net/Expert/topic/3549/3549162.xml?temp=2.086818E-03

我按这里的配置做了，也没有效果。
我把里面的全部放上，麻烦哪位搞过的高手帮我一下。
loginAction:
package mvc.action;

import mvc.form.*;
import org.apache.struts.action.*;
import javax.servlet.http.*;
import javax.sql.DataSource;
import java.sql.*;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class loginAction extends Action {
public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception{
/**@todo: complete the business logic here, this is just a skeleton.*/
loginForm loginForm = (loginForm) actionForm;
String name=loginForm.getName();
String password=loginForm.getPassword();
String sql="select name from login where name='"+name+"',password='"+password+"'";
javax.sql.DataSource ds;
java.sql.Connection myConnection;
Statement s=null;
ResultSet rs=null;
HttpSession session=httpServletRequest.getSession();
ActionErrors errors=new ActionErrors();
ds = getDataSource(httpServletRequest,"B");
myConnection = ds.getConnection();
s=myConnection.createStatement();
rs=s.executeQuery(sql);
if(rs.next()){
session.setAttribute("user",name);
return actionMapping.findForward("index");
}
else
{
errors.add("loginError",new ActionError("login.form.loginError"));
saveErrors(httpServletRequest,errors);
return (new ActionForward(actionMapping.getInput()));
}

}
}

login.jsp
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ page contentType="text/html; charset=GB2312" %>
<html:html locale="true">
<head>
<title>
<bean:message key="login.form.title"/>
</title>
<html:base/>
</head>
<body>
<html:errors/>
<html:form action="/loginAction.do" method="POST" focus="name">
<table align="center"><tr><td>
<bean:message key="login.form.name"/></td><td>
<html:text property="name"/></td></tr><tr>
<td>
<bean:message key="login.form.password"/></td><td>
<html:password property="password"/></td></tr><tr>
<td>
<html:submit property="submit" value="Submit"/>
<html:reset value ="Reset"/></td></tr></table>
</html:form>
</body>
</html:html>

Formbean:
package mvc.modle;

import java.sql.*;
import javax.sql.DataSource;
import javax.servlet.http.*;

/**
* <p>Title: web project</p>
* <p>Description: first web project</p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: yixing</p>
* @author yangbin
* @version 1.0
*/

public class login {
private String name,password;

public login() {
}

public String getName(){
return name;
}
public String getPassword(){
return password;
}
public void setName(String name){
this.name=name;
}
public void setPassword(String password){
this.password=password;
}

/*valition boolean;
*input String;
*output boolean;
*此为验证登陆字符串是否在数据库当中有。
*/
public boolean valition(HttpServletRequest request){
return true;
}

}
struts-config:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">
<struts-config>
<data-sources>
<data-source key="A" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="con.microsoft.jdbc.sqlerver.SQLServerDriver"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"/>
<set-property property="userName" value="sa"/>
<set-property property="password" value="yb1682003"/>
<set-property property="maxActive" value="5"/>
<set-property property="maxWait" value="5000"/>
<set-property property="defaultAuto" value="true"/>
<set-property property="defaultReadOnly" value="false"/>
</data-source>
<data-source key="B" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="autoCommit" value="true"/>
<set-property property="description" value="MySql Data Source"/>
<set-property property="driverName" value="org.git.mm.mysql.Driver"/>
<set-property property="maxCount" value="10"/>
<set-property property="minCount" value="3"/>
<set-property property="user" value="root"/>
<set-property property="password" value="yb1682003"/>
<set-property property="url" value="jdbc:mysql://localhost:3306/mydb"/>
</data-source>
</data-sources>
<form-beans>
<form-bean name="loginForm" type="mvc.form.loginForm" />
</form-beans>

<action-mappings>
<action input="/login.jsp" name="loginForm" path="/loginAction" scope="request" type="mvc.action.loginAction" validate="true">
<forward name="index" path="/index.jsp"/>
</action>
</action-mappings>
</struts-config>
我想问的是，我的数据池有没有配对。要是有配对为何我在访问时跳到loingAction.do后就不能去跳到index.jsp或login.jsp了？？？

...全文

85 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

yzhxy2002 2004-12-06

打赏
举报

http://www.cnpoint.com/MenuAction.do?action=main

kui 2004-12-05

打赏
举报

100分，帮UP一下，
Struts论坛：http://www.javawebstudio.com/

yb1682003 2004-11-22

打赏
举报

里面的beanForm不是
应该是：
package mvc.form;

import org.apache.struts.action.*;
import javax.servlet.http.*;

public class loginForm extends ActionForm {
private String name;
private String password;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public ActionErrors validate(ActionMapping actionMapping, HttpServletRequest httpServletRequest) {
/**@todo: finish this method, this is just the skeleton.*/
ActionErrors errors=new ActionErrors();
if((name==null)||(name.length()<1)){
errors.add("name",new ActionError("login.form.name.error"));
}
if((password==null)||(password.length()<1)){
errors.add("password",new ActionError("login.form.password.error"));
}
return errors;
}
public void reset(ActionMapping actionMapping, HttpServletRequest httpServletRequest) {
name=null;
password=null;
}
}