JDBC的CRUSD操作之PreparedStatement的增删改查

JDBC的CRUSD操作之PreparedStatement的增删改查

增加操作代码

	@Test
	public void demo1() {
		Connection conn = null;
		PreparedStatement patmt = null;
		try {
			//获得连接
			conn = JDBCUtils.getConnection();
			//编写SQL语句
			String sql = "insert into user values (null,?,?,?,?)";
			patmt = conn.prepareStatement(sql);
			patmt.setString(1, "eee");
			patmt.setString(2, "abc");
			patmt.setString(3, "旺财");
			patmt.setInt(4, 32);
			
			int num = patmt.executeUpdate();
			if (num>0) {
				System.out.println("增加成功");
			}else {
				System.out.println("增加失败");
			}		
		} catch (Exception e) {
			// TODO: handle exception
		}finally {
			JDBCUtils.release(patmt, conn);
		}
	}

删除操作代码

	@Test
	/**
	 * 删除操作
	 */
	public void demo3() {
		Connection conn = null;
		PreparedStatement patmt = n