1.數(shù)據(jù)庫(kù)連接

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBCon {
public static Connection getConnection()
{
   String url="jdbc:microsoft:sqlserver://localhost;databaseName=book_shop" ;
   String user="sa";
   String psw="sa";
   Connection conn=null;
   try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  
   }catch(ClassNotFoundException e)
   {
    e.printStackTrace();
   }
   try{
    conn=DriverManager.getConnection(url,user,psw);
    conn.setAutoCommit(false);
    return conn;
   }catch(SQLException e)
   {
    e.printStackTrace();
   }
   return null;
}
}
2.userbean

public class User {
private String username;
private String userpsw;
public String getUsername()
{
   return username;
}
public void setUsername(String username)
{
   this.username=username;
 
}
public String getUserpsw()
{
   return userpsw;
}
public void setUserpsw(String userpsw)
{
   this.userpsw=userpsw;
}
}

3.userAction

import com.opensymphony.xwork2.ActionSupport;

public class UserAction extends ActionSupport {
private User user;
private String message;

public User getUser() {
   return user;
}

public void setUser(User user) {
   this.user = user;
}
public String execute() {
   if(UserDao.CheckLogin(this.user))
   {
    return "success";
   }
   return "failure";
}

}
4.userDao

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserDao {
public static boolean CheckLogin(User user) {
   /*
   * if(user.getUsername().equals("admin")
   * &&user.getUserpsw().equals("123456")) { return true; } return false;
   */
   Connection conn = null;
   conn = DBCon.getConnection();
   String userSQL = "select * from user1 where name=? and password=?";
   try {

    PreparedStatement psmt = conn.prepareStatement(userSQL);
    psmt.setString(1, user.getUsername());
    psmt.setString(2, user.getUserpsw());
    ResultSet rs = psmt.executeQuery();

    if (rs.next())
     return true;
   }

   catch (Exception e) {
    e.printStackTrace();
   } finally {
    if (conn != null) {
     try {
      conn.close();

     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
   }
   return false;

}
}
5.jsp 登陸 success error

6.struts 配置

<struts>

    <constant name="struts.enable.DynamicMethodInvocation" value="false" />
    <constant name="struts.devMode" value="false" />
    <constant name="struts.ognl.allowStaticMethodAccess" value="true"></constant>
    <package name="ognl" extends="struts-default">

        <action name="login" class="sunyang.UserAction">
            <result name="success">/success.jsp</result>
            <result name="failure">/error.jsp</result>
        </action>
       

    </package>

7.web.xml

<filter>
        <filter-name>struts2</filter-name>
        <!--<filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class>-->
        <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
    </filter>

    <filter-mapping>
        <filter-name>struts2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</struts>