注册 登录
编程论坛 JAVA论坛

关于java数据库的问题

root0er 发布于 2016-09-26 09:49, 2342 次点击
想请教下java如何实现点击按钮后,数据库某一个表的结果显示在文本框中,下面是我数据库的实现代码:

程序代码:
public static void furnitureinfo() throws SQLException{
         DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/furniture","root","toor");
        java.sql.Statement stmt = conn.createStatement();
        java.sql.ResultSet rs = stmt.executeQuery("select * from  funiture_infornation;");
         List<Furniture_info> us = new ArrayList<Furniture_info>();
         String s[] = new String[3];
        while(rs.next()){
            Furniture_info furniture = new Furniture_info();
            furniture.setFuniture_id(rs.getInt("funiture_id"));
            furniture.setFuniture_name(rs.getString("funiture_name"));
            furniture.setFurniture_price(rs.getInt("Furniture_price"));
            furniture.setSupplier_id(rs.getInt("supplier_id"));
            furniture.setBrands(rs.getString("Brands"));
            furniture.setFurniture_material(rs.getString("Furniture_material"));
            furniture.setText(rs.getString("Text"));
            us.add(furniture);
    }
        for(Furniture_info furniture:us){
            System.out.println(furniture);      
        }
       }


刚学java,求解。。。:)
2 回复
#2
吃货丶2016-09-26 18:03
不是获取到了对象内容么,在JSP输出不就好了
#3
逆风而前2016-10-03 22:19
把错误提示信息写出来。
1