java mysql预处理_数据库使用预处理

[java]代码库import java.sql.*;

import java.util.*;

public class Example14_9 {

public static void main(String args[]) {

SequencePrepareQuery query=new SequencePrepareQuery();

String datasorce="star";

String tableName="employee";

query.setDatasourceName(datasorce);

query.setTableName(tableName);

ArrayList result=query.getQueryResult();

for(StringBuffer str:result) {

System.out.println(str);

}

}

}

import java.sql.*;

import java.util.*;

public class PreparedQuery {

String datasourceName=""; //数据源名

String tableName=""; //表名

String SQL; //SQL语句

ArrayList queryResult; //查询结果

public PreparedQuery() {

try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");