java中数据库的读出

[admincf]

我想用java读取数据库的内容，然后在前台的jsp程序调用，但是……
import java.sql.*;
class enquiry1 {

public void linkdatabase() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
}
try {
conn=DriverManager.getConnection(link,dbuser,dbpassword);
}catch(SQLException e) {
System.out.println(e.getMessage());
}
}
public void SearchByName () {
String SQLCommand = "use ClubManagement"
+" select * from bookDetail ";
try{
stmt = conn.createStatement();
rs = stmt.executeQuery(SQLCommand);
int num = 0;
String[] BookName = new String [10];
while (rs.next()) {
BookName[num] = rs.getString(2);
System.out.println(BookName[num]);
// System.out.print("asdfas");
num++;
}
}catch(SQLException e) {
System.out.println(e.getMessage());
}
}

public void setbookname(String book_name) {
this.book_name = book_name;
}
public void setBookName(String BookName[]) {
this.BookName = BookName;
}
private String book_name;
private String book_author;
private int bookID;
private String book_price;
private String book_publisher;
private String book_ISBN;
private String link = "jdbc:odbc:database";
private String dbuser = "sa";
private String dbpassword = "1120";
private Connection conn = null;
private Statement stmt = null;
public ResultSet rs;
private String[] BookName = new String [10];
//where book_name like '%?%' and book_status<>'DEL'
}

public class enquiry {
public static void main(String args[]) {
enquiry1 op = new enquiry1();
op.linkdatabase();
op.setbookname("bruce");
op.SearchByName();

}

}
这样是可以的，但是
SQLCommand = "use ClubManagement"
+" select * from bookDetail where book_name like '%?%' and book_status<>'DEL'";
就没有结果了（在sunone里），我的sql是正确的，我试过的

[javaCandelaboy]

SQLCommand = "use ClubManagement"
+" select * from bookDetail where book_name like '%%' and book_status<>'DEL'";

[javacomte]

没有结果是指没有查到还是出错误？

[javaCandelaboy]

// 刚写的一个例子(sql server)：
import java.sql.*;

class DBConn1 {

//连接SqlServer数据库
void sqlServerConn() {
try {
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master";
String user = "sa";
String password = "btn";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = DriverManager.getConnection(url,user,password);

String sql = "use pubs " + " select * from authors where au_lname like ?";
//System.out.println(sql);
PreparedStatement pst = conn.prepareStatement(sql);
pst.clearParameters();
pst.setString(1,"%e%");
ResultSet rs = pst.executeQuery();

while(rs.next()) {
System.out.println(rs.getString("au_lname"));
}
}
catch(Exception e) {
System.out.println(e.getMessage());
}
}

public static void main(String[] args) {
DBConn1 sqlConn = new DBConn1();
sqlConn.sqlServerConn();
}
}