📄 polyrecord.java
字号:
String sqlcmd = "SELECT * FROM "+tablename+sql+" group by NAME";
try
{
ResultSet rs_c = conn.createStatement().executeQuery(sqlcmd_c);
ResultSet rs = conn.createStatement().executeQuery(sqlcmd);
while (rs_c.next())
{
CountNumber++;
}
//System.out.println(CountNumber);
polyDate = new polyStruct[CountNumber];
int RolNumber = 0;
int i = 0;
while (rs.next())
{
name = rs.getString("NAME");
if (rs.getString("CONSTRACT") != null)
{
constract = rs.getString("CONSTRACT");
}
if (rs.getString("FILE") != null)
{
file = rs.getString("FILE");
}
if (rs.getString("PROJECTNUM") != null)
{
projectnum = rs.getString("PROJECTNUM");
}
if (rs.getString("TRANSACTION") != null)
{
transaction = rs.getString("TRANSACTION");
}
if (rs.getDate("TIME") != null)
{
projectTime = rs.getDate("TIME");
}
if (rs.getString("UNIT") != null)
{
unit = rs.getString("UNIT");
}
if (rs.getString("MAN1") != null)
{
man1 = rs.getString("MAN1");
}
if (rs.getString("MAN2") != null)
{
man2 = rs.getString("MAN2");
}
if (rs.getString("MAN3") != null)
{
man3 = rs.getString("MAN3");
}
if (rs.getString("ORIGINALDATA") != null)
{
originaldata = rs.getString("ORIGINALDATA");
}
if (rs.getString("CLARITYMAP") != null)
{
claritymap = rs.getString("CLARITYMAP");
}
if (rs.getString("PROJECTSIZE") != null)
{
projectsize = rs.getString("PROJECTSIZE");
}
if (rs.getString("PROJECTADDRESS") != null)
{
projectaddress = rs.getString("PROJECTADDRESS");
}
if (rs.getString("INDUSTRY") != null)
{
industry = rs.getString("INDUSTRY");
}
if (rs.getString("REMARK") != null)
{
remark = rs.getString("REMARK");
}
if (rs.getString("COORDINATE") != null)
{
coordinate = rs.getString("COORDINATE");
}
polyTempDate = new polyStruct();
polyTempDate.name = name;
polyTempDate.constract = constract;
polyTempDate.file = file;
polyTempDate.projectnum = projectnum;
polyTempDate.transaction =transaction;
polyTempDate.unit = unit;
polyTempDate.man1 = man1;
polyTempDate.man2 = man2;
polyTempDate.man3 = man3;
polyTempDate.originaldata = originaldata;
polyTempDate.claritymap = claritymap;
polyTempDate.projectsize = projectsize;
polyTempDate.projectaddress = projectaddress;
polyTempDate.industry = industry;
polyTempDate.remark = remark;
polyTempDate.coordinate = coordinate;
polyTempDate.time = projectTime;
polyTempDate.projectnum=projectnum;
polyDate[i] = polyTempDate;
i++;
}
//System.out.println(polyDate.length);
System.out.println(sqlcmd);
rs.close();
rs_c.close();
}
catch (Exception e1)
{
System.out.println(sqlcmd);
e1.printStackTrace();
}
return polyDate;
}
public polyStruct[] polyRecord_ReadFromName(String sql,String tablename)
{
polyStruct[] polyDate = null;
polyStruct polyTempDate;
int[] x = null;
int[] y = null;
String projectName;
int polyNumber = 0;
int pointNumber = 0;
int CountNumber = 0;
int projectNumber=0;
int number=0;
String filePath1 = null;
String filePath2 = null;
String filePath3 = null;
String projectMan = null;
String projectMan2 = null;
String projectMan3 = null;
String constract=null;
String file=null;
String projectnum=null;
String name=null;
String transaction=null;
String unit=null;
String man1=null;
String man2=null;
String man3=null;
String originaldata=null;
String claritymap=null;
String projectsize = null;
String projectaddress=null;
String industry=null;
String remark=null;
Date projectTime = null;
String coordinate=null;
String eposition=null;
String sqlcmd_c =
"SELECT COUNT(*) FROM "+tablename+sql+" group by PROJECTNUM";
String sqlcmd = "SELECT * FROM "+tablename+sql+" group by PROJECTNUM";
try
{
ResultSet rs_c = conn.createStatement().executeQuery(sqlcmd_c);
ResultSet rs = conn.createStatement().executeQuery(sqlcmd);
while (rs_c.next())
{
CountNumber++;
}
//System.out.println(CountNumber);
polyDate = new polyStruct[CountNumber];
int RolNumber = 0;
int i = 0;
while (rs.next())
{
name = rs.getString("NAME");
if (rs.getString("CONSTRACT") != null)
{
constract = rs.getString("CONSTRACT");
}
if (rs.getString("FILE") != null)
{
file = rs.getString("FILE");
}
if (rs.getString("PROJECTNUM") != null)
{
projectnum = rs.getString("PROJECTNUM");
}
if (rs.getString("TRANSACTION") != null)
{
transaction = rs.getString("TRANSACTION");
}
if (rs.getDate("TIME") != null)
{
projectTime = rs.getDate("TIME");
}
if(rs.getString("UNIT")!=null)
{
unit=rs.getString("UNIT");
}
if(rs.getString("MAN1")!=null)
{
man1=rs.getString("MAN1");
}
if(rs.getString("MAN2")!=null)
{
man2=rs.getString("MAN2");
}
if(rs.getString("MAN3")!=null)
{
man3=rs.getString("MAN3");
}
if(rs.getString("ORIGINALDATA")!=null)
{
originaldata=rs.getString("ORIGINALDATA");
}
if(rs.getString("CLARITYMAP")!=null)
{
claritymap=rs.getString("CLARITYMAP");
}
if(rs.getString("PROJECTSIZE")!=null)
{
projectsize=rs.getString("PROJECTSIZE");
}
if(rs.getString("PROJECTADDRESS")!=null)
{
projectaddress=rs.getString("PROJECTADDRESS");
}
if(rs.getString("INDUSTRY")!=null)
{
industry=rs.getString("INDUSTRY");
}
if(rs.getString("REMARK")!=null)
{
remark=rs.getString("REMARK");
}
if(rs.getString("COORDINATE")!=null)
{
coordinate=rs.getString("COORDINATE");
}
polyTempDate = new polyStruct();
polyTempDate.name = name;
polyTempDate.constract = constract;
polyTempDate.file = file;
polyTempDate.projectnum = projectnum;
polyTempDate.transaction =transaction;
polyTempDate.unit = unit;
polyTempDate.man1 = man1;
polyTempDate.man2 = man2;
polyTempDate.man3 = man3;
polyTempDate.originaldata = originaldata;
polyTempDate.claritymap = claritymap;
polyTempDate.projectsize = projectsize;
polyTempDate.projectaddress = projectaddress;
polyTempDate.industry = industry;
polyTempDate.remark = remark;
polyTempDate.coordinate = coordinate;
polyTempDate.time = projectTime;
polyTempDate.projectnum=projectnum;
polyDate[i] = polyTempDate;
i++;
}
//System.out.println(polyDate.length);
System.out.println(sqlcmd);
rs.close();
rs_c.close();
}
catch (Exception e1)
{
System.out.println(sqlcmd);
e1.printStackTrace();
}
return polyDate;
}
public boolean Delete(int pNumber,String tablename)
{
try
{
String sqlcmd = "DELETE FROM "+tablename+" WHERE PROJECTNUM =" +
pNumber;
conn.createStatement().executeUpdate(sqlcmd);
return true;
}
catch (Exception e)
{
e.printStackTrace();
}
return false;
}
public boolean Insert(recordStruct RecordP,String tablename)
{
try
{
if (RecordP!= null)
{
String sqlcmd = "INSERT INTO "+tablename+" (NUMBER, PROJECTNUM, NAME, X, Y,TIME,POS1,POS2,POS3,MAN,COORDINATE,EPOSITION) " +
"VALUES(?, ?, ?, ?,?,?,?,?,?,?,?,?)";
PreparedStatement ps = conn.prepareStatement(sqlcmd);
ps.setString(1,"");
ps.setInt(2,RecordP.getW_PROJECT_PROJECTNUMBER());
ps.setString(3,RecordP.getW_PROJECT_NAME());
ps.setString(4,RecordP.getW_PROJECT_POS_X());
ps.setString(5,RecordP.getW_PROJECT_POS_Y());
ps.setDate(6,new java.sql.Date(RecordP.getW_PROJECT_TIME().getTime()));
ps.setString(7,RecordP.getW_PROJECT_BOOK1_POS());
ps.setString(8,RecordP.getW_PROJECT_BOOK2_POS());
ps.setString(9,RecordP.getW_PROJECT_BOOK3_POS());
ps.setString(10,RecordP.getMan());
ps.setString(11,RecordP.getW_PROJECT_COORDINATE());
ps.setString(12,RecordP.getW_PROJECT_EPOSITION());
ps.executeUpdate();
ps.close();
return true;
}
else
{
return false;
}
}
catch (Exception e)
{
e.printStackTrace();
}
return false;
}
public String polyRecord_ReadProjectName()
{
String pn="";
String TRecord="";
String sqlcmd = "SELECT * FROM wugang_project_pos group by NAME";
try
{
ResultSet rs = conn.createStatement().executeQuery(sqlcmd);
while (rs.next())
{
if(rs.getString("NAME")!=null)
{
if (!TRecord.equalsIgnoreCase(rs.getString("NAME")))
{
TRecord = rs.getString("NAME");
pn=pn+TRecord+",";
}
}
}
}
catch(Exception e)
{
e.printStackTrace();
}
pn=pn+"*";
return pn;
}
public String polyRecord_ReadMan()
{
String pn="";
String TRecord="";
String sqlcmd = "SELECT * FROM wugang_project_pos group by NAME";
try
{
ResultSet rs = conn.createStatement().executeQuery(sqlcmd);
while (rs.next())
{
if(rs.getString("MAN")!=null)
{
if (!TRecord.equalsIgnoreCase(rs.getString("MAN")))
{
TRecord = rs.getString("MAN");
pn=pn+TRecord+",";
}
}
}
}
catch(Exception e)
{
e.printStackTrace();
}
pn=pn+"*";
return pn;
}
public Object[] polyRecord_getTableName()
{
try
{
DatabaseMetaData md = conn.getMetaData();
String types[] = {"TABLE"};
ResultSet set = md.getTables(null, null, null, types);
List list = new ArrayList();
//list.add(NO_TABLE);
while (set.next())
{
list.add(set.getObject(3));
}
set.close();
if (list.size() > 0)
return list.toArray();
}
catch (Exception e)
{
e.printStackTrace();
}
return null;
}
public int polyRecord_createTable(String tableName)
{
int i=0;//0为数据库出错,1为数据表插入成功,2为数据表重复
try
{
String sqlcmd = "CREATE TABLE "+tableName+" (NUMBER int(11) NOT NULL auto_increment,PROJECTNUM int(11) NOT NULL default '0',NAME varchar(200) NOT NULL default '',X varchar(100) NOT NULL default '',Y varchar(100) NOT NULL default '',TIME date NOT NULL default '0000-00-00',POS1 varchar(200) default NULL,POS2 varchar(200) default NULL,POS3 varchar(200) default NULL,MAN varchar(50) default NULL,COORDINATE varchar(100) NOT NULL default '',EPOSITION varchar(200) default NULL,PRIMARY KEY (NUMBER))";
conn.createStatement().executeUpdate(sqlcmd);
return 1;
}
catch (java.sql.SQLException e)
{
//e.printStackTrace();
if(e.getErrorCode()==1050)
{
return 2;
}
//System.out.println(e.getErrorCode());
}
return 0;
}
public Object[] polyRecord_getCoordinatename(String tablename)
{
String pn="";
String TRecord="";
String sqlcmd = "SELECT * FROM "+tablename+" group by COORDINATE";
List list = new ArrayList();
try
{
ResultSet rs = conn.createStatement().executeQuery(sqlcmd);
while (rs.next())
{
if(rs.getString("COORDINATE")!=null)
{
list.add(rs.getObject("COORDINATE"));
}
}
rs.close();
if (list.size() > 0)
return list.toArray();
}
catch(Exception e)
{
e.printStackTrace();
}
return null;
}
public void polyRecord_deleteFromprojectName(String tableName,String projectname)
{
try
{
String sqlcmd = "DELETE FROM "+tableName+" WHERE NAME='"+projectname+"'";
conn.createStatement().executeUpdate(sqlcmd);
}
catch (java.sql.SQLException e)
{
e.printStackTrace();
}
}
public static void main(String[] args)
{
String path="F:\\wu\\project\\sjhProject";
polyRecord polyRecord1 = new polyRecord(path);
//Object[] record=polyRecord1.polyRecord_getCoordinatename("wugang_project_pos1");
recordStruct record=new recordStruct(1,"1","1","1","1","1","1","1","1","1",new java.util.Date());
polyRecord1.Insert(record,"nanjin");
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -