Java database connection, query, update, etc.

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);     Goods goods = new Goods(gid,gname,gprice,gnum);     goodsList.add(goods);     }   } catch (SQLException e)   {     e.printStackTrace();   }finally   {     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,user,passwd);     }catch (SQLException e)     {       e.printStackTrace();     }     catch (ClassNotFoundException e)     {       e.printStackTrace();     }     return conn;   }  } 

这篇文章就介绍到这，下一篇将为大家更好的更相关的文章。