JDBC 增改查

最新推荐文章于 2024-11-19 17:33:59 发布

hufeng825

最新推荐文章于 2024-11-19 17:33:59 发布

阅读量963

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL

本文链接：https://blog.youkuaiyun.com/hufengvip/article/details/9280345

SQL 专栏收录该内容

2 篇文章

订阅专栏

本文提供了一个使用Java进行数据库操作的示例，包括获取建议记录、创建及更新建议记录的方法实现。通过连接数据源，执行SQL语句来完成数据的读取、插入与更新。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public List<SuggestCommandView> getSuggests()
{

Connection connection = null;
try {
List<SuggestCommandView>list = new ArrayList<SuggestCommandView>();
final String sql = "select * from APP_SUGGEST order by UPDATETIME desc,CREATETIME desc";
connection = dataSource.getConnection();
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
SuggestCommandView sug = new SuggestCommandView();
sug.setCreateTime(resultSet.getTimestamp("CREATETIME"));
sug.setMark(resultSet.getString("MARK"));
sug.setSugCode(resultSet.getString("SUGCODE"));
sug.setSugcontent(resultSet.getString("sugcontent"));
list.add(sug);
}
return list;
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
};

public void createSuggest(SuggestCommandVo vo)
{
Connection connection = null;
Statement stm = null;
try {
connection = dataSource.getConnection();
stm = connection.createStatement();
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//定义格式，不显示毫秒
Timestamp now = new Timestamp(System.currentTimeMillis());//获取系统当前时间
String str = df.format(now);
final String sql = " insert into TBL_SUGGEST values(SUGGEST_SEQ.NEXTVAL,'"+vo.getSugCode()+"',to_timestamp('"+ str +"','yyyy-mm-dd hh24:mi:ss'),to_timestamp('"+ str +"','yyyy-mm-dd hh24:mi:ss'),'"+vo.getMark()+"','"+vo.getSugcontent()+"')";
stm.execute(sql);
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
if (connection != null) {
try {
stm.close();
connection.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
}

public void updateSuggest(SuggestCommandVo vo)
{
Connection connection = null;
Statement stm = null;
try {
connection = dataSource.getConnection();
stm = connection.createStatement();
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//定义格式，不显示毫秒
Timestamp now = new Timestamp(System.currentTimeMillis());//获取系统当前时间
String str = df.format(now);
final String sql = " update TBL_SUGGEST set SUGCODE = '"+vo.getSugCode()+"',UPDATETIME = to_timestamp('"+ str +"','yyyy-mm-dd hh24:mi:ss'),MARK='"+vo.getMark()+"',SUGCONTENT ='"+vo.getSugcontent()+"'";
stm.execute(sql);
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
if (connection != null) {
try {
stm.close();
connection.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
}