PreparedStatement进行模糊查询时的问题

  看不出有什么问题啊

import javadrivermanager getconnection 。sql。*;

public class Test{

public static void main(String[] args){

String driver = "comdrivermanager getconnection 。microsoft。

  jdbcdrivermanager getconnection 。sqlserver。SQLServerDriver";

String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";

String user = "sa";

String pwd = "";

try{

rName(driver);

Connection cnn = tConnection(url, user, pwd);

String sql = "select * from authors where au_lname like ?";

PreparedStatement pst = epareStatement(sql);

String name="%"+"M"+"%";

tString(1, name);

ResultSet rs = pstdrivermanager getconnection 。

  executeQuery();

while( xt()){

intln( tString("au_id"));

}catch(Exception e){

intStackTrace();

以上经过测试的drivermanager getconnection 。

String name="%"+"M"+"%";

改为：

String name="'%"+"M"+"%'"