publicclassJdbcTest{publicstaticvoidmain(String[] args){ResultSet rs =null;Connection conn =null;Statement sta =null;JdbcUtil jdbcUtil =newJdbcUtil();
conn= jdbcUtil.getConnection();try{
sta = conn.createStatement();String sql ="insert into `users` (`id`,`NAME`,`PASSWORD`,`email`,`birthday`)\n"+"values(4,'李冲','23123123',concat(floor(rand()*100000),\"@qq.com\"),'2000-2-12')";int i = sta.executeUpdate(sql);if(i>0){System.out.println("插入成功!!");}}catch(SQLException e){
e.printStackTrace();}finally{
jdbcUtil.release(conn,sta,rs);}}}
删除记录
publicclassJdbcDelete{publicstaticvoidmain(String[] args){ResultSet rs =null;Connection conn =null;Statement sta =null;JdbcUtil jdbcUtil =newJdbcUtil();
conn= jdbcUtil.getConnection();try{
sta = conn.createStatement();String sql ="delete from users where `id`=4";int i = sta.executeUpdate(sql);if(i>0){System.out.println("删除成功!!");}}catch(SQLException e){
e.printStackTrace();}finally{
jdbcUtil.release(conn,sta,rs);}}}
修改记录
publicclassJdbcUpdate{publicstaticvoidmain(String[] args){ResultSet rs =null;Connection conn =null;Statement sta =null;JdbcUtil jdbcUtil =newJdbcUtil();
conn= jdbcUtil.getConnection();try{
sta = conn.createStatement();String sql ="update users set `NAME`='lihaugn' where id =3";int i = sta.executeUpdate(sql);if(i>0){System.out.println("更新成功!!");}}catch(SQLException e){
e.printStackTrace();}finally{
jdbcUtil.release(conn,sta,rs);}}}
查询记录
publicclassJdbcSelect{publicstaticvoidmain(String[] args){ResultSet rs =null;Connection conn =null;Statement sta =null;JdbcUtil jdbcUtil =newJdbcUtil();
conn= jdbcUtil.getConnection();try{
sta = conn.createStatement();String sql ="select * from users";
rs = sta.executeQuery(sql);while(rs.next()){System.out.println("id="+rs.getInt("id"));System.out.println("name="+rs.getString("NAME"));System.out.println("email"+rs.getString("email"));System.out.println("birthday"+rs.getString("birthday"));}}catch(SQLException e){
e.printStackTrace();}finally{
jdbcUtil.release(conn,sta,rs);}}}
文章目录Mysql JDBC一、什么是JDBC?二、第一个JDBC程序1、创建数据库2、idea连接数据库3、封装JDBC连接数据库4、JDBC增、删、改、查增加记录删除记录修改记录查询记录Mysql JDBC一、什么是JDBC?JDBC(Java Data Base Connectivity,java数据库连接)是一种用于执行SQL语句的Java API,可以为多种关系数据库提供统一访问,它由一组用Java语言编写的类和接口组成。是Java访问数据库的标准规范JDBC提供了一种基准,据此可以构