1、 java 数据库连接、查询、更新
nameget ='%'+nameget+'%';字符串sqlgname =“从gname喜欢的商品中select *?”;尝试{pstmt = conn.preparestatement(sqlgname); PSTMT.SetString(1,nameget); rs = pstmt.executequery(); while(rs.next()){int gid = rs.getInt(“ gid”);字符串gname = rs.getString(2); double gprice = rs.getDouble(3); int gnum = rs.getInt(4);商品=新商品(gid,gname,gprice,gnum); goodslist.add(货物); }} catch(sqlexception e){e.printstacktrace(); }最后{dbclose.queryclose(pstmt,rs,conn); }2 、连接数据库
公共最终类dbConn {public static Connection getConn(){连接conn = null;字符串用户=“ root”;字符串passwd =“ root”;字符串url =“ jdbc:mysql:// localhost:3306/shop”; //已加载完驱动try {class.forname(“ com.mysql.jdbc.driver”); conn = drivermanager.getConnection(url,用户,passwd); } catch(sqlexception e){e.printstacktrace(); } catch(classNotFoundException e){e.printstacktrace(); }返回conn; }}}这篇文章就介绍到这,下一篇将为大家更好的更相关的文章。,下一篇将为大家更好的更相关的文章。