首页 > 开发 > Java > 正文

java数据库连接、查询、更新等

2024-07-14 08:40:39
字体:
来源:转载
供稿:网友

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;   }  } 

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


注:相关教程知识阅读请移步到JAVA教程频道。
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表