Java
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/lostproper";
String user = "root";
String password = "sql.123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url,user,password);
if(!con.isClosed())
System.out.println("数据库连接成功");
Statement statement = con.createStatement();
String sql = "select * from lpdata";
ResultSet rs = statement.executeQuery(sql);
List<Map<String,String>> list = new ArrayList<Map<String,String>>();
while(rs.next()) {
Map<String,String> map = new HashMap<String,String>();
map.put("mLP_Name",rs.getString(2));
map.put("mLP_Date",rs.getString(3));
map.put("mLP_LostPlace",rs.getString(4));
list.add(map);
}
Gson gson = new Gson();
String jsonstr = null;
jsonstr = gson.toJson(list);