ShipInfo
-------------------------------------------------------
package bean;
public class ShipInfo
{ private long id;
private String date;
private String name;
private String plan_load;
private String load_shipno;
private String plan_unload;
private String unload_shipno;
private String notes; public ShipInfo()
{
} public long getId()
{
return id;
} public String getDate()
{
return date;
} public String getName()
{
return name;
} public String getPlanLoad()
{
return plan_load;
} public String getPlanUnLoad()
{
return plan_unload;
} public String getLoadShipNo()
{
return load_shipno;
} public String getUnLoadShipNo()
{
return unload_shipno;
} public String getNotes()
{
return notes;
} public void setId(long id)
{
this.id = id;
} public void setDate(String date)
{
this.date = date;
} public void setName(String name)
{
this.name = name;
} public void setPlanLoad(String plan_load)
{
this.plan_load = plan_load;
} public void setPlanUnLoad(String plan_unload)
{
this.plan_unload = plan_unload;
} public void setLoadShipNo(String load_shipno)
{
this.load_shipno = load_shipno;
} public void setUnLoadShipNo(String unload_shipno)
{
this.unload_shipno = unload_shipno;
} public void setNotes(String notes)
{
this.notes = notes;
}
}
------------------------------------------------DataLink1
-------------------------------------------------
package bean;import java.sql.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/public class DataLink1 { public DataLink1() {} private Connection getConnection(){
String ClassName="sun.jdbc.odbc.JdbcOdbcDriver";
String ServAndDDB="jdbc:odbc:jzx8_test";
String User="sa";
String Pwd="Gangjs";
Connection con = null;
try
{
Class.forName(ClassName);
con=DriverManager.getConnection(ServAndDDB,User,Pwd);
}
catch(Exception e)
{e.printStackTrace();} return con;
} public ShipInfo getRecord(long mid){
Connection cn = null;
PreparedStatement ps = null;
ResultSet rs = null;
ShipInfo si = null;
try{
cn = this.getConnection();
ps = cn.prepareStatement("select * from SHIP_INFO where id = ?");
ps.setLong(1,mid);
rs = ps.executeQuery();
if(rs.next()){
si= new ShipInfo();
si.setDate(rs.getString("date"));
si.setName(rs.getString("name"));
si.setPlanLoad(rs.getString("plan_load"));
si.setLoadShipNo(rs.getString("load_shipno"));
si.setPlanUnLoad(rs.getString("plan_unload"));
si.setUnLoadShipNo(rs.getString("unload_shipno"));
si.setNotes(rs.getString("notes"));
si.setId(rs.getLong("id"));
} }catch(Exception e){
System.out.println("+++++++++++++"+e.getMessage());
}finally{
try{if(ps != null) ps.close();}catch(Exception e){}
try{if(cn != null) cn.close();}catch(Exception e){} }
return si;
}
public static void main(String arg[]){
DataLink1 dl = new DataLink1();
ShipInfo si = null;
int x = 1;
try{
si = dl.getRecord(x);
}catch(Exception ex){
System.out.println("---------------------"+ex.getMessage());
}
System.out.print("------------"+si.getName());
}}
-------------------------------------------------------
package bean;
public class ShipInfo
{ private long id;
private String date;
private String name;
private String plan_load;
private String load_shipno;
private String plan_unload;
private String unload_shipno;
private String notes; public ShipInfo()
{
} public long getId()
{
return id;
} public String getDate()
{
return date;
} public String getName()
{
return name;
} public String getPlanLoad()
{
return plan_load;
} public String getPlanUnLoad()
{
return plan_unload;
} public String getLoadShipNo()
{
return load_shipno;
} public String getUnLoadShipNo()
{
return unload_shipno;
} public String getNotes()
{
return notes;
} public void setId(long id)
{
this.id = id;
} public void setDate(String date)
{
this.date = date;
} public void setName(String name)
{
this.name = name;
} public void setPlanLoad(String plan_load)
{
this.plan_load = plan_load;
} public void setPlanUnLoad(String plan_unload)
{
this.plan_unload = plan_unload;
} public void setLoadShipNo(String load_shipno)
{
this.load_shipno = load_shipno;
} public void setUnLoadShipNo(String unload_shipno)
{
this.unload_shipno = unload_shipno;
} public void setNotes(String notes)
{
this.notes = notes;
}
}
------------------------------------------------DataLink1
-------------------------------------------------
package bean;import java.sql.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/public class DataLink1 { public DataLink1() {} private Connection getConnection(){
String ClassName="sun.jdbc.odbc.JdbcOdbcDriver";
String ServAndDDB="jdbc:odbc:jzx8_test";
String User="sa";
String Pwd="Gangjs";
Connection con = null;
try
{
Class.forName(ClassName);
con=DriverManager.getConnection(ServAndDDB,User,Pwd);
}
catch(Exception e)
{e.printStackTrace();} return con;
} public ShipInfo getRecord(long mid){
Connection cn = null;
PreparedStatement ps = null;
ResultSet rs = null;
ShipInfo si = null;
try{
cn = this.getConnection();
ps = cn.prepareStatement("select * from SHIP_INFO where id = ?");
ps.setLong(1,mid);
rs = ps.executeQuery();
if(rs.next()){
si= new ShipInfo();
si.setDate(rs.getString("date"));
si.setName(rs.getString("name"));
si.setPlanLoad(rs.getString("plan_load"));
si.setLoadShipNo(rs.getString("load_shipno"));
si.setPlanUnLoad(rs.getString("plan_unload"));
si.setUnLoadShipNo(rs.getString("unload_shipno"));
si.setNotes(rs.getString("notes"));
si.setId(rs.getLong("id"));
} }catch(Exception e){
System.out.println("+++++++++++++"+e.getMessage());
}finally{
try{if(ps != null) ps.close();}catch(Exception e){}
try{if(cn != null) cn.close();}catch(Exception e){} }
return si;
}
public static void main(String arg[]){
DataLink1 dl = new DataLink1();
ShipInfo si = null;
int x = 1;
try{
si = dl.getRecord(x);
}catch(Exception ex){
System.out.println("---------------------"+ex.getMessage());
}
System.out.print("------------"+si.getName());
}}
ShipInfo
-------------------------------------------------------
package bean;
public class ShipInfo
{ private long id;
private String date;
private String name;
private String plan_load;
private String load_shipno;
private String plan_unload;
private String unload_shipno;
private String notes; public ShipInfo()
{
} public long getId()
{
return id;
} public String getDate()
{
return date;
} public String getName()
{
return name;
} public String getPlanLoad()
{
return plan_load;
} public String getPlanUnLoad()
{
return plan_unload;
} public String getLoadShipNo()
{
return load_shipno;
} public String getUnLoadShipNo()
{
return unload_shipno;
} public String getNotes()
{
return notes;
} public void setId(long id)
{
this.id = id;
} public void setDate(String date)
{
this.date = date;
} public void setName(String name)
{
this.name = name;
} public void setPlanLoad(String plan_load)
{
this.plan_load = plan_load;
} public void setPlanUnLoad(String plan_unload)
{
this.plan_unload = plan_unload;
} public void setLoadShipNo(String load_shipno)
{
this.load_shipno = load_shipno;
} public void setUnLoadShipNo(String unload_shipno)
{
this.unload_shipno = unload_shipno;
} public void setNotes(String notes)
{
this.notes = notes;
}
}
------------------------------------------------DataLink1
-------------------------------------------------
package bean;import java.sql.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/public class DataLink1 { public DataLink1() {} private Connection getConnection(){
String ClassName="sun.jdbc.odbc.JdbcOdbcDriver";
String ServAndDDB="jdbc:odbc:jzx8_test";
String User="sa";
String Pwd="Gangjs";
Connection con = null;
try
{
Class.forName(ClassName);
con=DriverManager.getConnection(ServAndDDB,User,Pwd);
}
catch(Exception e)
{e.printStackTrace();} return con;
} public ShipInfo getRecord(long mid){
Connection cn = null;
PreparedStatement ps = null;
ResultSet rs = null;
ShipInfo si = null;
try{
cn = this.getConnection();
ps = cn.prepareStatement("select * from SHIP_INFO where id = ?");
ps.setLong(1,mid);
rs = ps.executeQuery();
if(rs.next()){
si= new ShipInfo();
si.setDate(rs.getString("date"));
si.setName(rs.getString("name"));
si.setPlanLoad(rs.getString("plan_load"));
si.setLoadShipNo(rs.getString("load_shipno"));
si.setPlanUnLoad(rs.getString("plan_unload"));
si.setUnLoadShipNo(rs.getString("unload_shipno"));
si.setNotes(rs.getString("notes"));
si.setId(rs.getLong("id"));
} }catch(Exception e){
System.out.println("+++++++++++++"+e.getMessage());
}finally{
try{if(ps != null) ps.close();}catch(Exception e){}
try{if(cn != null) cn.close();}catch(Exception e){} }
return si;
}
public static void main(String arg[]){
DataLink1 dl = new DataLink1();
ShipInfo si = null;
int x = 1;
try{
si = dl.getRecord(x);
}catch(Exception ex){
System.out.println("---------------------"+ex.getMessage());
}
System.out.print("------------"+si.getName());
}}