package cn.itcast.jdbc;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;

public class OtherApi {

	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		Connection conn = JdbcUtils.getConnection();
		psTest();
		genKey();
		JdbcUtils.realse(null, null, conn);
	}

	static void genKey() throws SQLException {
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			st = conn.createStatement();
			String sql = "insert into user(name, age, birth_day, account) "
					+ "values('key name',30, now(), 200)";
			st.executeUpdate(sql);
			rs = st.getGeneratedKeys();
			while (rs.next()) {
				System.out.println(rs.getInt(1));
			}
		} finally {
			JdbcUtils.realse(rs, st, conn);
		}
	}

	static void psTest() throws SQLException {
		Connection conn = null;
		CallableStatement cs = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			String sql = "{call addUser(?,?,?,?)}";
			cs = conn.prepareCall(sql);
			cs.registerOutParameter(4, Types.INTEGER);
			cs.setString(1, "ps name");
			cs.setInt(2, 20);
			cs.setInt(3, 100);
			int i = cs.executeUpdate();
			System.out.println("i=" + i);

			int id = cs.getInt(4);
			System.out.println("id=" + id);
		} finally {
			JdbcUtils.realse(rs, cs, conn);
		}
	}
}