JDBC的CRUD

jdbc的增删改查操作–
写一个工具类，再写一个测试类Junit
在测试类里面进行增删改查的操作

查：

	@Test
	public void testquery(){
		 Connection conn = null;
		 Statement st = null;
		 String sql = null;
		 ResultSet rs = null;
		 try {
	 	   conn = jdbcUtil.getconn();
	 	   st = conn.createStatement();
	   	sql = "select * from xuexi";
	  	rs = st.executeQuery(sql);
		  while(rs.next()){
			  int id = rs.getInt("id");
			  String name = rs.getNString("name");
	 		 int age = rs.getInt("age");
	 		 System.out.println(id+":"+name+":"+age);
	  			}
		 } catch (SQLException e) {
			e.printStackTrace();
		 }finally{
			  try {
			   if(conn!=null)
			   {conn.close();}
	  		 } catch (SQLException e) {
	   		  e.printStackTrace();
	 		 }finally{
	  			 conn =null;
	  			 }
			  try {
			   if(rs!=null)
			   {rs.close();}
			   
			  } catch (SQLException e) {
			    
			   e.printStackTrace();
			  }finally{
			   rs =null;
			  }
			  try {
			   if(st!=null)
			   {st.close();}
			   
			  } catch (SQLException e) {
			    
			   e.printStackTrace();
			  }finally{
			   st =null;
			  }
		 }
	}

增：

@Test
 public void testInsert(){
  
  Connection conn= null;
  Statement st = null;
  
  try {
   conn = jdbcUtil.getconn();
   st= conn.createStatement();
   String sql = "insert into xuexi values(1,'lz',22)";
   int result = st.executeUpdate(sql);
   if(result>0){
    System.out.println("添加成功");
   }else{
    System.out.println("添加失败");
   }
  } catch (SQLException e) {
    
   e.printStackTrace();
  }finally{
   try {
    if(conn!=null)
    {conn.close();}
    
   } catch (SQLException e) {
     
    e.printStackTrace();
   }finally{
    conn =null;
   }
    
   try {
    if(st!=null)
    {st.close();}
    
   } catch (SQLException e) {
     
    e.printStackTrace();
   }finally{
    st =null;
   }
  }
  
 }
  

改：

@Test
 public void testupdate(){
  Connection conn = null;
  Statement st = null;
  
  try {
   conn= jdbcUtil.getconn();
   st = conn.createStatement();
   String sql = "update xuexi set name='张无忌' where id=1";
   //result影响的行数，有多少行被改变了
   int result = st.executeUpdate(sql);
   if(result>0){
    System.out.println("更新成功");
   }else{
    System.out.println("更新失败");
   }
  } catch (SQLException e) {
    
   e.printStackTrace();
  }finally{
   try {
    if(conn!=null)
    {conn.close();}
    
   } catch (SQLException e) {
     
    e.printStackTrace();
   }finally{
    conn =null;
   }
    
   try {
    if(st!=null)
    {st.close();}
    
   } catch (SQLException e) {
     
    e.printStackTrace();
   }finally{
    st =null;
   }
  }
 }

删：

@Test
 public void testdelete(){
  Connection conn = null;
  Statement st = null;
  
  try {
   conn= jdbcUtil.getconn();
   st = conn.createStatement();
   String sql = "delete from xuexi where id=1";
   //result影响的行数，有多少行被改变了
   int result = st.executeUpdate(sql);
   if(result>0){
    System.out.println("删除成功");
   }else{
    System.out.println("删除失败");
   }
  } catch (SQLException e) {
    
   e.printStackTrace();
  }finally{
   try {
    if(conn!=null)
    {conn.close();}
    
   } catch (SQLException e) {
     
    e.printStackTrace();
   }finally{
    conn =null;
   }
    
   try {
    if(st!=null)
    {st.close();}
    
   } catch (SQLException e) {
     
    e.printStackTrace();
   }finally{
    st =null;
   }
  }
 }

result的作用：

  int result = st.executeUpdate(sql);

result的值为st.executeUpdate影响的行数，有多少行被改变了（无论是增，还是改）

通过if判断可以确定：

  if(result>0){
    System.out.println(" 成功");
   }else{
    System.out.println(" 失败");
   }