实训记录（二）：登录注册（一）

用户信息存储

用户信息存储在mysql数据库中，存储格式如下：

用户实体构造

 public class UserBean {
String sid;
String sname;
String snum;
String sclass;
String pwd;
public String getSid(){return sid;}
public void setSid(String sid){this.sid=sid;}
public String getSname(){return sname;}
public void setSname(String sname){this.sname=sname;}
public String getSnum(){return snum;}
public void setSnum(String snum){this.snum=snum;}
public String getSclass(){return sclass;}
public void setSclass(String sclass){this.sclass=sclass;}
public String getPwd(){return pwd;}
public void setPwd(String pwd){this.pwd=pwd;}
}

连接数据库

public static final String DBDRIVER = "com.mysql.jdbc.Driver";
public static final String DBURL = "jdbc:mysql://localhost:3306/correct?useUnicode=true&characterEncoding=utf8";
public static final String DBUSER = "root";
public static final String DBPASS = "123456";
private static PreparedStatement ps = null;
private static Connection conn = null;
private ResultSet rs;

public static Connection getConnection() {
 conn = null;
  try {
   	 Class.forName(DBDRIVER);
   	 conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
} catch (ClassNotFoundException e) {
    e.printStackTrace();
} catch (SQLException e) {
    e.printStackTrace();
}
return conn;
}

下一步工作

完善注册登录的方法，主要是对数据库内学生信息的信息查找、信息插入，以及与前端的交互。