java代码整理_java常用代码块整理

1.数据库操作(查询、更新等)

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;

}

}