![]() |
#2
吃货丶2016-09-26 18:03
|

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);
}
}
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,求解。。。:)