java数据库操作 java数据库连接、查询、更新等
璐潇晓璐 人气:0想了解java数据库连接、查询、更新等的相关内容吗,璐潇晓璐在本文为您仔细讲解java数据库操作的相关知识和一些Code实例,欢迎阅读和指正,我们先划重点:java数据库连接、查询、更新,下面大家一起来学习吧。
1、java数据库连接、查询、更新
nameGet='%'+nameGet+'%'; String sqlGname = "SELECT * FROM GOODS WHERE GNAME LIKE ?"; try { pstmt = conn.prepareStatement(sqlGname); pstmt.setString(1, nameGet); rs = pstmt.executeQuery(); while (rs.next()) { int gid = rs.getInt("gid"); String gname = rs.getString(2); double gprice = rs.getDouble(3); int gnum = rs.getInt(4); Goods goods = new Goods(gid,gname,gprice,gnum); goodsList.add(goods); } } catch (SQLException e) { e.printStackTrace(); }finally { DbClose.queryClose(pstmt, rs, conn); }
2、连接数据库
public final class DbConn { public static Connection getconn() { Connection conn = null; String user = "root"; String passwd = "root"; String url = "jdbc:mysql://localhost:3306/shop"; //已加载完驱动 try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection(url,user,passwd); }catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } return conn; } }
这篇文章就介绍到这,下一篇将为大家更好的更相关的文章。
加载全部内容