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>
聯(lián)系客服