java实例dao设计出模式_JavaWeb DAO设计模式

package com.chun.dao;

import java.util.List;

/*DAO接口*/

public interface UserDAO {

/*添加操作*/

public void insert(User user) throws Exception;

/*修改操作*/

public void update(User user) throws Exception;

/*删除操作*/

public void delete(String userName) throws Exception;

/*按姓名查询操作*/

public User querryByName(String userName) throws Exception;

/*查询全部*/

public List querryAll() throws Exception;

}

<4>DAO实现类

package com.chun.dao;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

public class UserDAOImpl implements UserDAO{

/*删除操作*/

public void delete(String userName) throws Exception {

String sql = "DELETE FROM login WHERE username=?";

PreparedStatement pstmt = null;

DataBaseConnection dbc =null;

try {

dbc = new DataBaseConnection();

pstmt = dbc.getConnection().prepareStatement(sql);

pstmt.setString(1, userName);

pstmt.executeUpdate();

pstmt.close();

} catch (Exception e) {

throw new Exception("操作出现异常");

}

finally{

dbc.close();

}

}

public void insert(User user) throws Exception {

String sql = "INSERT INTO login(username,userpassword) VALUES (?,?)";

PreparedStatement pstmt = null;

DataBaseConnection dbc = null;

try {

dbc = new DataBaseConnection();

pstmt = dbc.getConnection().prepareStatement(sql);

pstmt.setString(1, user.getUsername());

pstmt.setString(2, user.getUserpassword());

//进行数据库更新操作

pstmt.executeUpdate();

pstmt.close();

} catch (Exception e) {

throw new Exception("操作出现异常");

}

finally{

dbc.close();

}

}

public List querryAll() throws Exception {

List all = new ArrayList();

String sql = "SELECT * FROM login";

ResultSet rs = null;

PreparedStatement pstmt = null;

DataBaseConnection dbc = null;

try {

dbc = new DataBaseConnection();

pstmt = dbc.getConnection().prepareStatement(sql);

rs = pstmt.executeQuery();

while (rs.next()) {

User user = new User();

user.setUsername(rs.getString(1));

user.setUserpassword(rs.getString(2));

all.add(user);

}

rs.close();

pstmt.close();

} catch (Exception e) {

throw new Exception("操作出现异常");

}finally{

dbc.close();

}

return all;

}

public User querryByName(String userName) throws Exception {

String sql = "SELECT * FROM login WHERE username=?";

User user = null;

PreparedStatement pstmt = null;

DataBaseConnection dbc = null;

ResultSet rs = null;

try {

dbc = new DataBaseConnection();

pstmt = dbc.getConnection().prepareStatement(sql);

pstmt.setString(1, userName);

rs = pstmt.executeQuery();

if(rs.next())

{

user = new User();

user.setUsername(rs.getString(1));

user.setUserpassword(rs.getString(2));

}

rs.close();

pstmt.close();

} catch (Exception e) {

throw new Exception("操作出现异常");

}

finally{

dbc.close();

}

return user;

}

public void update(User user) throws Exception {

String sql = "UPDATE login SET username=?,userpassword=?";

PreparedStatement pstmt = null;

DataBaseConnection dbc = null;

try {

dbc = new DataBaseConnection();

pstmt = dbc.getConnection().prepareStatement(sql);

pstmt.setString(1, user.getUsername());

pstmt.setString(2, user.getUserpassword());

pstmt.executeUpdate();

pstmt.close();

} catch (Exception e) {

throw new Exception("操作出现异常");

}finally{

dbc.close();

}

}

}