1 、 Java 数据库连接、查询、更新
nameGet = '%' + nameGet + '%'; String SqlGNAME = "SELECT * FROM GOODS WHERE GNAME like?"; 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); Marchandises = Nouveaux marchandises (GID, GNAME, GPRICE, GNUM); bourse de marchandises.add (marchandises); }} catch (sqlexception e) {e.printStackTrace (); } Enfin {dbclose.QueryClose (PSTMT, RS, Conn); }2 、连接数据库
classe finale publique dbConn {Connexion statique publique getConn () {connexion conn = null; String user = "root"; Chaîne passwd = "root"; String url = "jdbc: mysql: // localhost: 3306 / shop"; // 已加载完驱动 essayez {class.forname ("com.mysql.jdbc.driver"); Conn = driverManager.getConnection (URL, utilisateur, passwd); } catch (sqlexception e) {e.printStackTrace (); } catch (classNotFoundException e) {e.printStackTrace (); } return conn; }}这篇文章就介绍到这 ， 下一篇将为大家更好的更相关的文章。