}
}
if(psmt != null){
try {
psmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
@Override
public String execute() {
System.out.println(user.getUsername()+"1111");
System.out.println(user.getPassword()+"1111");
UserDAO dao=new UserDAO();
con=dao.getConnection();
try {
psmt =con.prepareStatement("select * from userinfo where username= and password= ");
psmt.setString(1, user.getUsername());
psmt.setString(2, user.getPassword());
rs=psmt.executeQuery();
if(rs.next())
{
System.out.println(user.getUsername()+"第2222次");
System.out.println(user.getPassword()+"第2222次");
return SUCCESS;
}
else
{
return ERROR;
}
} catch (SQLException e) {
e.printStackTrace();
return ERROR;
}
finally
{
if(con != null){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(psmt != null){
try {
psmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public User getModel() {
// TODO Auto-generated method stub
return user;
}
}
package xuyan.com.action;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import xuyan.com.model.User;
import xuyan.com.model.UserDAO;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
public class LoginAction extends ActionSupport implements ModelDriven
/**
*
*/
private static final long serialVersionUID = 1L;
User user=new User();
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
private Connection con=null;
private ResultSet rs=null;
private PreparedStatement psmt=null;
/**
* 用户注册
*
*/
public String Login()
{
System.out.println(user.getUsername()+"1111");
System.out.println(user.getPassword()+"1111");
UserDAO dao=new UserDAO();
con=dao.getConnection();
try {
psmt =co