jsp+Struts2 注册 登录 入门demo

package com.jsict.action; import java.io.UnsupportedEncodingException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.jws.soap.SOAPBinding.Use; import javax.servlet.http.HttpServletRequest; import org.apache.struts2.ServletActionContext; import com.jsict.entity.User; import com.opensymphony.xwork2.ActionSupport; import com.opensymphony.xwork2.ModelDriven; public class UserAction extends ActionSupport implements ModelDriven<User> { private User user=new User(); public String login() { boolean is=false; try { is = isExist(user.getUsername(), user.getPassword()); } catch (Exception e) { // TODO: handle exception System.out.println("error"); } if (is) { return "login"; } else { return "unlogin"; } } public String register() { if (user.getSex().equals("1")) { user.setSex("男"); } else { user.setSex("女"); } Connection connection = null; Statement stm = null; PreparedStatement pst = null; try { Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8", "root", "root"); stm = connection.createStatement(); pst = connection.prepareStatement("INSERT INTO user (username,password,email,tel,address,age,sex) VALUES(?,?,?,?,?,?,?)"); pst.setString(1, user.getUsername()); pst.setString(2, user.getPassword()); pst.setString(3, user.getEmail()); pst.setString(4, user.getTel()); pst.setString(5, user.getAddress()); pst.setString(6, user.getAge()); pst.setString(7, user.getSex()); pst.execute(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { stm.close(); connection.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return "register"; } private boolean isExist(String name,String pwd) throws Exception{ Connection connection = null; PreparedStatement statement = null; ResultSet rs = null; //1.加载JDBC驱动 Class.forName("com.mysql.jdbc.Driver"); //2.与数据库建立连接 connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8", "root", "root"); //3.创建Statement或PreparedStatement对象 statement = connection.prepareStatement("select * from user where username=? and password=?"); statement.setString(1, name); statement.setString(2, pwd); rs = statement.executeQuery(); user.setUsername(null); user.setPassword(null); System.out.println(rs); if(rs.next()) { user.setId(rs.getString(1)); user.setUsername(rs.getString(2)); user.setPassword(rs.getString(3)); user.setEmail(rs.getString(4)); user.setTel(rs.getString(5)); user.setAddress(rs.getString(6)); user.setAge(rs.getString(7)); user.setSex(rs.getString(8)); System.out.println(user); } rs.close(); statement.close(); connection.close(); if(name.equals(user.getUsername())) {return true;} return false; } @Override public User getModel() { // TODO Auto-generated method stub return user; } }