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
编译没问题,执行时出现了这个错误,求指出问题所在
展开