07_数据库创建，添加c3p0操作所需的jar包，编写c3p0-config.xml文件，编写User.java,编写jdbcUtils.java实现操作数据库的模板工具类，UserDao编写，Dao



1  创建day14数据库，创建user.sql表：

A 创建数据库 day14

B 创建数据表 users

create table users

(

    id int primary keyauto_increment,

    username varchar(20),

    password varchar(20)

);

2  添加依赖的jar包

package junit.test;

import java.util.List;

import org.junit.Test;

import cn.toto.dao.UserDao;

import cn.toto.domain.User;

public class UserDaoTest {

    private UserDao dao = new UserDao();

    @Test

    public void testInsert() {

       User user = new User();

       user.setUsername("zhangsan");

       user.setPassword("11111111");

       boolean b = dao.insert(user);

       System.out.println(b);

    }

    @Test

    public void testGetAll() {

       List all = dao.getAll();

       System.out.println(all);

    }

    @Test

    public void testFind() {

       User user = dao.find(0);

       System.out.println(user);

    }

}