public static void main(String[] args) {
         String usname= "root";
         String pwd = "000000";  
         String driver="com.mysql.jdbc.Driver";  
         String url = "jdbc:mysql://localhost:3306/zslm?user=root&password=000000"; //zslm是数据库名字,root是用户password//是密码
         String sql = "select * from module";  
         Connection conn = null;  
         Statement stmt = null;  
         ResultSet rs = null;  
         try {  
                           Class.forName(driver);  //加载驱动    
                           conn = DriverManager.getConnection(url); //获得连接  
                           stmt = conn.createStatement();   
                           rs = stmt.executeQuery(sql);   
                           if (rs !=null){    
                                          while(rs.next()){    
                                              System.out.println(rs.getString(1));     
                                              System.out.println(rs.getString(2));    
                                              System.out.println(rs.getDate(3));     
                                              System.out.println(rs.getString(4));     
                                              System.out.println(rs.getString(5));     
                                              System.out.println(rs.getString(6));     
                                             System.out.println(rs.getString(7));     
                                            }            
                                 }else{    
                                 System.out.println("rs是null");   
                                  }  
                                rs.close();   
                               stmt.close();   
                                 rs.close();  
        } catch (ClassNotFoundException e){   
              e.printStackTrace();  
        }catch (SQLException e) {
             e.printStackTrace();  
        }