JDBC入门(二)—JDBC的增删改查操作

JDBC的CURD操作

向数据库中保存数据

/**
	 * 向数据库中保存数据
	 */
	@Test
	public void demo1(){
		Statement state = null;
		Connection conn = null;
		try {
			/*1.获取驱动*/
			Class.forName("com.mysql.cj.jdbc.Driver");
			/*2.建立连接*/
			conn = DriverManager.getConnection("jdbc:mysql:///jdbctest?serverTimezone=UTC&characterEncoding=utf-8", "root", "curry");
			/*3.创建执行sql对象*/
			state = conn.createStatement();
			/*4.编写 sql*/
			String sql = "insert into jdbctest value(null,'张三',10)";
			/*5.执行sql*/
			state.execute(sql);
		}catch(Exception e) {
			e.printStackTrace();
		}finally {
			/*6.释放资源*/
			if(state!=null) {
				try {
					state.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				state = null;
			}
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				conn = null;
			}
		}
	}

修改数据库中的数据

	/**
	 * 修改操作
	 */
	@Test
	public void demo2() {
		/*创建对象*/
		Statement state = null;
		Connection conn = null;
		try {
			/*1.获取驱动*/
			Class.forName("com.mysql.cj.jdbc.Driver");
			/*2.建立连接*/
			conn = DriverManager.getConnection("jdbc:mysql:///jdbctest?serverTimezone=UTC&characterEncoding=utf-8", "root", "curry");
			/*3.创建执行sql对象*/
			state = conn.createStatement();
			/*4.编写sql语句*/
			String sql = "update jdbctest set name='李四',age=22 where id=1";
			/*5.执行sql*/
			if(state.executeUpdate(sql)==1)
				System.out.print("修改成功！");
		}catch(Exception e) {
			e.printStackTrace();
		} finally {
			/*6.释放资源*/
			if(state!=null) {
				try {
					state.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				state = null;
			}
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				conn = null;
			}
		}

删除数据库中的数据

	/**
	 * 删除操作
	 */
	@Test
	public void demo3() {
		/*创建对象*/
		Statement state = null;
		Connection conn = null;
		try {
			/*1.获取驱动*/
			Class.forName("com.mysql.cj.jdbc.Driver");
			/*2.建立连接*/
			conn = DriverManager.getConnection("jdbc:mysql:///jdbctest?serverTimezone=UTC&characterEncoding=utf-8","root","curry");
			/*3.创建执行sql对象*/
			state = conn.createStatement();
			/*4.编写sql语句*/
			String sql = "delete from jdbctest where id=1;";
			/*5.执行sql*/
			state.execute(sql);
		} catch(Exception e) {
			e.printStackTrace();
		} finally {
			/*6.资源释放*/
			if(conn!=null) {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			conn=null;
			}
			if(state!=null) {
				try {
					state.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				state = null;
			}
		}

查询数据库中的数据

	/**
	 * 查找操作
	 */
	@Test
	public void demo4() {
		/*创建对象*/
		Statement state = null;
		ResultSet rs = null;
		Connection conn = null;
		try {
			/*1.获得驱动*/
			Class.forName("com.mysql.cj.jdbc.Driver");
			/*2.建立连接*/
			conn = DriverManager.getConnection("jdbc:mysql:///jdbctest?serverTimezone=UTC&characterEncoding=utf-8","root","curry");
			/*3.创建执行sql对象*/
			state = conn.createStatement();
			/*4.编写sql语句*/
			String sql = "select * from jdbctest;";
			/*5.执行sql*/
			rs = state.executeQuery(sql);
			/*6.遍历结果集*/
			while(rs.next()) {
				System.out.println(rs.getInt("id")+"  "+rs.getString("name")+"  "+rs.getInt("age"));
			}
		} catch(Exception e) {
			
		} finally {
			/*7.资源释放*/
			if(conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				conn = null;
			}
			if(state!=null) {
				try {
					state.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				state = null;
			}
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				rs = null;
			}
		}