java 显示域_Java 怎么将数据库里的数据显示到文本域

publicstaticStringjilu(intusername){Connectioncon=null;PreparedStatementstmt=null;ResultSetrs=null;try{con=JdbcUtils.getConnection();Stringsql="selectoiandtimefromjiluwhe...

public static String jilu(int username)

{

Connection con=null;

PreparedStatement stmt=null;

ResultSet rs=null;

try {

con=JdbcUtils.getConnection();

String sql="select oi and time from jilu where userid=?";

stmt=con.prepareStatement(sql);

rs=stmt.executeQuery(sql);

while(rs.next())

{

System.out.println(rs.getInt("userid")+" "+rs.getInt("oi")+" "+rs.getInt("time"));

}

}catch(Exception e) {

e.printStackTrace();

}

finally {

JdbcUtils.close(rs, stmt, con);

}

return ;

}

我要使 userid,oi,time显示到文本域

JTextArea textarea=new JTextArea(Jdbc.jilu(Zhu.i));

textarea.setEditable(false);

textarea.setLineWrap(true);

textarea.setFont(new Font(null,Font.PLAIN,18));

JScrollPane scrollPane = new JScrollPane(

textarea,

ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS,

ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER

);

jf.setContentPane(scrollPane);

这是文本域的部分代码

展开