# webmysql
**Repository Path**: csmake/webmysql
## Basic Information
- **Project Name**: webmysql
- **Description**: Accessing server-side MySQL through client javascript API.
- **Primary Language**: JavaScript
- **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
# webmysql
## About us
Accessing server-side MySQL through client javascript API. This project is a branch of [dbcloud](https://github.com/csmake/webmysql)
You can do almost invoke on MySQL through the javascript API in browser.
The client javascript api support `IE6.0+ Chrome FireFox and Wechat`
web: http://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.
## 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
```