1、java数据库连接、查询、更新
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
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、连接数据库
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
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;
}
}
|
这篇文章就介绍到这，下一篇将为大家更好的更相关的文章。
原文链接：https://blog.csdn.net/lxl121181/article/details/79174842