mysql point_读取mysql point类型怎么直接set到实体中

展开全部

查询数62616964757a686964616fe78988e69d8331333361326361据库的时候，语句这样写：AsText(point类型的列)，如下：

sql = "select AsText(point), x(point), y(point), type, name, status from tb_point";//SQL语句

db1 = new DBHelper(sql);//创建DBHelper对象

try {

ret = db1.pst.executeQuery();//执行语句，得到结果集

while (ret.next()) {

final String point = ret.getString(1);

final String xpoint = ret.getString(2);

final String ypoint = ret.getString(3);

final String type = ret.getString(4);

final String name = ret.getString(5);

final int status = ret.getInt(6);

System.out.println(String.format("%s\t%s\t%s\t%s\t%s\t%d", point, xpoint,ypoint, type,name,status));

}//显示数据

ret.close();

db1.close();//关闭连接

} catch (final SQLException e) {

e.printStackTrace();

}

输出结果：

POINT(123.462202 41.804471)   123.462202    41.804471ViewPointYellow Stone Park1

POINT(123.462202 41.804471)   123.462202    41.804471ClinicTangZhen1