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");}
Android Classes in Faisalabad
Monday 26 December 2016
Android Applicaton fetch data from MYSQL without JSON
Subscribe to:
Posts (Atom)