一些基础的关于java jdbc的程序代码
} else if (i == 2) {
list = queryFirst();
i--;
} else if (i < 2) {
list = null;
}
return list;
}
public static boolean add(Country cou) {
Connection conn = DBConnection.getConnection();
PreparedStatement pstmt = null;
String sql = "insert into bbc values(?,?,?,?,?)";
int x = 0;
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, cou.getName());
pstmt.setString(2, cou.getRegion());
pstmt.setString(3, cou.getArea());
pstmt.setString(4, cou.getPopulation());
pstmt.setString(5, cou.getGdp());
x = pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (pstmt != null)
pstmt.close();
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
if (x == 1) {
return true;
} else {
return false;
}
}
public static boolean del(String key) {
Connection conn = DBConnection.getConnection();