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