java mysql模糊查询_java mysql模糊查询有问题 请纠错

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;publicclasssection17082{publicstaticfinalStringDBDRIVER="...

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class section17082{

public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";

public static final String DBURL = "jdbc:mysql://localhost:3306/leo";

public static final String DBUSER = "root";

public static final String DBPASS = "admin";

public static void main(String[] args) throws Exception{

String key = "凡";

String sql = "SELECT id,name,age,birthday FROM mytab" +

"WHERE name LIKE ?";

Class.forName(DBDRIVER);

Connection con = DriverManager.getConnection(DBURL,DBUSER,DBPASS);

PreparedStatement pre = con.prepareStatement(sql);

ResultSet res = pre.executeQuery();

pre.setString(1, "%" + key + "%");

while(res.next()){

int id = res.getInt(1);

String name = res.getString(2);

int age = res.getInt(3);

java.util.Date bir = res.getDate(4);

System.out.print("编号：" + id + "，");

System.out.print("姓名：" + name + "，");

System.out.print("年龄：" + age + "，");

System.out.println("生日：" + bir);

}

res.close();

pre.close();

con.close();

}

}

Exception in thread "main" java.sql.SQLException: No value specified for parameter 1

编译没问题，执行时出现了这个错误，求指出问题所在

展开