package com.spinfo.util;import com.esri.sde.sdk.client.SeConnection;
import com.esri.sde.sdk.client.SeException;public class SDEConnectionFactory {
private final static String server="127.0.0.1";
private final static int instance=5151;
private final static String database="";
private final static String user="sde";
private final static String password="spinfo";
private static SeConnection connection=null;
private SDEConnectionFactory(){
}
public static SeConnection getSDEConnection(){
if(connection==null||connection.isClosed()){
try {
connection=new SeConnection(server,instance,database,user,password);
} catch (SeException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}
return connection;
}}package com.spinfo.dto;import java.util.Vector;import com.esri.sde.sdk.client.SDEPoint;
import com.esri.sde.sdk.client.SeConnection;
import com.esri.sde.sdk.client.SeCoordinateReference;
import com.esri.sde.sdk.client.SeException;
import com.esri.sde.sdk.client.SeInsert;
import com.esri.sde.sdk.client.SeLayer;
import com.esri.sde.sdk.client.SeRow;
import com.esri.sde.sdk.client.SeShape;
import com.spinfo.util.SDEConnectionFactory;public class AddLineDTO { private SeConnection conn; public void addLine() {
conn = SDEConnectionFactory.getSDEConnection();
SeLayer insertLayer = null;
try {
if (conn != null) {
Vector list = conn.getLayers();
for (int i = 0; i < list.size(); i++) {
SeLayer layer = (SeLayer) list.elementAt(i);
if (layer.getName().equalsIgnoreCase("houjie_xl")) {
insertLayer = layer;
break;
}
}
conn.startTransaction();
String[] cols = new String[3];
cols[0] = new String("XLMC");
cols[1] = new String("JLID");
cols[2] = insertLayer.getSpatialColumn(); SeInsert insert = new SeInsert(conn);
insert.intoTable(insertLayer.getName(), cols);
insert.setWriteMode(true);
SeCoordinateReference coordref = insertLayer.getCoordRef(); SeShape shape = new SeShape(coordref);
SDEPoint[] pArray = new SDEPoint[3];
pArray[0] = new SDEPoint(364344.098, 536533.76);
pArray[1] = new SDEPoint(364293.709, 536525.047);
pArray[2] = new SDEPoint(364253.964, 536517.825); int[] partOffSets = new int[1];
partOffSets[0] = 0; shape.generateLine(3, 1, partOffSets, pArray);
Long a = (long) 1;
SeRow row = insert.getRowToSet();
row.setNString(0, "wowowo");
row.setLong(1, a);
row.setShape(2, shape); insert.execute();
insert.close();
conn.commitTransaction();
conn.close();
}
} catch (SeException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public static void main(String[] args) {
AddLineDTO line = new AddLineDTO();
line.addLine();
System.out.println("Go!Go!Go!");
}
}为什么表里面写的是LONG类型。程序里写的也是但出现GET REQUEST ON WRONG COLUMN TYPE.
要是把两句红的去掉之后是正确的
import com.esri.sde.sdk.client.SeException;public class SDEConnectionFactory {
private final static String server="127.0.0.1";
private final static int instance=5151;
private final static String database="";
private final static String user="sde";
private final static String password="spinfo";
private static SeConnection connection=null;
private SDEConnectionFactory(){
}
public static SeConnection getSDEConnection(){
if(connection==null||connection.isClosed()){
try {
connection=new SeConnection(server,instance,database,user,password);
} catch (SeException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}
return connection;
}}package com.spinfo.dto;import java.util.Vector;import com.esri.sde.sdk.client.SDEPoint;
import com.esri.sde.sdk.client.SeConnection;
import com.esri.sde.sdk.client.SeCoordinateReference;
import com.esri.sde.sdk.client.SeException;
import com.esri.sde.sdk.client.SeInsert;
import com.esri.sde.sdk.client.SeLayer;
import com.esri.sde.sdk.client.SeRow;
import com.esri.sde.sdk.client.SeShape;
import com.spinfo.util.SDEConnectionFactory;public class AddLineDTO { private SeConnection conn; public void addLine() {
conn = SDEConnectionFactory.getSDEConnection();
SeLayer insertLayer = null;
try {
if (conn != null) {
Vector list = conn.getLayers();
for (int i = 0; i < list.size(); i++) {
SeLayer layer = (SeLayer) list.elementAt(i);
if (layer.getName().equalsIgnoreCase("houjie_xl")) {
insertLayer = layer;
break;
}
}
conn.startTransaction();
String[] cols = new String[3];
cols[0] = new String("XLMC");
cols[1] = new String("JLID");
cols[2] = insertLayer.getSpatialColumn(); SeInsert insert = new SeInsert(conn);
insert.intoTable(insertLayer.getName(), cols);
insert.setWriteMode(true);
SeCoordinateReference coordref = insertLayer.getCoordRef(); SeShape shape = new SeShape(coordref);
SDEPoint[] pArray = new SDEPoint[3];
pArray[0] = new SDEPoint(364344.098, 536533.76);
pArray[1] = new SDEPoint(364293.709, 536525.047);
pArray[2] = new SDEPoint(364253.964, 536517.825); int[] partOffSets = new int[1];
partOffSets[0] = 0; shape.generateLine(3, 1, partOffSets, pArray);
Long a = (long) 1;
SeRow row = insert.getRowToSet();
row.setNString(0, "wowowo");
row.setLong(1, a);
row.setShape(2, shape); insert.execute();
insert.close();
conn.commitTransaction();
conn.close();
}
} catch (SeException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public static void main(String[] args) {
AddLineDTO line = new AddLineDTO();
line.addLine();
System.out.println("Go!Go!Go!");
}
}为什么表里面写的是LONG类型。程序里写的也是但出现GET REQUEST ON WRONG COLUMN TYPE.
要是把两句红的去掉之后是正确的
解决方案 »
- javaME问题求教 为什么线程只执行了一次
- 拉丁方:每一行中第一列的数字和最后一列的数字连起来构成一个环,则该环正好是由1到N顺序构成 这句话如何理解??
- 如何直接取得有多少笔数据包含在返回的数据集中???谢谢!
- 一个辅助类的问题
- 求助,计算器编程的问题!!!
- 关于静态方法的调用的问题??
- 关于applet和frame调用相同的类,但速度差异很大的疑问!
- 初学者:如何在命令行下运行由 JBuilder 编译的工程? ( linux 下 )
- 大家来发言:iPlanet的来龙去脉和用处,已经与同类软件的性能比较 :)
- 请推荐一本英文版的JAVA基础教程
- 为什么输出的不是"AB","AB"
- 求教字符串数组排序
你也可以尝试用
row.setLong("列名", a);
难道数据库不支持这个数据类型?
我表里写的是Long型,程序里写的Integer就可以不知道这个怎么回事?