1 、java 数据库连接、查询、更新
nameget = '%'+nameget+'%'; string sqlgname = "select * from good hwere gname like?"; try {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); Goods Goods = New Goods(GID、GNAME、GPRICE、GNUM); goodslist.add(商品); }} catch(sqlexception e){e.printstacktrace(); }最後に{dbclose.queryclose(pstmt、rs、conn); }2 、连接数据库
パブリックファイナルクラスdbconn {public static connection getConn(){connection conn = null;文字列ユーザー= "root";文字列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; }}这篇文章就介绍到这、下一篇将为大家更好的更相关的文章。