Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to use Jorm to add, delete, query and modify the database". In the daily operation, I believe that many people have doubts about how to use Jorm to add, delete, query and modify the database. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to use Jorm to add, delete, query and modify the database." Next, please follow the editor to study!

Preparing for

Take MySQL as an example, execute the following sql to build the data table

CREATE TABLE `t _ user` (

`id`int (11) NOT NULL

`name` varchar (50) DEFAULT NULL

`sex` char (4) DEFAULT NULL

`age`int (11) DEFAULT NULL

`career` varchar (100) DEFAULT NULL

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

> to introduce jar or maven dependencies, jar package is required

Download the latest version of gerald-jorm-1.0.5.jar:

Commons-logging-1.1.1.jar

Log4j-1.2.14.jar

Mysql-connector-java-5.1.6.jar

Javassist-3.11.0.GA.jar or cglib-nodep-2.2.2.jar (join selectively according to the actual situation)

Configuration files

Create config.properties and jdbc.cfg.xml files under the classpath of your java project

Config.properties content:

# the following path can be specified according to the actual situation, which is the path address of the relative classpath

Jdbc.config.path=jdbc.cfg.xml

Jdbc.cfg.xml content:

Org.javaclub.jorm.jdbc.connection.impl.SimpleConnection

MySQLDialect

Com.mysql.jdbc.Driver

Jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8

Test

Root

Root

Org.javaclub.jorm.jdbc.connection.impl.PooledConnection

MySQLDialect

Com.mysql.jdbc.Driver

Jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8

Test

Root

Root

one

eight

Select 1

Entity class User.java

@ Competition (value = "id")

@ Entity (table= "t_user")

Public class User {

@ Id

Private int id

Private String name

Private String sex

Private Integer age

Private String career

@ NoColumn

Private int kvalue

Public User () {

Super ()

}

Public User (String name, String sex, Integer age, String career) {

Super ()

This.name = name

This.sex = sex

This.age = age

This.career = career

}

Public User (Integer id, String name, String sex, Integer age, String career) {

Super ()

This.id = id

This.name = name

This.sex = sex

This.age = age

This.career = career

}

Public int getId () {

Return id

}

Public void setId (int id) {

This.id = id

}

Public String getName () {

Return name

}

Public void setName (String name) {

This.name = name

}

Public String getSex () {

Return sex

}

Public void setSex (String sex) {

This.sex = sex

}

Public Integer getAge () {

Return age

}

Public void setAge (Integer age) {

This.age = age

}

Public String getCareer () {

Return career

}

Public void setCareer (String career) {

This.career = career

}

Public int getKvalue () {

Return kvalue

}

Public void setKvalue (int kvalue) {

This.kvalue = kvalue

}

Public String toString () {

StringBuffer sb = new StringBuffer ()

Sb.append ("[" + id + "," + name + "," + sex + "," + age + "," + career + "]")

Return sb.toString ()

}

}

Here the field and the attribute of the java entity class User are the same in naming, if not, for example, if the table creation sql is:

CREATE TABLE `t _ user` (

`user_ id` int (11) NOT NULL

`user_ name` varchar (50) DEFAULT NULL

`sex` char (4) DEFAULT NULL

`col_ age` int (11) DEFAULT NULL

`career_ job` varchar (100) DEFAULT NULL

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

Then the corresponding entity User should be written as follows:

@ Competition (value = "id")

@ Entity (table= "t_user")

Public class User {

@ Id

@ Column ("user_id")

Private int id

@ Column ("user_name")

Private String name

/ / consistent with database field naming, @ Column can not be specified

Private String sex

@ Column ("col_age")

Private Integer age

@ Column ("career_job")

Private String career

@ NoColumn

Private int kvalue

Public User () {

Super ()

}

Public User (String name, String sex, Integer age, String career) {

Super ()

This.name = name

This.sex = sex

This.age = age

This.career = career

}

Public User (Integer id, String name, String sex, Integer age, String career) {

Super ()

This.id = id

This.name = name

This.sex = sex

This.age = age

This.career = career

}

Public int getId () {

Return id

}

Public void setId (int id) {

This.id = id

}

Public String getName () {

Return name

}

Public void setName (String name) {

This.name = name

}

Public String getSex () {

Return sex

}

Public void setSex (String sex) {

This.sex = sex

}

Public Integer getAge () {

Return age

}

Public void setAge (Integer age) {

This.age = age

}

Public String getCareer () {

Return career

}

Public void setCareer (String career) {

This.career = career

}

Public int getKvalue () {

Return kvalue

}

Public void setKvalue (int kvalue) {

This.kvalue = kvalue

}

Public String toString () {

StringBuffer sb = new StringBuffer ()

Sb.append ("[" + id + "," + name + "," + sex + "," + age + "," + career + "]")

Return sb.toString ()

}

}

> add, delete, query and modify User, UserCrudTest.java, remember to introduce junit-4.8.2.jar

Public class UserCrudTest {

Static Session session

@ BeforeClass

Public static void before () {

Session = Jorm.getSession ()

}

@ AfterClass

Public static void after () {

Jorm.free ()

}

@ Test

Public void save_user () {

Session.clean (User.class)

User user = null

For (int I = 0; I < 600; iTunes +) {

String sex = (I% 2 = = 0? "male": "female")

User = new User (Strings.fixed (5), sex, Numbers.random (98), Strings.random (8))

Session.save (user)

}

}

@ Test / / batch save

Public void batch_save_user () {

Session.clean (User.class)

JdbcBatcher batcher = session.createBatcher ()

User user = null

For (int I = 0; I < 600; iTunes +) {

String sex = (I% 2 = = 0? "male": "female")

User = new User (Strings.fixed (5), sex, Numbers.random (98), Strings.random (8))

Batcher.save (user)

}

Batcher.execute ()

}

@ Test

Public void loadUser () {

User user = session.read (User.class, 1)

/ / where user is a proxy object, because @ Entity (table= "t_user", lazy = true)

System.out.println (user.getCareer ()); / / issue query sql

}

@ Test

Public void deletUser () {

User user = session.read (User.class, 1)

If (null! = user) {

Session.delete (user)

}

User = session.read (User.class, 1)

System.out.println (user)

}

@ Test

Public void test_update_proxy () {

User u

U = session.read (User.class, 2)

Assert.assertNotNull (u)

Assert.assertTrue (u instanceof JormProxy)

U.setName ("Gerald.Chen")

Session.update (u)

System.out.println (u.getName ())

U = session.read (User.class, 2)

Assert.assertTrue ("Gerald.Chen" .equals (u.getName ()

}

@ Test

Public void queryUser () {

SqlParams params = new SqlParams ()

Params.setObjectClass (User.class)

Params.setFirstResult (8)

Params.setMaxResults (20)

List users = session.list (params)

System.out.println (users.size ())

System.out.println (users)

}

}

At this point, the study on "how to use Jorm to add, delete, check and modify the database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.