JAVA JDBC DAO模式实现与mysql交互

1.文件存放结构：
2.具体代码：
1）接口类：

package com.jabcit.dao;

public interface UserDao {
   
	void findAll();
	void login(String username,String psword);
	void addInfo(String username,String psword);
	void deleteInfo(String username);
	void updatePassword(String username,String psword);
}

2）实现接口类的方法：

package com.jadbcit.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
//import java.sql.SQLException;
import java.sql.Statement;

import com.jabcit.dao.UserDao;
import com.jdbcit.util.Close;

public class UserDaoImpl implements UserDao{
   
	
	@Override
	public void findAll() {
   
			Connection conn = null;
			Statement st = null;
			ResultSet rs = null;			
		try {
   
			//System.out.println("begin.....");
			conn = Close.getConn();
			//System.out.println("after.....");
			st = conn.createStatement();
			String sql = "select * from user";
			rs = st.executeQuery(sql);			
			while(rs.next()){
   
				int no = rs.getInt("id");
				String name = rs.getString("username");
				String passward = rs.getString("passward");
				System.out.println(no+"\t\t"+name+"\t\t"+passward);
				//String no = rs.getString("No");
				//int no = rs.getInt("No");
				//String name = rs.getString("Name");
				//String sex = rs.getString("Sex");
				//System.out.println(no+"\t\t"+name+"\t\t"+sex);
			}
		} catch (Exception e) {
   
			e.printStackTrace();
		}finally{
   
			Close.release(rs, st, conn);
		}		
	}

	@Override
	public void login(String username, String psword) {
   
			Connection conn = null;
			//Statement st = null;
			PreparedStatement ps = null;
			ResultSet rs = null;