基于之前的功能进一步优化,添加了登录功能。。
一.首先,是用户类的创建
1.在com.bean包下新建User类,并设置getter,setter方法,以及无参构造函数
属性包括:
private String id;//编号
private String username;//用户名
private String password;//密码
private String name;//昵称
代码:
package com.bean;
public class User {
private String id;//编号
private String username;//用户名
private String password;//密码
private String name;//昵称
public User() {
// TODO Auto-generated constructor stub
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
二.用户数据库的创建
1.在数据库下新建users表,字段如下:
2.初始用户
三.新建用户工具类
1.在com.dao包下新建userDAOI类
类中应包含用户登录,获取用户信息等方法这里就写了两个UserLogin,getUserByusername
代码:
package com.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.bean.User;
import com.util.DBConnection;
public class userDAO {
//处理用户登录
public boolean userLogin(String username,String password)
{
if(getUsersByUsernaem(username, password)!=null)
{
return true;
}
else
{
return false;
}
}
// 根据用户名密码获取用户,用于登錄,并返回信息
public User getUsersByUsernaem(String username, String password) {
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = "select * from users where username = ? and password = ?";
try {
con = DBConnection.getConnection();
stmt = con.prepareStatement(sql);
stmt.setString(1, username);
stmt.setString(2, password);
rs = stmt.executeQuery();
if(rs.next())
{
User user = new User();
user.setId(rs.getString(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setName(rs.getString(4));
return user;
}
else
{
return null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
finally
{
//釋放數據集
if(rs!=null)
{
try {
rs.close();
rs = null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//释放SQl语句
if(stmt!=null)
{
try {
stmt.close();
stmt = null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}