java 小白 jdbc增删改查（优化）

查询代码
package com.wj.demo01;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;

/**
 * 增删改查操作
 * @author 开心
 *
 */
public class Demo3 {
   
	
	@Test
	public void query() {
   
		//注册驱动
		//获取连接
		//创建发送sql语句的对象
		//执行sql语句
		//处理结果集
		//关闭资源
		Connection conn=null;
		Statement stmt=null;
		ResultSet rs=null;
		try {
   
			conn=JDBCUtil.getConnection();
			stmt=conn.createStatement();
			rs=stmt.executeQuery("select * from student");
			while(rs.next()) {
   
				int id=rs.getInt("id");
				String name=rs.getString("name");
				String city=rs.getString("city");
				int age=rs.getInt("age");
				System.out.println(id+":"+name+":"+city+":"+age);
			}
		}  catch (SQLException e) {
   
			e.printStackTrace();
		}finally {
   
			JDBCUtil.release(stmt, conn, rs);
		}
	}
	
	
	
	
	
	
	
	
	@Test
	public void delete() {