jdbc增删改查
来源：互联网 发布：matlab矩阵符号运算 编辑：程序博客网 时间：2024/05/18 01:52
package cn.itcast.jdbc;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class CRUD {public static void main(String[] args) throws SQLException {//read();create();update();delete();}static void create() throws SQLException{Connection conn = null;Statement st = null;ResultSet rs = null;try {conn = JdbcUtils.getConnection();st = conn.createStatement();st.executeUpdate("insert into user(name,birthday,money) values('name1','1988-09-09',9000)");rs = st.executeQuery("select id,name,birthday,money from user");while(rs.next()){System.out.println(rs.getObject("id")+"\t"+rs.getObject("name")+"\t"+rs.getObject("money")+"\t"+rs.getObject("birthday"));}} catch (Exception e) {// TODO: handle exceptionSystem.out.println("f");}finally{JdbcUtils.free(rs, st, conn);}}static void read() throws SQLException{Connection conn = null;Statement st = null;ResultSet rs = null;try {conn = JdbcUtils.getConnection();st = conn.createStatement();rs = st.executeQuery("select name,id,money,birthday from user");while(rs.next()){System.out.println(rs.getObject("id")+"\t"+rs.getObject("name")+"\t"+rs.getObject("money")+"\t"+rs.getObject("birthday"));}} catch (Exception e) {// TODO: handle exception}finally{JdbcUtils.free(rs, st, conn);}}static void update() throws SQLException{Connection conn = null;Statement st = null;ResultSet rs = null;try {conn = JdbcUtils.getConnection();st = conn.createStatement();st.executeUpdate("update user set money=money+20");rs = st.executeQuery("select id,name,birthday,money from user");while(rs.next()){System.out.println(rs.getObject("id")+"\t"+rs.getObject("name")+"\t"+rs.getObject("money")+"\t"+rs.getObject("birthday")+"\t"+rs.getObject("money"));}} catch (Exception e) {// TODO: handle exception}finally{JdbcUtils.free(rs, st, conn);}}static void delete() throws SQLException{Connection conn = null;Statement st = null;ResultSet rs = null;try {conn = JdbcUtils.getConnection();st = conn.createStatement();st.executeUpdate("delete from user where id>4");rs = st.executeQuery("select id,name,birthday,money from user");while(rs.next()){System.out.println(rs.getObject("id")+"\t"+rs.getObject("name")+"\t"+rs.getObject("money")+"\t"+rs.getObject("birthday"));}} catch (Exception e) {// TODO: handle exceptionSystem.out.println("f");}finally{JdbcUtils.free(rs, st, conn);}}}
