java dao impl server,ServerUserDaoJDBCImpl.java

package Server;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import utils.JDBCUtil;

public class ServerUserDaoJDBCImpl implements ServerUserDao{

@Override

public boolean writeUser(User user) {

Connection conn = null;

PreparedStatement pstat = null;

String sql = "insert into Users(number,password,netName) values(?,?,?) ";

int result = -1;

try {

conn = JDBCUtil.getConnection();

pstat = conn.prepareStatement(sql);

pstat.setInt(1, user.getNumber());

pstat.setString(2, user.getNetName());

pstat.setString(3, user.getPassword());

pstat.setString(4,user.getSign());

pstat.setString(5,user.getTelephone());

result = pstat.executeUpdate();

}catch (SQLException sqle) {

sqle.printStackTrace();

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtil.realeaseAll(null,pstat, conn);

}

return result>0?true:false;

}

@Override

public User readUser(String name) {

Connection conn = null;

PreparedStatement pstat = null;

ResultSet rs=null;

String sql = "select * from student where name like ?";

User user=null;

try {

conn = JDBCUtil.getConnection();

pstat = conn.prepareStatement(sql);

pstat.setString(1, name);

rs = pstat.executeQuery();

while(rs.next()){

int userNumber=rs.getInt("Number");

String userName=rs.getString("netName");

String userPassword=rs.getString("password");

int userTelephone=rs.getInt("telephone");

String userSign=rs.getString("sign");

}

}catch (SQLException sqle) {

sqle.printStackTrace();

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtil.realeaseAll(null,pstat, conn);

}

return user;

}

@Override

public boolean modifyUsername(User user) {

Connection conn = null;

PreparedStatement pstat = null;

String sql = "UPDATE Users SET netName = ? WHERE number=?";

int result = -1;

try {

conn = JDBCUtil.getConnection();

pstat = conn.prepareStatement(sql);

pstat.setString(1, user.getNetName());

pstat.setInt(2, user.getNumber());

result = pstat.executeUpdate();

}catch (SQLException sqle) {

sqle.printStackTrace();

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtil.realeaseAll(null,pstat, conn);

}

return result>0?true:false;

}

@Override

public boolean modifyPassword(User user) {

Connection conn = null;

PreparedStatement pstat = null;

String sql = "UPDATE Users SET password = ? WHERE number = ?";

int result = -1;

try {

conn = JDBCUtil.getConnection();

pstat = conn.prepareStatement(sql);

pstat.setString(1, user.getPassword());

pstat.setInt(2, user.getNumber());

result = pstat.executeUpdate();

}catch (SQLException sqle) {

sqle.printStackTrace();

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtil.realeaseAll(null,pstat, conn);

}

return result>0?true:false;

}

@Override

public boolean checkUser(User user) {

Connection conn = null;

PreparedStatement pstat = null;

String sql = "select password from Users WHERE number = ?";

ResultSet rs=null;

try {

conn = JDBCUtil.getConnection();

pstat = conn.prepareStatement(sql);

pstat.setInt(1,user.getNumber());

rs = pstat.executeQuery(sql);

while(rs.next()){

if(rs.equals(user.getPassword())){

System.out.println("密码正确");

//可以建立连接……………………

}

else System.out.println("密码错误，请重新输入");

}

}catch (SQLException sqle) {

sqle.printStackTrace();

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtil.realeaseAll(null,pstat, conn);

}

return result>0?true:false;

}

@Override

public User loadUser(int number) {

Connection conn = null;

PreparedStatement pstat = null;

String sql = "select * from Users where number = ?";

ResultSet rs = null;

try {

conn = JDBCUtil.getConnection();

pstat = conn.prepareStatement(sql);

pstat.setInt(1, number);

rs = pstat.executeQuery(sql);

while(rs.next()){

String fileName = rs.getString("fileName");

String netName = rs.getString("netName");

String password = rs.getString("password");

String sign=rs.getString("sign");

String telephone=rs.getString("telephone");

User user = new User(number,password,netName,sign,telephone);

return user;

}

}catch (SQLException sqle) {

sqle.printStackTrace();

}catch(Exception e){

e.printStackTrace();

}finally{

JDBCUtil.realeaseAll(null,pstat, conn);

}

return null;

}

}

一键复制

编辑

Web IDE

原始数据

按行查看

历史