Skip to content

JavaServerGroup/jtool-mysql2

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

58 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

jtool-mysql2

Apache License 2 Build Status Coverage Status Codacy Badge

Quick start:

第一步:引入repository到pom.xml

<repositories>
    <repository>
        <id>jtool-mvn-repository</id>
        <url>https://raw.github.com/JavaServerGroup/jtool-mvn-repository/master/releases</url>
    </repository>
</repositories>

第二步:添加dependency到pom.xml

<dependency>
    <groupId>com.jtool</groupId>
    <artifactId>jtool-mysql2</artifactId>
    <version>0.0.5</version>
</dependency>

第三步:dataSource配置(和平时spring jdbc一样)

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="${jdbc.driverClassName}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
</bean>

第四步:准备数据库表

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `age` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) 

第五步:建立pojo

public class Users {
    private long id;
    private String name;
    private int age;
    ... 
    getter and setter
}

第五步:编写users表的DAO

@Repository
@Table(tableName = "users")
@DataSource("dataSource")
public class UserDAO extends AbstractDAO<Users> {
}

注意AbstractDAO<Users>,这里的<Users>是必须的。

第六步:直接使用AbstractDAO提供的方法

public class MainApp {
    public static void main(String[] args) {
        ApplicationContext context = new ClassPathXmlApplicationContext(new String[] {"application-context.xml"}); 
	UserDAO userDAO = (UserDAO)context.getBean("userDAO");
		
	Users users = new Users();
	users.setAge(1);
	users.setName("Tim");
	userDAO.add(users);//直接添加
    }
}

接下来可以做什么?

About

spring jdbc上的一个简单封装

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages