JAVA链接MySql连接语句

//JDBC驱动名字
		String JDBC_DRIVER="com.mysql.jdbc.Driver";
		//数据库的URL,格式：jdbc:mysql://IP/数据库名
		String DB_URL = "jdbc:mysql://localhost:3306/simplelearningtable";
		String UserName = "root";
		String Password = "root";
		Connection conn = null;
		Statement stmt = null;
		try{
			// 注册 JDBC 驱动
			Class.forName(JDBC_DRIVER);
			System.out.println("尝试连接数据库!");
			conn = DriverManager.getConnection(DB_URL,UserName,Password);
			String sql = "select * from commodity;";
			stmt = conn.createStatement();
			//结果集合
			ResultSet rs = stmt.executeQuery(sql);
			//输出读取的数据
			while(rs.next())
			{
				System.out.println(rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getString(4));
			}
            rs.close();
            stmt.close();
            conn.close();
			System.out.println("读取完毕!");
		}catch(Exception e){
			System.out.println(e);
		}