public ddd() {
index=0;
name="";
}
private int index;
private String name;
public String getName(){
return name;
}
public void setName(String sName){
this.name=sName;
}
public int getIndex(){
return index;
}
public void setIndex(int iIndex){
this.index=iIndex;
}
public ResultSet getResult(){
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
}catch(Exception e) {
return null;
}
Connection cn=null;
try
{
cn=DriverManager.getConnection("Jdbc:Odbc:aq","sa","");
}catch(Exception e){
return null;
}
ResultSet rs=null;
try
{
Statement st=cn.createStatement();
String tmp=null;
if(index==0)
{
tmp="select top 10 * from per order by name";
}
else if(index==1)
{
tmp="select top 10 * from per where name>'";
tmp=tmp+name;
tmp=tmp+"'";
tmp=tmp+" order by name";
System.out.print(tmp);
}