PrepareStatement增加、删除、更改

一个简单的小测试案例：

package cn.itheima.jdbc;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import org.junit.Test;

import cn.itheima.utils.JDBCUtils;

public class JDBCDemo6 {
	Connection con = null;
	PreparedStatement ps = null;
	ResultSet rs = null;

	@Test
	public void update() {
		try {
			con=JDBCUtils.getConnection();
			ps=con.prepareStatement("update user set name='程崇树' where name=?");
			ps.setString(1, "李卫康");
			ps.executeUpdate();
			
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException();
		} finally {
			JDBCUtils.closeResource(rs, ps, con);
		}
	}

	@Test
	public void delete() {
		try {
			con=JDBCUtils.getConnection();
			ps=con.prepareStatement("delete from user where name=?");
			ps.setString(1, "程崇树");
			ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException();
		} finally {
			JDBCUtils.closeResource(rs, ps, con);
		}
	}

	@Test
	public void add() {
		try {
			con=JDBCUtils.getConnection();
			ps=con.prepareStatement("insert into user values(2,?,?,?)");
			ps.setString(1, "李卫康");
			ps.setByte(2, (byte)1);
			ps.setDate(3, new Date(1992, 3, 4));
			ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException();
		} finally {
			JDBCUtils.closeResource(rs, ps, con);
		}
}
}