date日期存入数据库

最新推荐文章于 2023-07-17 23:55:24 发布

跟着半仙学java

最新推荐文章于 2023-07-17 23:55:24 发布

阅读量450

点赞数 2

分类专栏： jdbc

本文链接：https://blog.csdn.net/oLengYueHun/article/details/87938008

版权

jdbc 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

public int getDate() {
		SimpleDateFormat sf = new SimpleDateFormat("yyyyMMdd");
	    int time = Integer.parseInt(sf.format(System.currentTimeMillis()).toString());
		return time;
	}
public void updateNewsTime(String listname,String cloumn1, int time, String cloumnid, int id) {// 改ztetitle
		// 项目 title下目录
		// update ztetitle set title='solutions123' where titleid='1;
		//u[date news set newsname='daw' where newsid='1';
		String sql = "update " + listname + " set " + cloumn1 + " =to_date('"+time+"','yyyyMMdd') where " + cloumnid + " = ?";
		try {
			DataBase.conn = DataBase.getConn();
			DataBase.pstm = DataBase.conn.prepareStatement(sql);
			DataBase.pstm.setInt(1, time);
			DataBase.pstm.setString(2, (id + ""));
			DataBase.pstm.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		DataBase.close();
	}