//注册action
package com.action;
import com.opensymphony.xwork2.ActionSupport;
import com.action.DBUtil;
import com.bean.*;
import java.sql.*;
public class RegisterAction extends ActionSupport {
private User user=new User();
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
@Override
public String execute() throws Exception {
// TODO Auto-generated method stub
int i=0;
Connection conn=DBUtil.getConnection();
String sql="insert into user values('"+user.getUsername()+"','"+user.getPassword()+"',
'"+user.getSex()+"','"+user.getEmail()+"','"+user.getSignature()+"','1')";
i=DBUtil.excuteSql(sql, conn);
DBUtil.close(conn);
if(i>0)
{
return SUCCESS;
}else
return INPUT;
}
}
//登录action
package com.action;
import java.io.*;
import java.security.Principal;
import java.sql.*;
import java.util.Enumeration;
import java.util.Locale;
import java.util.Map;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletInputStream;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.apache.struts2.ServletActionContext;
import org.apache.struts2.jasper.tagplugins.jstl.core.Out;
import com.error.*;
import com.bean.User;
import com.opensymphony.xwork2.ActionSupport;
public class LoginAction extends ActionSupport{
private User user=new User();
private fieldError fe = new fieldError();
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
public fieldError getFe() {
return fe;
}
public void setFe(fieldError fe) {
this.fe = fe;
}
@Override
public String execute() throws Exception {
// TODO Auto-generated method stub
Connection conn=DBUtil.getConnection();
ResultSet rs = DBUtil.getResultSet("select * from user where username = '"+ user.getUsername()+ "' and grade=1", conn);
if(rs.next())
{
//System.out.println(rs.getString(3));
if(rs.getString(2).equals(user.getPassword()))
{
HttpServletRequest request=ServletActionContext.getRequest();
String name="name";
String password="password";
HttpSession session=request.getSession();
session.setAttribute(name, user.getUsername());
session.setAttribute(password, user.getPass
word());
//System.out.println("weweew");
DBUtil.close(conn);
return SUCCESS;
}
else
{
fe.setLoginerror("用户密码错误,请重新输入!");
DBUtil.close(conn);
return INPUT;
}
}
else
{
fe.setLoginerror("用户不存在,请您
注册!");
DBUtil.close(conn);
return "INPUT1";
}
}
}
//管理员登录action
package com.action;
import java.sql.Connection;
import java.
sql.ResultSet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.ap
ache.struts2.ServletActionContext;
import com.bean.*;
import com.opensymphony.xwork2.ActionSupport;
import com.error.*;
public class AdminLoginAction extends ActionSupport {
private User user=new User();
private fieldError fe = new fieldError();
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
public fieldError getFe() {
return fe;
}
public void setFe(fieldError fe) {
this.fe = fe;
}
@Overri