package com.szc.bean;
/**
* UserBean
* userid对应admin表中的新增字段a_id
* username对应admin表中的a_name
* userpass对应admin表中的a_pass
*
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class UserBean {
private String userid;
private String username;
private String userpass;
//为每个属相定义getter、setter方法
public String getUserid() {
return userid;
}
public void setUserid(String userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserpass() {
return userpass;
}
public void setUserpass(String userpass) {
this.userpass = userpass;
}
/**
* 返回一个Connection对象
* @return
*/
public Connection getConnect(){
Connection conn;
String user="root";
String password="1";
try {
Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动
String strConn="jdbc:mysql://localhost:3306/mld";//定义数据库连接字符串
//获取数据库连接实例Connection
conn=DriverManager.getConnection(strConn,user,password);
} catch (ClassNotFoundException e) {
return null;
} catch (SQLException e) {
return null;
}
return conn;
}
/**
* 验证用户名密码是否一致
* @param userid
* @param userpass
* @return
*/
public int check(String userid,String userpass){
//获取数据库连接实例Connection
Connection conn=getConnect();
Statement stmt=null;
ResultSet rs=null;
//定义数据库查询语句,根据userid查询userpass
String sql="SELECT user_pass FROM mData WHERE user_id='"+userid+"'";
try {
stmt= conn.createStatement();
rs = stmt.executeQuery(sql);
if(!rs.next()){//如果没查到记录
return 0;//没有此用户
}
//判断查到的密码是否与输入密码一致
if(!rs.getString("user_pass").equals(userpass)){
return 2;//密码错误
}
} catch (SQLException e) {
return 0;
}finally{
//关闭
if(conn!=null){
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
}
}
}
return 1;
}
/**
*
* @param userid
* @return
*/
public String getUsername(String userid){
Connection conn=getConnect();
String username=null;
Statement stmt=null;
ResultSet rs=null;
//定义数据库查询语句,根据userid查找username
String sql="SELECT user_name FROM mData WHERE user_id='"+userid+"'";
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if(!rs.next()){//结果指针移到第一条记录
return null;
}
username=rs.getString("user_name");
} catch (SQLException e) {
return null;
}finally{
//关闭
if(conn!=null){
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
}
}
}
return username;
}
}
/**
* UserBean
* userid对应admin表中的新增字段a_id
* username对应admin表中的a_name
* userpass对应admin表中的a_pass
*
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class UserBean {
private String userid;
private String username;
private String userpass;
//为每个属相定义getter、setter方法
public String getUserid() {
return userid;
}
public void setUserid(String userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserpass() {
return userpass;
}
public void setUserpass(String userpass) {
this.userpass = userpass;
}
/**
* 返回一个Connection对象
* @return
*/
public Connection getConnect(){
Connection conn;
String user="root";
String password="1";
try {
Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动
String strConn="jdbc:mysql://localhost:3306/mld";//定义数据库连接字符串
//获取数据库连接实例Connection
conn=DriverManager.getConnection(strConn,user,password);
} catch (ClassNotFoundException e) {
return null;
} catch (SQLException e) {
return null;
}
return conn;
}
/**
* 验证用户名密码是否一致
* @param userid
* @param userpass
* @return
*/
public int check(String userid,String userpass){
//获取数据库连接实例Connection
Connection conn=getConnect();
Statement stmt=null;
ResultSet rs=null;
//定义数据库查询语句,根据userid查询userpass
String sql="SELECT user_pass FROM mData WHERE user_id='"+userid+"'";
try {
stmt= conn.createStatement();
rs = stmt.executeQuery(sql);
if(!rs.next()){//如果没查到记录
return 0;//没有此用户
}
//判断查到的密码是否与输入密码一致
if(!rs.getString("user_pass").equals(userpass)){
return 2;//密码错误
}
} catch (SQLException e) {
return 0;
}finally{
//关闭
if(conn!=null){
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
}
}
}
return 1;
}
/**
*
* @param userid
* @return
*/
public String getUsername(String userid){
Connection conn=getConnect();
String username=null;
Statement stmt=null;
ResultSet rs=null;
//定义数据库查询语句,根据userid查找username
String sql="SELECT user_name FROM mData WHERE user_id='"+userid+"'";
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if(!rs.next()){//结果指针移到第一条记录
return null;
}
username=rs.getString("user_name");
} catch (SQLException e) {
return null;
}finally{
//关闭
if(conn!=null){
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
}
}
}
return username;
}
}