JDBC练习-update语句
account表 修改记录
public static void main(String[] args) { Connection conn = null; Statement stat = null; try { //1.注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //2.获取连接对象 conn = DriverManager.getConnection("jdbc:mysql:///db2", "root", "root"); //3.定义sql语句 String sql = "update account set balance = 1500 where id = 3"; //4.获取执行sql语句的对象Statement stat = conn.createStatement(); //5执行sql语句 int count = stat.executeUpdate(sql); //6.处理结果 System.out.println(count); if (count > 0){ System.out.println("修改成功"); }else { System.out.println("修改失败"); } } catch (ClassNotFoundException e) { throw new RuntimeException(e); } catch (SQLException e) { e.printStackTrace(); }finally { //7.是否资源 if (stat != null){ try { stat.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
JDBC练习-delete,DDL语句
public static void main(String[] args) { Connection conn = null; Statement state = null; try { //注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //获取连接对象 conn = DriverManager.getConnection("jdbc:mysql:///db2", "root", "root"); //定义sql String sql = "delete from account where id = 3"; //获取执行sql对象 state = conn.createStatement(); //执行sql int count = state.executeUpdate(sql); //处理结果 System.out.println(count); if (count > 0 ){ System.out.println("删除成功"); }else { System.out.println("删除失败"); } } catch (ClassNotFoundException e) { throw new RuntimeException(e); } catch (SQLException e) { throw new RuntimeException(e); }finally { //释放资源 if (state != null){ try { state.close(); } catch (SQLException e) { throw new RuntimeException(e); } } if (conn != null){ try { conn.close(); } catch (SQLException e) { throw new RuntimeException(e); } } } }
执行DDL语句:
public static void main(String[] args) { Connection conn = null; Statement state = null; try { //注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //获取连接对象 conn = DriverManager.getConnection("jdbc:mysql:///db2", "root", "root"); //定义sql String sql = "create table acc1(id int,name varchar(20))"; //获取执行sql对象 state = conn.createStatement(); //执行sql int count = state.executeUpdate(sql); //处理结果 System.out.println(count); } catch (ClassNotFoundException e) { throw new RuntimeException(e); } catch (SQLException e) { throw new RuntimeException(e); }finally { //释放资源 if (state != null){ try { state.close(); } catch (SQLException e) { throw new RuntimeException(e); } } if (conn != null){ try { conn.close(); } catch (SQLException e) { throw new RuntimeException(e); } } } }
原文地址:http://www.cnblogs.com/qihaokuan/p/16809823.html
1. 本站所有资源来源于用户上传和网络,如有侵权请邮件联系站长!
2. 分享目的仅供大家学习和交流,请务用于商业用途!
3. 如果你也有好源码或者教程,可以到用户中心发布,分享有积分奖励和额外收入!
4. 本站提供的源码、模板、插件等等其他资源,都不包含技术服务请大家谅解!
5. 如有链接无法下载、失效或广告,请联系管理员处理!
6. 本站资源售价只是赞助,收取费用仅维持本站的日常运营所需!
7. 如遇到加密压缩包,默认解压密码为"gltf",如遇到无法解压的请联系管理员!
8. 因为资源和程序源码均为可复制品,所以不支持任何理由的退款兑现,请斟酌后支付下载
声明:如果标题没有注明"已测试"或者"测试可用"等字样的资源源码均未经过站长测试.特别注意没有标注的源码不保证任何可用性