CRUD

package cj;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public class CRUD {
	public static void main(String[] args) throws Exception {
		// create();
		read();
		// update();
		delete();
	}

	public static void create() throws Exception {
		Connection con = null;
		ResultSet rs = null;
		Statement st = null;
		try {
			con = JdbcUtil.getConnection();
			st = con.createStatement();
			String str = "insert into chenjie(id,name) values (24,'hazle') ";
			int i = st.executeUpdate(str);
			System.out.println(i);
		} finally {
			JdbcUtil.free(rs, st, con);
		}
	}

	public static void read() throws Exception {
		Connection con = null;
		ResultSet rs = null;
		Statement st = null;
		try {
			con = JdbcUtil.getConnection();
			st = con.createStatement();
			String str = "select id,name from chenjie ";
			rs = st.executeQuery(str);
			while (rs.next()) {
				System.out.print(rs.getObject("name") + "\t"
						+ rs.getObject("id"));
				System.out.println();
			}
		} finally {
			JdbcUtil.free(rs, st, con);
		}
	}

	public static void update() throws Exception {
		Connection con = null;
		ResultSet rs = null;
		Statement st = null;
		try {
			con = JdbcUtil.getConnection();
			st = con.createStatement();
			String str = "update chenjie set id=id+10 ";
			int i = st.executeUpdate(str);
			System.out.println(i);
		} finally {
			JdbcUtil.free(rs, st, con);
		}
	}

	public static void delete() throws Exception {
		Connection con = null;
		ResultSet rs = null;
		Statement st = null;
		try {
			con = JdbcUtil.getConnection();
			st = con.createStatement();
			String str = "delete from chenjie where id>31 ";
			int i = st.executeUpdate(str);
			System.out.println(i);
		} finally {
			JdbcUtil.free(rs, st, con);
		}
	}
}