public boolean update(String sql) {
Connection conn = null;
Statement st = null;
boolean rs = true;
try {
conn = ConnectionDateBase.getConnection();
st = conn.createStatement();
st.executeUpdate(sql);
} catch (SQLException e) {
rs = false;
e.printStackTrace();
} finally {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return rs;
}
/**
* 查询数据库，返回结果集
*
* @param sql 要执行的查询语句
* @return
*/
public ResultSet select(String sql) {
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try {
conn = ConnectionDateBase.getConnection();
st = conn.createStatement();
rs = st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
// finally {
// try {
// st.close();
// } catch (SQLException e) {
// e.printStackTrace();
// }
// try {
// conn.close();
// } catch (SQLException e) {
// e.printStackTrace();
// }
// }
return rs;
}
