MySQL client Android version of the open source product

Source: Internet
Author: User
Tags mysql command line

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.