jdbc 原始工具连接方式

                                    jdbc 原始工具连接方式

1.创建jdbc连接方法类

/**
 * 数据库连接
 */
public class BaseDao {

    private String DRIVER = "com.mysql.jdbc.Driver";
    private String URL = "jdbc:mysql://127.0.0.1:3306/dome?useUnicode=true&characterEncoding=utf-8&useSSL=false";
    private String NAME = "root";
    private String PWD = "root";


    public Connection incon(){
        Connection con = null;
        try {
            //加载驱动
            Class.forName(DRIVER);
            con = DriverManager.getConnection(URL,NAME,PWD);

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return con;
    }

    public  void  incol(PreparedStatement ps, Connection con, ResultSet rs){

        try {
            if(rs!=null)
                rs.close();
            if(ps!=null)
                ps.close();
            if(con!=null)
                con.close();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

2.实现连接

public class UserDao extends BaseDao{

    Connection con = null;     //连接
    PreparedStatement ss = null; //预编译
    ResultSet rs = null;         //返回集

    /**
     * 查询
     * @return
     */
    public List<User> inMubanList(){
        List<User> userList = new ArrayList<>();
        try {
            con = this.incon();
            //编写sql语句
            String sql ="select*from blogs_user";
            //预编译
            ss = con.prepareStatement(sql);
            //返回结果集
            rs = ss.executeQuery();
            //循环给list
            while(rs.next()){
                User st = new User();
                st.setId(rs.getInt("ID"));
                st.setName(rs.getString("NAME"));
                st.setSex(rs.getString("SEX"));
                st.setUpdateTime(rs.getDate("UPDATE_TIME"));
                userList.add(st);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            System.out.println("远程追溯数据库失败");
        }finally{
            this.incol(ss,con,rs);

        }
        return userList;
    }
}