这是我以前的一个dao类，你看看有帮助没package dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import util.DBUtil;import entity.User;public class UserDAO { private static final String SAVE_SQL = "insert into web055_user(username,password,realname,sex) values(?,?,?,?)"; private static final String FIND_SQL = "select * from web055_user where username = ?"; public void save(User user){ System.out.println("-------------"); System.out.println(user.getUsername()); System.out.println(user.getRealname()); System.out.println(user.getPassword()); System.out.println(user.getSex()); System.out.println("-------------"); Connection conn = DBUtil.getConnection(); try { PreparedStatement prep = conn.prepareStatement(SAVE_SQL); prep.setString(1, user.getUsername()); prep.setString(2, user.getPassword()); prep.setString(3, user.getRealname()); prep.setString(4, user.getSex()); prep.execute(); prep.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } public void delete(long id){ } public void modify(User user){ } public User findByUsername(String username) { User user = null; Connection conn = DBUtil.getConnection(); PreparedStatement prep; try { prep = conn.prepareStatement(FIND_SQL); prep.setString(1, username); prep.executeQuery(); ResultSet rs = prep.getResultSet(); if(rs.next()){ user = new User(); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setRealname(rs.getString("realname")); user.setSex(rs.getString("sex")); } rs.close(); prep.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } return user; }}
