java oracle timestamp

最新推荐文章于 2021-04-04 21:47:57 发布

YRZHLL

最新推荐文章于 2021-04-04 21:47:57 发布

阅读量742

点赞数

分类专栏：会视通项目文章标签： sql

本文链接：https://blog.csdn.net/YRZHLL/article/details/11578721

版权

会视通项目专栏收录该内容

6 篇文章 0 订阅

订阅专栏

	try {
			DriverManager
					.registerDriver(new oracle.jdbc.OracleDriver());
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
			} catch (Exception e3) {
				System.out.println("No Driver!");
			}
			String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
			String userName = "uaptest";
			String password = "uaptest";
			Connection conn = DriverManager.getConnection(url,
					userName, password);
			// Create a Statement
			Statement stmt = conn.createStatement();
			String sql = "insert into SYS_ALARM (RESOURCE_TYPE,RESOURCE_ID,IP,REMARK,CREATE_TIME) values ('"
					+ ap.getResouseType()
					+ "','"
					+ ap.getResourseId()  
					+ "','"
					+ ap.getIp()
					+ "','"
					+ ap.getDatail()
					+ "',TO_DATE('"
					+ ap.getCreateTime() + "','YYYY-MM-DD HH24:MI:SS'))";
			stmt.execute(sql);


		} catch (Exception e2) {
			System.out.println(e2);
		}