摘要
在Web应用系统中,用户们经常要求将数据库数据进行导入导出处理。Microsoft Excel是用户非常熟悉的办公软件,因此,Excel作为数据库数据导入导出的中间介质成为最佳选择。为了达到此目的,采用Java Excel API操作Excel文件的方法,实现了仅通过在客户端的操作,将数据库中的数据导出到Excel表格中,并将Excel表格中的数据导入数据库的功能。满足了用户进行数据库数据导入导出的要求。
In Web application system,clients always call for the data import and export from a database.Microsoft Excel is an office software which is very familiar to many clients,so Excel as a intermedia becomes the first option for data import and export from database.In order to achieve the goal,this method is adopted to operate Excel by Java Excel API.Only through the process on the client side,can the data be exported from database into Excel and data be imported from Excel into database.It meet the requirements of clients for data import and export.
出处
《现代电子技术》
2012年第4期45-47,共3页
Modern Electronics Technique
