Monday 26 December 2016

Android Applicaton fetch data from MYSQL without JSON

try {
    Toast.makeText(this,"Using MYSQL",Toast.LENGTH_LONG).show();
    StrictMode.ThreadPolicy policy=new StrictMode.ThreadPolicy.Builder().permitAll().build();
    StrictMode.setThreadPolicy(policy);
    Class.forName("com.mysql.jdbc.Driver");
    Connection con= DriverManager.getConnection(url, user, pass);
    String result="Database connection successful";

    String sql = "Insert into contact values(?,?)";

    PreparedStatement preparedStatement = con.prepareStatement(sql);

    preparedStatement.setInt(1,Integer.parseInt(tid.getText().toString()) );
    preparedStatement.setString(2, tname.getText().toString());

    preparedStatement.execute();
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("Select * from contact");
    String x="";
    while(rs.next()){
        x+=rs.getString(1)+"\t"+rs.getString(2)+"\n";

    }
    Toast.makeText(this,x,Toast.LENGTH_LONG).show();
    //showMessage("Data from server ", x);    //showMessage("Data Inserted  ", "Show Query");}