public static void main(String[] args) {
       try {
           Class.forName(driver);

           con = DriverManager.getConnection(url, username, pwd);
           String sql = "insert into pm_user(name,pwd,firstname,email) values('a','32','a','a@e.com')";
           ps = con.prepareStatement(sql);
           ps.executeUpdate();

           ps = con.prepareStatement("select * from pm_user");
           rs = ps.executeQuery();

           while(rs.next()) {
               String name = rs.getString("name");
               String pwd = rs.getString("pwd");
               logger.info("name==="+name+";pwd======"+pwd);
           }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }catch (SQLException e) {
           e.printStackTrace();
       }finally {
           closeAll();
        }

    }