JAVA通过JDBC链接数据库获取数据（二）单元测试增删改查

JAVA通过JDBC链接数据库获取数据（二）单元测试增删改查

一、导入jar包

1、导入mysql链接的 jar包可以参考JAVA通过JDBC链接数据库获取数据（一）文章，或者百度查找。

二、单元测试操作数据库增删改查

package com.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;


public class Jdbc {
	private Connection con = null;
	// 在执行SQL语句前先执行 @Before 的代码
	@Before
	public void init() throws Exception{
		//1加载驱动
		Class.forName("com.mysql.jdbc.Driver");
		//2 声明URL
		String url = "jdbc:mysql://127.0.0.1:3306/long1?characterEncoding=UTF8";
		//3 创建链接
		con = DriverManager.getConnection(url,"root","123456");
		
	
	
	}
	//获取到数据库的数据后，执行释放资源
	@After
	public void destory() throws Exception{
		con.close();
	}
	
	@Test
	//插入数据
	public void insert() throws Exception{
		// 1、获取操作数据对象
		Statement st = con.createStatement();
		//2、创建SQL语句
		String sql = "INSERT INTO student (namee,sex,birth,department,address) VALUES('赵化','34',1985,'中文系','北京市昌平区')";
		//3、执行SQL语句返回结果
		int rs = st.executeUpdate(sql);
		//4、输出结果
		System.out.println("成功插入了一条数据"+rs);
		
	}
	
	@Test
	//修改数据
	public void update()throws Exception{
		//1、获取操作对象
		Statement st = con.createStatement();
		//2、创建sql语句
		String sql = "UPDATE student SET namee = '赵括有' WHERE id = 8";
		//3、执行SQL语句返回结果
		int rs = st.executeUpdate(sql);
		//4、输出结果
		System.out.println("成功的修改了一条数据+rs");
	}
	
	@Test
	//删除数据
	public void delete() throws Exception{
		//1、创建操作对象
		Statement st = con.createStatement();
		//2、SQL语句
		String sql = "delete from student where id=9";
		//3、执行sql返回结果
		int rs = st.executeUpdate(sql);
		//4、输出结果
		System.out.println(rs);
	}
	
	@Test
	//查询数据
	public void query() throws SQLException{
		//1、创建操作对象
		Statement st = con.createStatement();
		//2、Sql语句
		String sql = "select * from student";
		//3、执行SQL语句返回结果
		ResultSet rs = st.executeQuery(sql);
		//4、遍历结果
		while(rs.next()){
			String name = rs.getString("namee");
			String sex = rs.getString("sex");
			String birth = rs.getString("birth");
			String department = rs.getString("department");
			String address = rs.getString("address");
			
			System.out.println(name+","+sex+","+birth+","+department+","+address);
		}
	}
}