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; }}}這篇文章就介紹到這,下一篇將為大家更好的更相關的文章。 ,下一篇將為大家更好的更相關的文章。