资料备份

package com.easymall.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.easymall.domain.User;
import com.easymall.utils.JDBCUtils;

public class UserDao {
/**

• 添加一条用户信息
• @param user 是用户信息对象

*/
public void addUser(User user) {
Connection conn= null;
PreparedStatement ps= null;
try {
conn=JDBCUtils.getConnection();
ps=conn.prepareStatement(“insert into user values(null,?,?,?,?)”);
ps.setString(1, user.getUsername());
ps.setString(2, user.getPassword());
ps.setString(3, user.getNickname());
ps.setString(4, user.getEmail());

		ps.executeUpdate();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		
		JDBCUtils.close(conn, ps, null);
		
	}
	
	
}

/**

• 根据用户名查询用户

• @param user 用户名

• @return 用户名是否存在的布尔值
  */
  public boolean findUserByUsername(String username) {
  // TODO Auto-generated method stub

  Connection conn = null;
  PreparedStatement ps = null;
  ResultSet rs = null;

  try {
  conn=JDBCUtils.getConnection();
  ps=conn.prepareStatement(“select * from user where username= ?”);

   ps.setString(1, username);
   
   rs = ps.executeQuery();
   if(rs.next()){
  

// 为true则用户名已经存在，不能注册

		return true;
		
	}else{

// 用户名不存在，可以注册
return false;

	}
	
	
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	throw new RuntimeException();
}finally{
	
	JDBCUtils.close(conn,ps,rs);
	
}

}

/**

• 根据用户名和密码查询用户

• @param username 用户名

• @param password 密码

• @return 用户信息对象或null
  */
  public User findUserByUsernameAndPssword(String username, String password) {

  Connection conn = null;
  PreparedStatement ps = null;
  ResultSet rs = null;

  try {
  conn=JDBCUtils.getConnection();
  ps=conn.prepareStatement("select* from user where username=? and password=? ");
  ps.setString(1, username);
  ps.setString(2, password);

   rs=ps.executeQuery();
   if(rs.next()){
   	User user =  new User();
   	user.setUsername(rs.getString("username"));
   	user.setPassword(rs.getString("password"));
   	user.setNickname(rs.getString("nickname"));
   	user.setEmail(rs.getString("email"));
   	return user;
   }else{
   	
   	return null;
   	
   }
  

  } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
  throw new RuntimeException();
  }finally{

   JDBCUtils.close(conn, ps, rs);
  

  }

}

}

package com.easymall.domain;

//封装用户信息的javabean
public class User {

private int id;
private String username;
private String password;
private String nickname;
private String email;

public User(){}

public User(int id, String username, String password, String nickname,
String email) {
super();
this.id = id;
this.username = username;
this.password