import java.sql.*;
import java.util.*;
public class Example14_9 {
public static void main
(String args
[]) {
SequencePrepareQuery query=new SequencePrepareQuery();
query.setDatasourceName(datasorce);
query.setTableName(tableName);
ArrayList<StringBuffer> result=query.getQueryResult();
}
}
}
import java.sql.*;
import java.util.*;
public class PreparedQuery {
String datasourceName
=""; //数据源名
public PreparedQuery() {
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
}
}
public void setDatasourceName
(String s
) {
datasourceName=s.trim();
}
public void setTableName
(String s
) {
tableName=s.trim();
}
public void setSQL
(String SQL
) {
this.SQL=SQL;
}
public ArrayList <StringBuffer
> getQueryResult
() {
queryResult=new ArrayList<StringBuffer>();
try {
String uri
="jdbc:odbc:"+datasourceName
;
ResultSet rs1
=metadata.
getColumns(null,
null,tableName,
null);
int 字段个数=0;
while(rs1.next()) {
字段个数++;
}
sql=con.prepareStatemen(SQL);
rs=sql.executeQuery();
while(rs.next()) {
for(int k=1;k<=字段个数;k++) {
record.append(" "+rs.getString(k)+" ");
}
queryResult.add(record);
}
con.close();
}
System.
out.
println("请输入正确的表名"+e
);
}
return queryResult;
}
}
import java.sql.*;
import java.util.*;
public class PrepareQuery {
String datasourceName
=""; //数据源名
public PrepareQuery() {
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
}
}
public void setDatasourceName
(String s
) {
datasourceName=s.trim();
}
public void setTableName
(String s
) {
tableName=s.trim();
}
public void setSQL
(String SQL
) {
this.SQL=SQL;
}
public ArrayList <StringBuffer
> getQueryResult
() {
queryResult=new ArrayList<StringBuffer>();
try {
String uri
="jdbc:odbc:"+datasourceName
;
ResultSet rs1
=metadata.
getColumns(null,
null,tableName,
null);
int 字段个数=0;
while(rs1.next()) {
字段个数++;
}
sql=con.prepareStatement(SQL);
rs=sql.executeQuery();
while(rs.next()) {
for(int k=1;k<=字段个数;k++) {
record.append(" "+rs.getString(k)+" ");
}
queryResult.add(record);
}
con.close();
}
System.
out.
println("请输入正确的表名"+e
);
}
return queryResult;
}
}
import java.sql.*;
import java.util.*;
public class SequencePrepareQuery extends PrepareQuery {
public ArrayList <StringBuffer
> getQueryResult
() {
setSQL("SELECT * FROM "+tableName);
return super.getQueryResult();
}
}