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);
Goods goods = new Goods(gid,gname,gprice,gnum);
goodsList.add(goods);
}
}
catch (SQLException e) {
e.printStackTrace();
}
finally {
DbClose.queryClose(pstmt, rs, conn);
}

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,user,passwd);
}
catch (SQLException e) {
e.printStackTrace();
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
}