您的位置:首页 > 博客中心 > 数据库 >

数据库课设(一)

时间:2022-03-14 04:32

    public List getDeptInfo(){	String sql = "select * from department";	PreparedStatement psmt=null;	List list = new ArrayList();	try {		psmt = conn.prepareStatement(sql);		ResultSet rs = psmt.executeQuery();		Department dept;		while(rs.next()){			dept = new Department();			dept.setDeptId(rs.getInt("DeptId"));			dept.setDeptName(rs.getString("DeptName"));			list.add(dept);		}	} catch (SQLException e) {		// TODO Auto-generated catch block		e.printStackTrace();	}	return list;}

热门排行

今日推荐

热门手游