1 、 Java 数据库连接、查询、更新
nameGet = '%'+nameGet+'%'; String sqlgname = "Select * aus Waren, wo gname mag?"; 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); Warenwaren = neue Waren (GID, Gname, GPRICE, GNUM); Warenliste.add (Waren); }} catch (sqlexception e) {e.printstacktrace (); } endlich {dbclose.queryclose (pstmt, rs, conn); }2 、连接数据库
öffentliche endgültige Klasse 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, Benutzer, PassWD); } catch (sqlexception e) {e.printstacktrace (); } catch (classNotFoundException e) {e.printstacktrace (); } return conn; }}这篇文章就介绍到这 ， 下一篇将为大家更好的更相关的文章。 下一篇将为大家更好的更相关的文章。