03 向数据库增加一条数据

获取连接
获取PreparedStatement操作对象
填满相应占位符
关闭

public int addUser(User user) {

        //三大件
        //连接
        Connection connection = null;
        //操作
        PreparedStatement prep = null;

        int rows = 0;
        try {
          connection = JDBCUtil.getConnection();
           prep = connection.prepareStatement("insert into user values (null,?,?)") ;

           prep.setObject(1,user.getUserName());
           prep.setObject(2,user.getUserPwd());

            rows = prep.executeUpdate();

        } catch (SQLException e) {
            throw new RuntimeException(e);
        }finally {

            JDBCUtil.closeAll(connection,prep);
        }


        return rows;
    }

@Test
    public void addUserTest(){
        int i = iUserDao.addUser(new User(11, "test", "test"));

        System.out.println(i);
    }