----------------------------------------------------com.abc.dao—UserDao----------------------------------------------
package com.abc.dao;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import com.abc.entity.User;
public class UserDao extends BaseDao{
public int adduser(User user){
int i=0;
Connection conn=null;
PreparedStatement stat=null;
conn=this.getConn();
String sql="insert into user(username,password,address) values(?,?,?)";
try {
stat=conn.prepareStatement(sql);
stat.setString(1, user.getUsername());
stat.setString(2, user.getPassword());
stat.setString(3, user.getAddress());
i=stat.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
this.closeAll(null, stat, conn);
}
return i;
}
public User findById(int id)
{
User user=null;
ResultSet rs=null;
PreparedStatement stat=null;
Connection conn=null;
conn=super.getConn();
String sql="select username,password,address from user where id=?";
try {
stat=conn.prepareStatement(sql);
stat.setInt(1, id);
rs=stat.executeQuery();
while(rs.next())
{
user=new User();
String username=rs.getString(1);
String password=rs.getString(2);
String address=rs.getString(3);