Question

谁有java模糊查询的完整代码啊，给看下呗！

Answer 1

import java.sql.*;
public class TestSql {

public static void main(String[] args) {
Connection conn;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jbdc.obdc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){

}
try{
conn=DriverManager.getConnection("jdbc:odbc:sun","xiao","123");
sql=conn.createStatement();
rs=sql.executeQuery("select name,math from chengjibiao where name like'_淑%'");
while(rs.next()){
String name=rs.getString(1);
int math = rs.getInt(2);
System.out.println("姓名："+name);
System.out.println("数学："+math);
}
conn.close();
}catch(SQLException e){
System.out.println(e);
}

}

}
//%代表0个或多个，_代表一个

Answer 2

模糊查询？是指数据库吧！
还是要用到数据库的查询语句的，和编程语句没多大关系。比如像sqlserver
select * from table where name like %li%

然后用jdbc去执行这条语句就ok啦