jdbc一篇小记录

//实体类不仔细描述了
public User{
    private int id;

   private String name; 
    ...
    ...
}

---

//dbhelp类，封装数据库连接
public DBHelp{
    public static String url = "jdbc:mysql://localhost:3306/blog";
    public static String user = "root";
    public static String password = "";
    public static String driver = "com.mysql.jdbc.Driver";
    public static PreparedStatement ps = null;
    public static Connection conn = null;
        //获取连接

    public static void getConnection(){
        try{
            Class.forName(driver);
            conn = DriverManager.getConnection(url,user,password);
        }catch(SQLException e)  {
            e.printStackTrace();
    }
    }
//关闭连接
public void close(){
            try{
                    ps.close();
                    conn.close();
        }catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

----------
//操作数据类
public UserDemoCurrd extends DBHelp{


    public ResultSet rs = null;
    //查找一个用户数据
    public user getUser(){
        //获取连接方法
        getConnection();
        User user = new User();
        try{
            String sql = "select * from t_sys_user where id = 1";
            conn = ps.prepareStatement(sql);
            rs = ps.executeQuery();
            while (rs.next()){
                user.setId(rs.getInt("id"));
                user.setName(rs.getString("name"));
                user.setContact(rs.getString("contact"));
                user.setEmail(rs.getString("email"));
                user.setRemark(rs.getString("remark"));
                user.setTelephone(rs.getString("telephone"));
            }
        }catch (SQLException e) {
            e.printStackTrace();
        }
        close();
        return user;
    }
}

---

//测试类
public UserTest{
    public static void main(String[] a){
            UserDemoCurrd demo = new UserDemoCurrd();
            demo.getUser();
            System.out.println(user.getName);
    }
}