Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.ResultSetMetaData;
- import java.sql.Statement;
- import android.app.Activity;
- public class MysqlSample01Activity extends Activity {
- private static final String url = "jdbc:mysql://<server>:<port>/<database>";
- private static final String user = "<username>";
- private static final String pass = "<password>";
- /** Called when the activity is first created. */
- @Override
- public void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.main);
- testDB();
- }
- public void testDB() {
- TextView tv = (TextView)this.findViewById(R.id.text_view);
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection(url, user, pass);
- /* System.out.println("Database connection success"); */
- String result = "Database connection successn";
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from table_name");
- ResultSetMetaData rsmd = rs.getMetaData();
- while(rs.next()) {
- result += rsmd.getColumnName(1) + ": " + rs.getInt(1) + "n";
- result += rsmd.getColumnName(2) + ": " + rs.getString(2) + "n";
- result += rsmd.getColumnName(3) + ": " + rs.getString(3) + "n";
- }
- tv.setText(result);
- }
- catch(Exception e) {
- e.printStackTrace();
- tv.setText(e.toString());
- }
- }
- compile group: 'mysql', name: 'mysql-connector-java', version: '5.1.44'
Add Comment
Please, Sign In to add comment