<dependency> <groupId>org.jooq</groupId> <artifactId>jooq</artifactId> <version>3.14.6</version> </dependency> <configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd"> <jdbc> <driver>com.mysql.jdbc.Driver</driver> <url>jdbc:mysql://localhost:3306/mydatabase</url> <user>myuser</user> <password>mypassword</password> </jdbc> <generator> <database> <name>org.jooq.meta.mysql.MySQLDatabase</name> <includes>.*</includes> <excludes></excludes> <inputSchema>public</inputSchema> </database> <target> <packageName>com.example.model</packageName> <directory>src/main/java</directory> </target> </generator> </configuration> java -cp jooq.jar:jdbc.jar:codegen.jar org.jooq.codegen.GenerationTool jooq-codegen.xml Result<Record> result = DSL.using(connection, SQLDialect.MYSQL) .select() .from(Tables.CUSTOMER) .where(Tables.CUSTOMER.ID.eq(1)) .fetch(); for (Record record : result) { System.out.println(record.get(Tables.CUSTOMER.NAME)); }


上一篇:
下一篇:
切换中文