首页 / JAVA / java JDBC (四)
java JDBC (四)
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了java JDBC (四),小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2837字,纯文字阅读大概需要5分钟。
内容图文
package cn.sasa.demo4; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; public class TestJDBCUtil { public static void main(String[] args) throws SQLException { Connection conn = JDBCUtil.getConn(); String sql = "SELECT * FROM product;"; PreparedStatement pstate = conn.prepareStatement(sql); ResultSet rs = pstate.executeQuery(); ArrayList<Product> plist = new ArrayList<Product>(); while(rs.next()) { Product p = new Product(rs.getInt("pid"), rs.getString("pname"), rs.getDouble("price"), rs.getString("ptype"), rs.getString("create_tm") ); plist.add(p); } JDBCUtil.close(conn, pstate, rs); for(var p : plist) { System.out.println(p.getPname() +"\t"+ p.getPrice()); } } }
package cn.sasa.demo4; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; /** * * JDBC 工具类 * @author THTF * */ public class JDBCUtil { private JDBCUtil() {} private static Connection conn; static { try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://192.168.0.207:3306/mydb"; String user = "root"; String pwd = "XXXXXXXXXXXXXX1"; conn = DriverManager.getConnection(url, user, pwd); }catch(Exception ex){ thrownew RuntimeException(ex + "数据库连接失败"); } } /** * 获得连接 */publicstatic Connection getConn() { return conn; } /** * 关闭资源 */publicstaticvoid close(Connection con, Statement state, ResultSet rs) { if(con != null) { try { con.close(); }catch(SQLException ex){ } } if(state != null) { try { state.close(); }catch(SQLException ex){ } } if(rs != null) { try { rs.close(); }catch(SQLException ex){ } } } publicstaticvoid close(Connection con, Statement state) { if(con != null) { try { con.close(); }catch(SQLException ex){ } } if(state != null) { try { state.close(); }catch(SQLException ex){ } } } }
package cn.sasa.demo4; public class Product { private int pid; private String pname; private double price; private String ptype; private String create_tm; public Product() {} public Product(int pid, String pname,double price, String ptype, String create_tm) { this.pid = pid; this.pname = pname; this.price = price; this.ptype = ptype; this.create_tm = create_tm; } publicint getPid() { return pid; } publicvoid setPid(int pid) { this.pid = pid; } public String getPname() { return pname; } publicvoid setPname(String pname) { this.pname = pname; } publicdouble getPrice() { return price; } publicvoid setPrice(double price) { this.price = price; } public String getPtype() { return ptype; } publicvoid setPtype(String ptype) { this.ptype = ptype; } public String getCreate_tm() { return create_tm; } publicvoid setCreate_tm(String create_tm) { this.create_tm = create_tm; } }
原文:https://www.cnblogs.com/SasaL/p/10240340.html
内容总结
以上是互联网集市为您收集整理的java JDBC (四)全部内容,希望文章能够帮你解决java JDBC (四)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。