JdbcTemplate常见的增删改查操作

文件结构与Jar包

员工类Emp

package com.atguigu.jdbctemplate;

public class Emp {
	private Integer aid;

	private String account;

	private String password;

	public Integer getAid() {
		return aid;
	}

	public void setAid(Integer aid) {
		this.aid = aid;
	}

	public String getAccount() {
		return account;
	}

	public void setAccount(String account) {
		this.account = account;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	@Override
	public String toString() {
		return "Emp [aid=" + aid + ", account=" + account + ", password="
				+ password + "]";
	}

}

TestJdbcTemplate测试类：

创建过程

内容

package com.atguigu.jdbctemplate;

import static org.junit.Assert.*