Mysql 驱动程序，连接数据库的代码

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();  

        }