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

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

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 rDkPNe)

{

e.printStackTrace();

}

catch (ClassNotFoundException e)

{

e.printStackTrace();

}

return conn;

}

}

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

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。