1 、 Java 数据库连接、查询、更新
nameGet = '%'+nameGet+'%'; String sqlgname = "Pilih * dari barang -barang di mana gname seperti?"; coba {pstmt = conn.preparestatement (sqlgname); pstmt.setstring (1, nameGet); RS = PSTMT.ExecuteQuery (); while (rs.next ()) {int gid = rs.getint ("gid"); String gname = rs.getString (2); GPRice ganda = rs.getDouble (3); int gnum = rs.getint (4); Barang barang = barang baru (gid, gname, gprice, gnum); GoodsList.Add (barang); }} catch (sqlexception e) {e.printstacktrace (); } akhirnya {dbclose.queryclose (pstmt, rs, conn); }2 、连接数据库
kelas akhir publik dbconn {public static connection getConn () {connection conn = null; String user = "root"; String passwd = "root"; String url = "jdbc: mysql: // localhost: 3306/shop"; // 已加载完驱动 coba {class.forname ("com.mysql.jdbc.driver"); conn = driverManager.getConnection (url, pengguna, passwd); } catch (sqlexception e) {e.printstacktrace (); } catch (ClassNotFoundException e) {E.PrintStackTrace (); } return conn; }}这篇文章就介绍到这 , 下一篇将为大家更好的更相关的文章。