建立一个dao接口,建立一个dao实现类
public interface CustomerDao {
//插入方法,传一个Customer对象进去
public void insert(Customer custname);
//根据名字查询
public Customer selectByName(String custname);
//根据用户名和密码查询
public Customer selectByNamePwd(String custname,String pwd);
//查询全部
List<Customer> selectAll();
}
建立一个dao实现类
public class CustomerDAOImpl implements CustomerDao{
public void insert(Customer cust) {
Connection conn = JDBCConnectionFactory.getConnection();
String sql = "insert into customer values(?,?,?,?)";
try {
PreparedStatement ps= conn.prepareStatement(sql);
ps.setString(1, cust.getCustname());
ps.setString(2, cust.getPwd());
ps.setInt(3,cust.getAge());
ps.setString(4,cust.getAddress());
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e)