public abstract class Examples extends Object
| 构造器和说明 |
|---|
Examples() |
| 限定符和类型 | 方法和说明 |
|---|---|
static void |
main(String[] args) |
static void |
test()
Equivalent to: select * from Product where location='London'
|
static void |
test1()
Equivalent to: select * from Product where created<= now() and salesman.name='Petter'
|
static void |
test2()
Equivalent to: select location,max(price) as maxPrice, min(price) as minPrice,avg(freight) as avgFreight,sum(sales) as sumSales from Product group by location
|
static void |
test3()
Equivalent to: select location,style,max(price) as maxPrice, min(price) as minPrice,avg(freight) as avgFreight,sum(sales) as sumSales from Product group by location,style having avg(freight) > 55
|
static void |
test4()
Equivalent to: select name,price from Product order by price desc limit 100
|
public static void test()
Equivalent to: select * from Product where location='London'
public static void test1()
Equivalent to: select * from Product where created<= now() and salesman.name='Petter'
public static void test2()
Equivalent to: select location,max(price) as maxPrice, min(price) as minPrice,avg(freight) as avgFreight,sum(sales) as sumSales from Product group by location
public static void test3()
Equivalent to: select location,style,max(price) as maxPrice, min(price) as minPrice,avg(freight) as avgFreight,sum(sales) as sumSales from Product group by location,style having avg(freight) > 55
public static void test4()
Equivalent to: select name,price from Product order by price desc limit 100
public static void main(String[] args)
Copyright © 2021. All rights reserved.