String sql="Select * from 数据库A.分栏1 Where Name= ? "
try{
PreparedStatement ps=cn.preparedCall(sql);
ps.setString(1,name)
ResultSet rs=ps.executeQuery();
//your code here
......
rs.close();
ps.close();
}
catch (Exception e)
{}
try{
PreparedStatement ps=cn.preparedCall(sql);
ps.setString(1,name)
ResultSet rs=ps.executeQuery();
//your code here
......
rs.close();
ps.close();
}
catch (Exception e)
{}
String sql="Select * from 数据库A.分栏1 Where Name= '"+n+"'";
添加queryDataSet(设为queryDataSet1)和parameterRow(设为parameterRow1),在parameterRow1中添加name变量,
在queryDataSet1的setQuery()方法中加入SQL语句:
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * FROM 数据库A.分栏1 WHERE Name = :name", parameterRow1, true, Load.ALL));
执行用如下代码:
parameterRow1.setString("name",XXX);
queryDataSet1.refresh();
com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * FROM 数据库A.分栏1 WHERE Name = \'" + name + "\'", null, true, Load.ALL));
用这种方式时,可实现模糊查询,把“=”换成“LIKE”即可:
……Name LIKE \'%" + name + "%\'……
执行时用如下代码:
name = "newString";
com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * FROM 数据库A.分栏1 WHERE Name = \'" + name + "\'", null, true, Load.ALL));
queryDataSet1.refresh();
name = "newString";queryDataSet1.close();com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * FROM 数据库A.分栏1 WHERE Name LIKE \'%" + name + "%\'", null, true, Load.ALL));
queryDataSet1.refresh();