Question

java 查询数据库怎么循环输出?

java 查询数据库,查询出来的数据要在界面中的JTextArea组件中循环输出，代码怎么写？

Answer 1

public void jButton1_actionPerformed(ActionEvent actionEvent) {
try {
Connection con=conDB();
Statement st = con.createStatement();
ResultSet rs=st.executeQuery("select NAME,PRICE from test");
StringBuffer sb=null;
定义一个 StringBuffer sb;
sb.append(rs.getString("NAME")+" "+rs.getString("PRICE"))
while(rs.next() )
{
sb.append(rs.getString("NAME")+" "+rs.getString("PRICE"));
jTextArea.append(sb.toString());
}
rs.close();
st.close();
con.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(null,"出现异常！");
}
}

Answer 2

public void getConn() {

// 注册驱动
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException e) {
System.out.println("驱动异常");
e.printStackTrace();
}

try {//这里抛个异常 可是连接没问题 是我QSL 有问题吗; SelectMethod=cursor
conn = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=company ",
"sa", "");
log("数据库连接正常！");
} catch (SQLException e) {
log("数据库连接失败！");
System.out.println("数据库连接失败");
e.printStackTrace();
}
}

Answer 3

查询的结果放到一个list集合中jsp页面中用forEach 循环输出
<c:forEach items="${requestScope.goodsList}" var="goods">
<tr ><td>${goods.g_name }</td>< /tr>
</c:forEach>

Answer 4

查出来数据放在集合里,然后循环集合输出不久OK了