MySQL client Android version of the open source product

GitHub Address: Https://github.com/enbandari/aMysqlClient

Introduction

In line with the consistent style of love and nonsense, first of all why do you want to do this.

In other words, after a dog internship back, guarding the laboratory's big offer is not our style, so with the small partners began to engage in an application. The server and database of this application is naturally and habitually confessed to batting practice. Gossip does not watch. But said that a night batting practice is sleeping, roughly two more hours, by the client development sister a phone call wake up, the truth, the original MySQL data may be abnormal, need to batting practice to find out. Batting practice naturally reluctantly, but still galloped, turn over the earth, poke open small, a probe exactly.

Batting practice self-wondered, if the cell phone can understand this matter, why so much trouble ...

1. Search

Why repeat the wheel? So Google, unexpectedly no app can make Android phone operation MySQL. It hurts.

2, want to

How can this be good?

Pondering how long, how to simulate cmd to engage a MySQL command line? Open socket Connection 3306? Self-parsing protocol? Hu Fei Lanxiang Born, afraid of difficult to be competent ah. Also the fate of the return, at this time batting practice is churning server code, one eye on the spring jdbc. Shut up JDBC connection to MySQL, you can save a deal, really is to get all the time.

3, do

3.1 Android cannot be used directly with the spring core

Now that batting practice has decided to use spring JDBC, it's time to wonder how the Android side can use the server framework. Experiment several times, do not want spring core because Java library files and Android conflict and cannot use. Worry and worry. In this case, also save the trouble, think Spring JDBC is also a layer of JDBC, only with the spring JDBC should not harm it? Try it, sure enough.

3.2 Keeping the command context

Batting practice was drunk too. Try to do a command line directly with spring JDBC. It is also not possible to initially use a connection pool so that each command sent uses a different connection. So you want to use test (test is a library also!) ), and then select * FROM T (the table in the T Test Library also!) ), the other replied: Oh sorry, there is no t this table.

This..

How was the last dbcp? The problem is solved, the reason is that the connection is not released.

3.3 JDBC URL must specify the database name

Batting practice really not happy ... Batting practice how to know that your database server is subpackage. Want to go to, had to default to the JDBC URL configuration library named Information_schema, Sir if you have special needs, please help yourself!

4. See

Batting practice know, no picture no truth. The page is not so aesthetically pleasing. Don't pick the ha.

4.1 Easy Mode

A list of services where Sir can edit its own server information. Batting practice put this information into the Sir Mobile phone SQLite, batting practice don't want your password.

Sir, if you just come to onlookers, advise you to choose the simple mode bar.

Data that page is able to drag the ha! Up or down, no pressure!

4.2. Command line mode

The command-line mode is Sir familiar mode! Here, in order to facilitate Sir Input commands, batting practice provides the following convenient way!

4.2.1 Display History

Click ' MySQL ' to call out the history list ~ ~

4.2.2 Long Press ' mysql> ' to call out common commands

4.2.3 also has the keyword input shortcut area

4.2.4 keyword tips when entering a command

5. PostScript

In fact, the main function of the program is batting practice on the train home, the train is really boring.

Never turn on confusion, because confusion can cause a connection failure. Why? Batting practice recently interviewed too much, tired, do not want to tube.

MySQL client Android version of the open source product