Question

rs.next()总为false的原因是什么

Connection con = null;
PreparedStatement st = null;
ResultSet rs = null;

try{
con = com.qooco.DBConnection.getImplementation().getConnection();
String sql = "select * from VOCABULARY where game_name = 'Translation' and topic= " + lesson_group_id;
System.out.println(sql);
st = con.prepareStatement(sql);
rs = st.executeQuery();
System.out.println(rs.next()) ;
while (rs.next()) {%>
<row cn="<%=rs.getString("cn")%>" en="<%=rs.getString("en")%>" />

<%}

Answer 1

你的sql写的不对
String sql="select * from VOCABULARY where game_name='Translation' and topic='" +lesson_group_id+"'";
备注：上面引号比较多的是加了 单引号，我没试验对不对，你把你打印出的sql语句放到数据库中执行，如果成功就说明你的sql没问题。 另外 rs.getString("cn")如果不行的话就用rs.getString(0);数字自己看着办