spring jdbc JdbcTemplate入门-优快云博客

本文详细介绍了数据库操作中常用的方法，包括创建、增加、删除、查询和更新数据的实现方式，以及如何通过JdbcTemplate进行数据库交互。文章还涵盖了特定查询方法的使用，如根据ID查询、获取指定列数据、通过条件查询等，并提供了示例代码。

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

填

jdbcTemplate.execute("CREATE TABLE USER (user_id integer, name varchar(100))");

增

@Override
	public int save(ArchiveBlob ab) {
		String sql = "insert into trace_archive_blob_table(id_archive,archive_name,application_id,date_string,date_string_2,archive_type,time_string,archive_value) values (?,?,?,?,?,?,?,?)";
		return this.getJdbcTemplate().update( sql, new Object[] {ab.getIdArchive(),ab.getArchiveName(),ab.getApplicationId(),ab.getDateString(),ab.getDateString2(),ab.getArchiveType(),ab.getTimeString(),ab.getArchiveValue()});

	}

删

@Override
	public int deleteArchiveBlob(String idAchrive){
		String sql = "delete from trace_archive_blob_table where id_archive='" + idAchrive+"'";
		return this.getJdbcTemplate().update(sql);
	}

查

@SuppressWarnings({ "rawtypes" })
	private class ArchiveBlobRowMapper implements RowMapper {
		@Override
		public ArchiveBlob mapRow(ResultSet rs, int i) throws SQLException {
			ArchiveBlob ab = new ArchiveBlob();
			ab.setIdArchive(rs.getString("id_archive"));
			ab.setArchiveName(rs.getString("archive_name"));
			ab.setApplicationId(rs.getLong("application_id"));
			ab.setDateString(rs.getLong("date_string"));
			ab.setDateString2(rs.getLong("date_string_2"));
			ab.setArchiveType(rs.getInt("archive_type"));
			ab.setTimeString(rs.getLong("time_string"));
			ab.setArchiveValue(rs.getString("archive_value"));
			return ab;
		}
	}

查Object

@SuppressWarnings("unchecked")
	@Override
	public ArchiveBlob getArchiveBlob(String idAchrive) {
		List <ArchiveBlob> list = new ArrayList<ArchiveBlob>(); 
		try{
			String sql = "select id_archive,archive_name,application_id,date_string,date_string_2,archive_type,time_string,archive_value "
				+ "from trace_archive_blob_table "
				+ "where id_archive = '" + idAchrive+"'";
		
			list = this.getJdbcTemplate().query(sql, new ArchiveBlobRowMapper());
			if (list !=null && list.size() >0) {
				return list.get(0);
			}
		}catch(Exception e){
			logger.error("Exception,", e);
		}
		return null;
	}

查 string

	@Override
	public String getArchiveBlobArchiverValue(String idAchrive) {
		String sql = "select archive_value  from trace_archive_blob_table  where id_archive = '" + idAchrive+"'";
		return this.getJdbcTemplate().queryForObject(sql, String.class);
	}

查list

@SuppressWarnings("unchecked")
	public List<UserAreaRelation> getUserAreaRelationList(int start, int end){
		String sql =" select  telephone,province, city, supplier  from application_user_id_area_relation_table limit "+start+","+end+" ";
		return this.getJdbcTemplate().query(sql, new UserAreaRelationRowMapper());
	}

改

@Override
	public int update(ArchiveBlob ab) {
		try
		{
			String sql = "update trace_archive_blob_table set  archive_name = '"+ab.getArchiveName()+"' ,application_id = "+ab.getApplicationId()+" ,date_string= "+ab.getDateString()+" ,date_string_2= "+ab.getDateString2()+" ,archive_type= "+ab.getArchiveType()+" ,time_string= "+ab.getTimeString()+" ,archive_value = '"+ab.getArchiveValue()+"'   where id_archive='"+ab.getIdArchive()+"'";
			return this.getJdbcTemplate().update(sql);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return -1;
	}