/**
* @use 获取某一个属性的所有值
* @return ArrayList
*/
public ArrayList<String> getBookType(){
ArrayList<String> BookType = null;
Connection con = null;
Statement stmt = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql:///library", "root", "root");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT type FROM library.booktype");
BookType = new ArrayList<String>();
while(rs.next()){
String ttype = rs.getString("type");
BookType.add(ttype);
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
return BookType;
}
java获取数据库一个属性的所有值
最新推荐文章于 2023-01-21 15:02:33 发布