代码如下:
int id=Integer.parseInt(request.getParameter("id"));
String name=request.getParameter("name");
String lat=request.getParameter("lat");
String lon=request.getParameter("lon");
String location="GeomFromText('POINT("+lon+" "+lat+")',4326)";
String sql="insert into test(id,name,location) values(?,?,?)";
DataConnection dbconn=new DataConnection();
PreparedStatement pstmt=null;
pstmt=dbconn.GetConnection().prepareStatement(sql);
pstmt.setInt(1,id);
pstmt.setString(2,name);
pstmt.setString(3,location);
pstmt.executeUpdate();
pstmt.close();
dbconn.CloseConnection();报错:ERROR: column "location" is of type geometry but expression is of type character varying
location是数据库中的一个geometry类型的数据,可就是不知道该怎么写,哪位给指点下啊?谢谢!新手啊!
int id=Integer.parseInt(request.getParameter("id"));
String name=request.getParameter("name");
String lat=request.getParameter("lat");
String lon=request.getParameter("lon");
String location="GeomFromText('POINT("+lon+" "+lat+")',4326)";
String sql="insert into test(id,name,location) values(?,?,?)";
DataConnection dbconn=new DataConnection();
PreparedStatement pstmt=null;
pstmt=dbconn.GetConnection().prepareStatement(sql);
pstmt.setInt(1,id);
pstmt.setString(2,name);
pstmt.setString(3,location);
pstmt.executeUpdate();
pstmt.close();
dbconn.CloseConnection();报错:ERROR: column "location" is of type geometry but expression is of type character varying
location是数据库中的一个geometry类型的数据,可就是不知道该怎么写,哪位给指点下啊?谢谢!新手啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货