1 、 Java 数据库连接、查询、更新
nameget = '%'+nameget+'%'; String sqlgname = "select * из товара, где нравится Gname?"; 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); Товары = новые товары (GID, GNAME, GPRICE, GNUM); Goodslist.Add (товары); }} catch (sqlexception e) {e.printstacktrace (); } наконец {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, пользователь, passwd); } catch (sqlexception e) {e.printstacktrace (); } catch (classnotfoundexception e) {e.printstacktrace (); } return conn; }}这篇文章就介绍到这 ， 下一篇将为大家更好的更相关的文章。