# dbcloud
**Repository Path**: csmake/dbcloud
## Basic Information
- **Project Name**: dbcloud
- **Description**: Accessing server-side database through JavaScript API， database support Mongodb Oracle MySQL sqlserver SQLite. Client javascript api support IE6.0+ Chrome FireFox Wechat
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No
## Statistics
- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-02-11
- **Last Updated**: 2020-12-18
## Categories & Tags
**Categories**: Uncategorized
**Tags**: None
## README
# dbcloud
## About us
Accessing server-side database through JavaScript API.
Database support `Mongodb` `Oracle` `MySQL` `sqlserver` `SQLite`.
Client javascript api support `IE6.0+` `Chrome` `FireFox` `Wechat`
You can do almost invoke on database through the javascript API in browser.
The client javascript api support `IE6.0+ Chrome FireFox and Wechat`
web: http://www.dbcloud.org
mail: dbcloud@csmake.com
## Application scenarios
* Rapid prototyping does not need to write server-side code.
* Academic teaching and research, WYSIWYG
* Enterprise internal application
* Other applications that do not focus on the security of the database table structure.
## Roadmap
* 1.0: mongodb support. see [webmongo](https://github.com/csmake/webmongo)
* 1.1: jdbc webclient javascript api support.
* 1.2: SQLite support
* 1.3: MySQL support
* 1.4: Sql server support
* 1.5: Oracle support
* ...
# MongoDB Development Manual
## Start the basic project
1. Run mongod first.
2. Put dbcloud.war in your servlet server webapps ,Apache Tomcat8.0 , Glass Fish Server4.x and so on.
3. Open browser(Chrome FireFox IE) and put http://localhost:8080/dbcloud/, The address may be different depending on your settings
## Start to write your web application
1. Copy MongoCollection.java and MongoCollectionServlet.java from dbcloud.war /src/java/.. , into your src/java/org/dbcloud/mongodb
2. Copy all *.js files in dbcloud.war /js to your js directory. JQuery is necessary. IE6.0 need to use the 1.x version and json2.js is necessary.
3. Edit the web.xml, like this:
```xml
MongoCollectionServlet
org.dbcloud.mongodb.MongoCollectionServlet
dbhost
127.0.0.1
dbport
27017
db
test
connection
test
user
password
MongoCollectionServlet
/org.dbcloud.mongodb.MongoCollection
```
4. Edit your html file, you can see the index.html
```javascript
```
# MySQL Development Manual
## Start the basic project
1. Run MySQL first.
2. Put webmysql.war in your servlet server webapps ,Apache Tomcat8.0 , Glass Fish Server4.x and so on.
3. Open browser(Chrome FireFox IE) and put http://localhost:8080/webmysql/, The address may be different depending on your settings
## Start to write your web application
1. Copy Statement.java and StatementServlet.java from webmysql.war /src/java/.. , into your src/java/org/dbcloud/mysql
2. Copy all *.js files in webmysql.war /js to your js directory. JQuery is necessary. IE6.0 need to use the 1.x version and json2.js is necessary.
3. Edit the web.xml, like this:
```xml
MySQLStatement
org.dbcloud.mysql.StatementServlet
guid
class
driver
com.mysql.jdbc.Driver
connection
jdbc:mysql://localhost:3306/yourdbname?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false
user
test
password
test
MySQLStatement
/org.dbcloud.mysql.Statement
```
4. Edit your html file, you can see the index.html
```javascript
MySQL demo
```