preparedStatemen.setString(1, user.getName()); preparedStatemen.setInt(3, user.getId());
preparedStatemen.setString(2, user.getPassword());
int result = preparedStatemen.executeUpdate(); if (result != 0) {
int result = preparedStatemen.executeUpdate(); if (result != 0) {
System.out.println("成功修改" + result + "条记录"); } else { } System.out.println("0条记录被修改，修改失败");
sql.append(" SET password = ? "); sql.append(" WHERE id = ? ");
connection = ConnectionFacroty.getConnection(); connection.prepareStatement(sql.toString()); preparedStatemen =
connection = ConnectionFacroty.getConnection(); StringBuffer sql = new StringBuffer(); sql.append(" FROM tb_user ");
sql.append(" SELECT id,name,password "); sql.append(" WHERE name = ? ");
public void setPassword(String password) { } this.password = password;
public User(String name, String password) { super(); = name; }
this.password = password;
}
return null;
@Override
ClassNotFoundException{ try {
public User findByNameAndPassword(String name,String password)throws
StringBuffer sql = new StringBuffer(); sql.append(" FROM tb_user ");
import erDAO;
import er;
import com.zuijiajiao.servlab.DatabaseWEB.JDBC.ConnectionFacroty; public class UserDAOImpl implements UserDAO { Connection connection = null; ResultSet resultSet = null; @Override try {
public Serializable save(User user)throws ClassNotFoundException; public User get(Serializable id)throws ClassNotFoundException; }
UserDaoImpl.java
package com.zuijiajiao.servlab.DatabaseWEB.DAOImpl; import java.io.Serializable; import java.sql.Connection; import java.sql.ResultSet; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.ArrayList; import java.util.List;
import er; public interface UserDAO { public void delete(User user)throws ClassNotFoundException; public void update(User user)throws ClassNotFoundException; public List<User> findAll(String name,String password) throws
ConnectionFacroty.close(connection, preparedStatemen,
@Override
ClassNotFoundException { try {
public List<User> findAll(String name, String password) throws
preparedStatemen.setString(2, password); resultSet = preparedStatemen.executeQuery(); User user = new User(); while (resultSet.next()) { // if(resultSet.next()){ user.setName(resultSet.getString(name));
sql.append(" SELECT id,name,password "); sql.append(" WHERE name = ? ");
sql.append(" AND password = ? "); connection = ConnectionFacroty.getConnection(); connection.prepareStatement(sql.toString()); preparedStatemen.setString(1, name); preparedStatemen =
PreparedStatement preparedStatemen = null;
public void delete(User user) throws ClassNotFoundException { StringBuffer sql = new StringBuffer(); sql.append(" DELETE * FROM tb_user "); sql.append(" WHERE ? = ? ");
resultSet = preparedStatemen.executeQuery(); List<User> users = new ArrayList<User>(); while (resultSet.next()) {
User user = new User();
user.setName(resultSet.getString(name)); user.setId(resultSet.getInt("id")); users.add(user); } return users;
public void setId(Integer id) { } this.id = id;
public String getName() { } return name;
public void setName(String name) { } = name;
public String getPassword() { } return password;
user.setPassword(resultSet.getString(password));
} catch (SQLException e) { } finally { resultSet); } e.printStackTrace();
ConnectionFacroty.close(connection, preparedStatemen,
User.java
package com.zuijiajiao.servlab.DatabaseWEB.DTO; public class User {
private String name; private Integer id;
private String password;
public Integer getId() { } return id;
System.out.println("成功修改" + result + "条记录"); } else { } System.out.println("0条记录被修改，修改失败");
} catch (SQLException e) { } finally { resultSet); } } e.printStackTrace();
user.setPassword(resultSet.getString(password)); user.setId(resultSet.getInt("id")); } return user;
} catch (SQLException e) { } finally { resultSet); } e.printStackTrace();
} catch (SQLException e) { } finally { resultSet); } } e.prinoty.close(connection, preparedStatemen,
@Override try {
public void update(User user) throws ClassNotFoundException { StringBuffer sql = new StringBuffer(); sql.append(" UPDATE tb_user "); sql.append(" SET name = ? ");