package web; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import com.google.gson.JsonArray; import com.google.gson.JsonObject; //import com.google.gson.JsonElement; public class Connectionserver { public String get() { JsonObject result = new JsonObject(); JsonArray jsonArray = new JsonArray(); String s= null; try { Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost/web", "root", "mysql"); Statement stmt = conn.createStatement(); String sql = "select * from service"; ResultSet rs = stmt.executeQuery(sql); System.out.println("sucessful"); ResultSetMetaData rsmd = rs.getMetaData() ; while (rs.next()) { JsonObject obj = new JsonObject(); for( int i = 1 ; i <= rsmd.getColumnCount() ; i ++ ) { obj.addProperty(rsmd.getColumnName(i), rs.getObject(rsmd.getColumnName(i)).toString()); } jsonArray.add(obj); } result.add("result", jsonArray); System.out.println(result); s=result.toString(); System.out.println(s); } catch (Throwable t) { result.addProperty("error", t.getLocalizedMessage()); t.printStackTrace(System.err); } return s; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)