2021-06-08

• 加强了代码的可操作性
  建立一个命名为：MyDB的class文件

public class MyDB {
	private static final String driver="com.mysql.jdbc.Driver";
	private static final Stringurl="jdbc:mysql://127.0.0.1:3306/mysql";
	private static final String user="root";
	private static final String password="root";
	
	private static final Connection conn;	
		static{
			loadDriver();		
            conn=createConnection();
	}
	private static Connection createConnection(){
		Connection conn=null;
		try {
			conn=DriverManager.getConnection(url,user,password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
	private static void loadDriver(){
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection(){
		return conn;
	}
	//关闭方法 
	public static void close(ResultSet set, Statement sta, Connection conn) {
		if (set != null) {
			try {
				set.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(sta !=null){
			try {
				sta.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

	}

}

建一个命名为User的class文件

public class User {//VO POJO类 作用是用于存储数据到内存中
	private String host;
	private String user;
	public String getHost() {
		return host;
	}
	public void setHost(String host) {
		this.host = host;
	}
	public String getUser() {
		return user;
	}
	public void setUser(String user) {
		this.user = user;
	}
	
	@Override
	public String toString() {//重写Object类型的方法
		return "User [host=" + host + ", user=" + user + "]";
	}
	
	public User(){//默认构造
		
	}
	public User(String host, String user) {//全参构造
		super();
		this.host = host;
		this.user = user;
	}
    
}

建立一个命名为TextWorkA的class文件

public class TestWorkA {
	public static void main(String[] args) {
		
		List<User> list=getUserList();
		for(User user:list){
			System.out.println(user);
		}
	}
	public static List<User> getUserList(){
		List<User> list=new ArrayList<>();
		Connection conn=MyDB.getConnection();//得到数据库连接对象
		String sql="select * from user";
		System.out.println(conn);
		Statement sta=null;
		ResultSet set =null;
		try {
			sta=conn.createStatement();
			set=sta.executeQuery(sql);
			while(set.next()){
				//System.out.println(set.getString(1));
				User user=new User(set.getString("host"),set.getString("user"));
				list.add(user);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			MyDB.close(set, sta, conn);//关闭已完成 
		}
	
		return list ;
	}

}