JDBC用PrepareStatement实现增，删，改，查

public class Jdbc {


	/**
	 * 用PrepareStatement实现增，删，改，搜。
	 */
	public static void main(String[] args) {
		Connection cn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			cn = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "huxu");


			Scanner input = new Scanner(System.in);
			System.out.println("请输入您选择的操作，1为增，2为删，3为改，4为搜！");
			int op = input.nextInt();


			switch (op) {//或者用if
			case 1: {//增
				String sql = "INSERT INTO teacher VALUES(?,?,?,?,?,?)";
				ps = cn.prepareStatement(sql);
				ps.setInt(1, 121);
				ps.setString(2, "神喻");
				ps.setString(3, "女");
				ps.setDate(4, null);
				ps.setString(5, "数据");
				ps.setString(6, "计算机系");
				ps.executeUpdate();
				break;
			}
			case 2: {//删
				String sql = "DELETE FROM teacher WHERE TNO=?";
				ps = cn.prepareStatement(sql);
				ps.setInt(1, 121);
				ps.executeUpdate();
				break;
			}
			case 3: {//改
				String sql = "UPDATE teacher SET PROF=? WHERE TNO=?";
				ps = cn.prepareStatement(sql);
				ps.setString(1, "神经");
				ps.setInt(2, 900);
				ps.executeUpdate();
				break;
			}
			case 4: {//查
				String sql = "SELECT * FROM teacher WHERE SEX LIKE ?";
				ps = cn.prepareStatement(sql);
				ps.setString(1, "%女%");
				rs = ps.executeQuery();
				while (rs.next()) {
					System.out.println(rs.getInt("TNO") + "  "
							+ rs.getString("TNAME") + "  "
							+ rs.getString("SEX"));
				}
				break;
			}
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {


			try {
				if (rs != null)
					rs.close();
				if (ps != null)
					ps.close();
				if (cn != null)
					cn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

JDBC技术学习 https://www.itkc8.com