Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.test1;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import android.app.Activity;
- import android.os.Bundle;
- import android.widget.TextView;
- public class Test1Activity extends Activity {
- /** Called when the activity is first created. */
- String str="new";
- static ResultSet rs;
- static PreparedStatement st;
- static Connection con;
- @Override
- public void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.main);
- final TextView tv=(TextView)findViewById(R.id.user);
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- con=DriverManager.getConnection("jdbc:mysql://10.0.2.2:8080/example","root","");
- st=con.prepareStatement("select * from country where id=1");
- rs=st.executeQuery();
- while(rs.next())
- {
- str=rs.getString(2);
- }
- tv.setText(str);
- setContentView(tv);
- }
- catch(Exception e)
- {
- tv.setText(str);
- }
- }
- }
- java.lang.management.ManagementFactory.getThreadMXBean, referenced from method com.mysql.jdbc.MysqlIO.appendDeadlockStatusInformation
- Could not find class 'javax.naming.StringRefAddr', referenced from method com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.storeTo
- Could not find method javax.naming.Reference.get, referenced from method com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.initializeFrom
- public void mysql() {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- thrd1 = new Thread(new Runnable() {
- public void run() {
- while (!Thread.interrupted()) {
- try {
- Thread.sleep(100);
- } catch (InterruptedException e1) {
- }
- if (con == null) {
- try {
- con = DriverManager.getConnection("jdbc:mysql://192.168.1.45:3306/deneme", "ali", "12345");
- } catch (SQLException e) {
- e.printStackTrace();
- con = null;
- }
- if ((thrd2 != null) && (!thrd2.isAlive()))
- thrd2.start();
- }
- }
- }
- });
- if ((thrd1 != null) && (!thrd1.isAlive())) thrd1.start();
- thrd2 = new Thread(new Runnable() {
- public void run() {
- while (!Thread.interrupted()) {
- if (con != null) {
- try {
- // con = DriverManager.getConnection("jdbc:mysql://192.168.1.45:3306/deneme", "ali", "12345");
- Statement st = con.createStatement();
- String ali = "'fff'";
- st.execute("INSERT INTO deneme (name) VALUES(" + ali + ")");
- // ResultSet rs = st.executeQuery("select * from deneme");
- // ResultSetMetaData rsmd = rs.getMetaData();
- // String result = new String();
- // while (rs.next()) {
- // result += rsmd.getColumnName(1) + ": " + rs.getInt(1) + "n";
- // result += rsmd.getColumnName(2) + ": " + rs.getString(2) + "n";
- // }
- } catch (SQLException e) {
- e.printStackTrace();
- con = null;
- }
- try {
- Thread.sleep(10);
- } catch (InterruptedException e) {
- e.printStackTrace();
- }
- } else {
- try {
- Thread.sleep(300);
- } catch (InterruptedException e) {
- e.printStackTrace();
- }
- }
- }
- }
- });
- }
- public void testDB() {
- TextView tv = (TextView) this.findViewById(R.id.tv_data);
- try {
- Class.forName("com.mysql.jdbc.Driver");
- // perfect
- // localhost
- /*
- * Connection con = DriverManager .getConnection(
- * "jdbc:mysql://192.168.1.5:3306/databasename?user=root&password=123"
- * );
- */
- // online testing
- Connection con = DriverManager
- .getConnection("jdbc:mysql://173.5.128.104:3306/vokyak_heyou?user=viowryk_hiweser&password=123");
- String result = "Database connection successn";
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from tablename ");
- ResultSetMetaData rsmd = rs.getMetaData();
- while (rs.next()) {
- result += rsmd.getColumnName(1) + ": " + rs.getString(1) + "n";
- }
- tv.setText(result);
- } catch (Exception e) {
- e.printStackTrace();
- tv.setText(e.toString());
- }
- }
- targetSdkVersion 8
Add Comment
Please, Sign In to add comment