Java Database类代码示例

import com.cloudant.client.api.Database; //导入依赖的package包/类
protected void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	Part part = request.getPart("file");

	String id = request.getParameter("id");
	String name = request.getParameter("name");
	String value = request.getParameter("value");
	String fileName = request.getParameter("filename");

	Database db = null;
	try {
		db = CloudantClientMgr.getDB();
	} catch (Exception re) {
		re.printStackTrace();
		response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR);
		return;
	}

	ResourceServlet servlet = new ResourceServlet();

	JsonObject resultObject = servlet.create(db, id, name, value, part, fileName);

	System.out.println("Upload completed.");

	response.getWriter().println(resultObject.toString());
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
@POST
public Response create(@QueryParam("id") Long id, @FormParam("name") String name, @FormParam("value") String value)
		throws Exception {

	Database db = null;
	try {
		db = getDB();
	} catch (Exception re) {
		re.printStackTrace();
		return Response.status(Response.Status.INTERNAL_SERVER_ERROR).build();
	}

	String idString = id == null ? null : id.toString();
	JsonObject resultObject = create(db, idString, name, value, null, null);

	System.out.println("Create Successful.");

	return Response.ok(resultObject.toString()).build();
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
@DELETE
public Response delete(@QueryParam("id") long id) {

	Database db = null;
	try {
		db = getDB();
	} catch (Exception re) {
		re.printStackTrace();
		return Response.status(Response.Status.INTERNAL_SERVER_ERROR).build();
	}

	// check if document exist
	HashMap<String, Object> obj = db.find(HashMap.class, id + "");

	if (obj == null) {
		return Response.status(Response.Status.NOT_FOUND).build();
	} else {
		db.remove(obj);

		System.out.println("Delete Successful.");

		return Response.ok("OK").build();
	}
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
private void addRequestChatHistory() {
    Database chatDB = helper.getChatDB();
    if(chatDB != null) {
        chatDB.save(new ChatModel()
                .setId(msgId + ChatModel.ID_SEPARATOR + "request")
                .setUserId(request.getUserId())
                .setRequest(request)
                .setTimestamp(timestamp)
        );
    }
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
private void addResponseChatHistory(List<Response> responseList) {
    Database chatDB = helper.getChatDB();
    if(chatDB != null) {
        chatDB.save(new ChatModel()
                .setId(msgId + ChatModel.ID_SEPARATOR + "response")
                .setUserId(request.getUserId())
                .setFromBot(true)
                .setResponse(responseList)
                .setTimestamp(new Date().getTime())
        );
    }
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
@Test
public void databaseBeanCreation() {
    Database mockDb = mock(Database.class);
    when(mockBuilder.build()).thenReturn(mockClient);
    when(mockClient.database("testName", true)).thenReturn(mockDb);

    this.context.register(MockCloudantClientConfig.class, MockClientBuilderConfig.class,
        CloudantAutoConfiguration.class);
    EnvironmentTestUtils.addEnvironment(this.context, "cloudant.db=testName");
    this.context.refresh();
    Database db = this.context.getBean(Database.class);
    assertEquals(mockDb, db);
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
public static Database getDB() {
	if (cloudant == null) {
		initClient();
	}

	if (db == null) {
		try {
			db = cloudant.database(databaseName, true);
		} catch (Exception e) {
			throw new RuntimeException("DB Not found", e);
		}
	}
	return db;
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
@PUT
public Response update(@QueryParam("id") long id, @QueryParam("name") String name,
		@QueryParam("value") String value) {

	Database db = null;
	try {
		db = getDB();
	} catch (Exception re) {
		re.printStackTrace();
		return Response.status(Response.Status.INTERNAL_SERVER_ERROR).build();
	}

	// check if document exist
	HashMap<String, Object> obj = db.find(HashMap.class, id + "");

	if (obj == null) {
		return Response.status(Response.Status.NOT_FOUND).build();
	} else {
		obj.put("name", name);
		obj.put("value", value);

		db.update(obj);

		System.out.println("Update Successful.");

		return Response.ok("OK").build();
	}
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
private void saveAttachment(Database db, String id, Part part, String fileName, HashMap<String, Object> obj)
		throws IOException {
	if (part != null) {
		InputStream inputStream = part.getInputStream();
		try {
			db.saveAttachment(inputStream, URLEncoder.encode(fileName,"UTF-8"), part.getContentType(), id, (String) obj.get("_rev"));
		} finally {
			inputStream.close();
		}
	}
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
private List<HashMap> initializeSampleData(Database db) throws Exception {

		long id = System.currentTimeMillis();
		String name = "Sample category";
		String value = "List of sample files";

		// create a new document
		System.out.println("Creating new document with id : " + id);
		Map<String, Object> data = new HashMap<String, Object>();
		data.put("name", name);
		data.put("_id", id + "");
		data.put("value", value);
		data.put("creation_date", new Date().toString());
		db.save(data);

		// attach the object
		HashMap<String, Object> obj = db.find(HashMap.class, id + "");

		// attachment#1
		File file = new File("Sample.txt");
		file.createNewFile();
		PrintWriter writer = new PrintWriter(file);
		writer.write("This is a sample file...");
		writer.flush();
		writer.close();
		FileInputStream fileInputStream = new FileInputStream(file);
		db.saveAttachment(fileInputStream, file.getName(), "text/plain", id + "", (String) obj.get("_rev"));
		fileInputStream.close();

		return db.getAllDocsRequestBuilder().includeDocs(true).build().getResponse().getDocsAs(HashMap.class);

	}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
public Database getDB(){
	return db;
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
@Bean
public Database hrsDb(CloudantClient cloudant) {
	return cloudant.database("hrs", true);
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
public Database getChatDB() {
    return chatDB;
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
public Database getFeedbackDB() {
    return feedbackDB;
}
 

import com.cloudant.client.api.Database; //导入依赖的package包/类
public Database getExplorerDB() {
    return explorerDB;
}