packagecn.zero.action;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;importcom.opensymphony.xwork2.ActionSupport...
package cn.zero.action;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import com.opensymphony.xwork2.ActionSupport;
import javax.servlet.http.HttpServletRequest;
import cn.zero.service.LoginCheck;
import oracle.jdbc.driver.DBConversion;
import org.apache.struts2.ServletActionContext;
public class LoginAction extends ActionSupport{
private String uname;
private String upassword;
private String msg;
public String getMsg() {
return msg;
}
public void setMsg(String msg) {
this.msg = msg;
}
public LoginAction()
{
}
public String getUname()
{
return uname;
}
public void setUname(String uname)
{
this.uname = uname;
}
public String getUpassword()
{
return upassword;
}
public void setUpassword(String upassword)
{
this.upassword = upassword;
}
public void validate()
{
if (getUname() == null || "".equals(getUname().trim()))
addFieldError("uname", "必须输入用户名");
if (getUpassword() == null || "".equals(getUpassword().trim()))
addFieldError("upassword", "必须输入密码");
}
public String execute() throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "pain", "123");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select *from reguser where user_name='"+this.uname+"' and user_password='"+this.upassword+"'");
try {
if(!rs.next()){
this.msg="用户名或密码不正确";
return "error";
}
else
return "success";
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}
展开