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语句就好，呵呵，给背单词似的，挺好玩的