JDBC学习之路（二）CRUD

    所谓的CRUD就是创建(Creat),读取(Read)，更新（update）,删除(Delete)，其实有了前面的那些代码做铺垫，实现CRUD非常简单，难得是对特定的数据，废话不多说，请看代码

     

package com.bird.jdbc;

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

/**
 * 
 * @author bird
 * @throws SQLException
 * @use 数据库的创建一条记录
 *
 */
public class Creat {
	public static void creat() throws SQLException{//创建数据
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		try{
			conn = JdbcUtil.getConnecttion();//建立连接
			
			st = conn.createStatement();//创建语句	
			
			String sql = "insert into niao(username,password,keywords,userkeywords1,time1,userkeywords2,time2)" +
					"values('baichi','123','牛逼','哈哈','12','嘿嘿','23')";//构建插入SQL语句
			int i = st.executeUpdate(sql);//执行语句
			
			System.out.println("i = " + i);
		}finally{
			JdbcUtil.free(rs, st, conn);
		}
	}
	
	
	public static void update() throws SQLException{//更新数据
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		try{
			conn = JdbcUtil.getConnecttion();//建立连接
			
			st = conn.createStatement();//创建语句	
			
			String sql = "update niao set keywords = '废话'";//构建插入SQL语句
			int i = st.executeUpdate(sql);//执行语句
			
			System.out.println("i = " + i);
		}finally{
			JdbcUtil.free(rs, st, conn);
		}
	}
	
	public static void delete() throws SQLException{//删除
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		try{
			conn = JdbcUtil.getConnecttion();//建立连接
			
			st = conn.createStatement();//创建语句	
			
			String sql = "delete from niao where id > 2";//构建插入SQL语句
			int i = st.executeUpdate(sql);//执行语句
			
			System.out.println("i = " + i);
		}finally{
			JdbcUtil.free(rs, st, conn);
		}
	}
	
	public static void main(String [] args) throws SQLException{
		//creat();
		//update();
		delete();
	}

}

其实JDBC这些东西很简单，主要是背背SQL语句就好，呵呵，给背单词似的，挺好玩的