我已经用过LIKE
条件,但它要求我将全名输入数据库才能找到名称。
if (searchby.equals("Name"))
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("\n Driver loaded");
Connection con=DriverManager.getConnection("jdbc:odbc:wanisamajDB");
Statement stmt=con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT Name FROM FAMILYcensus WHERE Name LIKE '"+ tfsearch.getText()+"'");
// ResultSet rs = stmt.executeQuery("SELECT Name FROM FAMILYcensus WHERE Name LIKE );
System.out.println("Hi");
rs.next();
String names = rs.getString("NAME");
System.out.println("NAME: " + names );
JOptionPane.showMessageDialog(null, "RECORD FOUND");
tasearch.setText(names);
}
catch (Exception e)
{
System.out.println("EXCEPTION " + e);
}
WhiteFang34 还说你需要迭代。但您还需要更改为 WHERE 子句:
"SELECT * FROM FAMILYcensus WHERE Name > '"+ tfsearch.getText()+"' ORDER BY Name ASC LIMIT "+MAXRESULTS;
请注意,限制结果数量是一个好主意。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)