Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Sign up
Appearance settings

Commit 2704763

Browse files
upload excel for insert user
1 parent 084c123 commit 2704763

File tree

10 files changed

+2525
-40
lines changed

10 files changed

+2525
-40
lines changed

‎README.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,8 @@
88
* bootstrap3
99
* bootstrap-table1.9
1010
* druid
11-
* weui
11+
* [weui](https://github.com/weui/weui)
12+
* [jQuery-File-Upload](https://github.com/blueimp/jQuery-File-Upload)
1213

1314
# 微信扫码使用gitee工具
1415
![gitee工具](https://s1.ax1x.com/2018/08/10/P60MMF.jpg)

‎pom.xml

Lines changed: 10 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,10 +19,12 @@
1919
</developers>
2020

2121
<properties>
22+
<java.version>1.8</java.version>
2223
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
2324
<jfinal.version>4.8</jfinal.version>
2425
<freemarker.version>2.3.30</freemarker.version>
2526
<poi.version>4.1.2</poi.version>
27+
<cos.version>2020.4</cos.version>
2628
</properties>
2729

2830
<dependencies>
@@ -31,6 +33,12 @@
3133
<artifactId>jfinal</artifactId>
3234
<version>${jfinal.version}</version>
3335
</dependency>
36+
<!-- https://mvnrepository.com/artifact/com.jfinal/cos -->
37+
<dependency>
38+
<groupId>com.jfinal</groupId>
39+
<artifactId>cos</artifactId>
40+
<version>${cos.version}</version>
41+
</dependency>
3442
<dependency>
3543
<groupId>org.freemarker</groupId>
3644
<artifactId>freemarker</artifactId>
@@ -150,8 +158,8 @@
150158
<artifactId>maven-compiler-plugin</artifactId>
151159
<version>3.1</version>
152160
<configuration>
153-
<source>1.7</source> <!-- 源代码使用的开发版本 -->
154-
<target>1.7</target> <!-- 需要生成的目标class文件的编译版本 -->
161+
<source>8</source> <!-- 源代码使用的开发版本 -->
162+
<target>8</target> <!-- 需要生成的目标class文件的编译版本 -->
155163
<!--手动指定maven编译插件编译源码时使用的编码-->
156164
<!--<encoding>utf-8</encoding>-->
157165
</configuration>

‎src/main/java/cn/netbuffer/jfinal_bootstrap_table/controller/IndexController.java

Lines changed: 8 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -15,6 +15,7 @@
1515
import com.jfinal.kit.PropKit;
1616
import com.jfinal.plugin.ehcache.CacheInterceptor;
1717
import lombok.extern.slf4j.Slf4j;
18+
import org.apache.commons.collections4.CollectionUtils;
1819
import org.apache.commons.lang3.RandomUtils;
1920
import org.apache.commons.lang3.builder.ToStringBuilder;
2021
import java.io.File;
@@ -86,6 +87,9 @@ public void newdata() {
8687
public void export() {
8788
SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHHmmss");
8889
List<User> users = User.dao.find("select * from " + ConfigConstant.USERTABLE + " limit 50");
90+
if (CollectionUtils.isEmpty(users)) {
91+
renderText("暂无数据");
92+
}
8993
String projectPath = getRequest().getServletContext().getRealPath("export");
9094
int userCount = users.size();
9195
List<Map<String, Object>> mps = new ArrayList<Map<String, Object>>(users.size());
@@ -95,13 +99,13 @@ public void export() {
9599
}
96100
log.info("mps:{}", mps.toString());
97101
List<String> titles = new ArrayList<String>(mps.get(0).size() - 1);
98-
titles.add("adddate");
99-
titles.add("age");
100-
titles.add("deliveryaddress");
101102
titles.add("id");
102103
titles.add("name");
103-
titles.add("phone");
104+
titles.add("age");
104105
titles.add("sex");
106+
titles.add("phone");
107+
titles.add("adddate");
108+
titles.add("deliveryaddress");
105109
String file = projectPath + format.format(new Date()) + "." + ConfigConstant.EXCELSTR;
106110
POIExcelUtil.write(titles, mps, file);
107111
renderFile(new File(file));

‎src/main/java/cn/netbuffer/jfinal_bootstrap_table/controller/UserController.java

Lines changed: 22 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,12 +4,14 @@
44
import cn.netbuffer.jfinal_bootstrap_table.model.User;
55
import cn.netbuffer.jfinal_bootstrap_table.service.IUserService;
66
import cn.netbuffer.jfinal_bootstrap_table.service.impl.UserServiceImpl;
7+
import cn.netbuffer.jfinal_bootstrap_table.util.POIExcelUtil;
78
import com.jfinal.aop.Aop;
89
import com.jfinal.aop.Before;
910
import com.jfinal.core.Controller;
10-
import com.jfinal.plugin.ehcache.CacheInterceptor;
11+
import com.jfinal.upload.UploadFile;
1112
import lombok.extern.slf4j.Slf4j;
1213
import java.util.HashMap;
14+
import java.util.List;
1315
import java.util.Map;
1416

1517
/**
@@ -30,7 +32,7 @@ public void index() {
3032
/**
3133
* 开启缓存
3234
*/
33-
@Before({CacheInterceptor.class})
35+
// @Before({CacheInterceptor.class})
3436
public void userlist() {
3537
int limit = getParaToInt("limit");
3638
int offset = getParaToInt("offset");
@@ -62,4 +64,22 @@ public void update() {
6264
renderText(String.valueOf(userservice.update(user)));
6365
}
6466

67+
public void upload() {
68+
UploadFile file = getFile("excel");
69+
log.debug("接收文件上传:{}", file.getFileName());
70+
Map data = new HashMap();
71+
data.put("name", file.getFileName());
72+
List<List<String>> excelData = POIExcelUtil.read(file.getFile().getAbsolutePath());
73+
excelData.forEach(e -> {
74+
User user = new User();
75+
user.setName(e.get(0));
76+
user.setAge((int) Double.parseDouble(e.get(1)));
77+
user.setSex(e.get(2));
78+
user.setAdddate((int) System.currentTimeMillis() / 1000);
79+
log.debug("save user[{}]:{}", user, user.save());
80+
});
81+
data.put("count", excelData.size());
82+
renderJson(data);
83+
}
84+
6585
}

‎src/main/java/cn/netbuffer/jfinal_bootstrap_table/interceptor/AuthInterceptor.java

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -4,6 +4,7 @@
44
import com.jfinal.aop.Interceptor;
55
import com.jfinal.aop.Invocation;
66
import lombok.extern.slf4j.Slf4j;
7+
import org.apache.commons.lang3.StringUtils;
78
import org.apache.commons.lang3.builder.ToStringBuilder;
89

910
/**
@@ -16,13 +17,12 @@ public class AuthInterceptor implements Interceptor {
1617

1718
@Override
1819
public void intercept(Invocation inv) {
19-
log.info("Before [{}] method invoking",inv.getMethodName());
20+
log.info("Before [{}] method invoking",inv.getMethodName());
2021
Object login = inv.getController().getSession().getAttribute(ConfigConstant.ISLOGIN);
21-
log.info("invoking:" + inv.getControllerKey() + "--" + inv.getMethodName() + "--" + inv.getViewPath() + "--" + ToStringBuilder.reflectionToString(inv.getArgs()));
22-
//未登录跳转
23-
if (inv.getMethodName().equals("login") || inv.getMethodName().equals("captcha") || inv.getControllerKey().contains("register")
24-
|| (null != login && Boolean.parseBoolean(login.toString()))) {
25-
// //传递本次调用,调用剩下的拦截器与目标方法
22+
log.info("invoking controller[{}]method[{}]view[{}]args[{}]\nlogin status:{}", inv.getControllerKey(), inv.getMethodName(), inv.getViewPath(),
23+
ToStringBuilder.reflectionToString(inv.getArgs()), login);
24+
if (StringUtils.equalsAny(inv.getMethodName(), "login", "captcha") || inv.getControllerKey().contains("register") || (null != login && Boolean.parseBoolean(login.toString()))) {
25+
//传递本次调用,调用剩下的拦截器与目标方法
2626
inv.invoke();
2727
} else {
2828
inv.getController().renderJavascript("<script type='text/javascript'>alert('您还未登录,不能执行此操作!');</script>");

‎src/main/java/cn/netbuffer/jfinal_bootstrap_table/util/POIExcelUtil.java

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,12 @@ public static List<List<String>> read(String path) {
4343
int cells = row.getPhysicalNumberOfCells();
4444
List<String> arr = new ArrayList<>(cells);
4545
for (int i = 0; i < cells; i++) {
46-
arr.add(row.getCell(i).getStringCellValue());
46+
CellType cellType = row.getCell(i).getCellType();
47+
if (cellType == CellType.NUMERIC) {
48+
arr.add(String.valueOf(row.getCell(i).getNumericCellValue()));
49+
} else if (cellType == CellType.STRING) {
50+
arr.add(row.getCell(i).getStringCellValue());
51+
}
4752
}
4853
data.add(arr);
4954
}

‎src/main/webapp/manage.html

Lines changed: 35 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -7,6 +7,18 @@
77
<link href="static/bootstrap/bootstrap.min.css" rel="stylesheet">
88
<link href="static/bootstrap-table/bootstrap-table.min.css" rel="stylesheet">
99
<link href="static/bootstrap-datetimepicker.min.css" rel="stylesheet">
10+
<style>
11+
.hide-file {
12+
opacity: 0;
13+
position: absolute;
14+
top: 55px;
15+
background-color: red;
16+
z-index: 10000;
17+
height: 33px;
18+
width: 100px;
19+
left: 195px;
20+
}
21+
</style>
1022
</head>
1123
<body>
1224
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
@@ -76,9 +88,9 @@
7688
onclick="exporyAll();">
7789
<span class="glyphicon glyphicon-arrow-down"></span> 导出历史数据到excel
7890
</button>
79-
<button type="button" class="btn btn-default"
80-
onclick="import_from_xls();">
81-
<span class="glyphicon glyphicon-arrow-up"></span> 导入用户
91+
<button type="button" class="btn btn-default">
92+
<spanclass="glyphicon glyphicon-arrow-up"></span>
93+
<input class="hide-file" type="file" data-url="user/upload" name="excel" id="fileupload"/> 导入用户
8294
</button>
8395
<table id="dtb" data-toggle="table" data-url="user/userlist"
8496
class="table table-hover" data-show-columns="true" data-search="true"
@@ -165,8 +177,24 @@ <h4 class="modal-title" id="myModalLabel">今日新增的用户数据</h4>
165177
<script src="static/moment.min.js"></script>
166178
<script src="static/moment.zh-cn.js"></script>
167179
<script src="static/bootstrap-datetimepicker.min.js"></script>
180+
<script src="static/jquery-file-upload/jquery.ui.widget.js"></script>
181+
<script src="static/jquery-file-upload/jquery.fileupload.js"></script>
168182
<script type="text/javascript">
169183
$(function () {
184+
$("#fileupload").fileupload({
185+
add: function (e, data) {
186+
console.log("data:%o", data.files[0]);
187+
alert("上传文件:" + data.files[0].name);
188+
data.submit();
189+
},
190+
done: function (e, data) {
191+
console.log("上传完成:%o", data);
192+
if (data.result) {
193+
alert("成功插入" + data.result.count + "条数据");
194+
$("#dtb").bootstrapTable('refresh');
195+
}
196+
}
197+
});
170198
$.getJSON('newdata', function (data) {
171199
$("#xinzeng").text(data.newcount);
172200
$("#xinzeng").tooltip({"title": "今日新增数据,点击查看", "placement": "bottom"});
@@ -206,8 +234,10 @@ <h4 class="modal-title" id="myModalLabel">今日新增的用户数据</h4>
206234
//alert('You click remove icon, row: ' + JSON.stringify(row));
207235
var delid = $("[data-index=" + index + "]").find('td').eq(0).children().first().val();
208236
if (confirm("确定删除该条记录吗?" + delid)) {
209-
$.getJSON('user/delete', {"id": delid}, function (data) {
210-
$("#dtb").bootstrapTable('refresh');
237+
$.post('user/delete', {"id": delid}, function (data) {
238+
if (data.status == "success") {
239+
$("#dtb").bootstrapTable('refresh');
240+
}
211241
});
212242
}
213243
console.log(value, row, index);

‎src/main/webapp/register-success.html

Lines changed: 31 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -1,28 +1,40 @@
11
<!DOCTYPE html>
22
<html>
33
<head>
4-
<meta charset="UTF-8">
5-
<meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=0">
6-
<title>注册页</title>
7-
<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/weui/0.3.0/style/weui.min.css" />
8-
<link rel="stylesheet" type="text/css" href="css/register.css" />
4+
<meta charset="UTF-8">
5+
<meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=0">
6+
<title>注册成功</title>
7+
<link rel="stylesheet" type="text/css" href="https://cdn.bootcdn.net/ajax/libs/weui/2.3.0/style/weui.min.css"/>
98
</head>
109
<body ontouchstart>
11-
<div class="container">
12-
<div class="weui_msg">
13-
<div class="weui_icon_area"><i class="weui_icon_success weui_icon_msg"></i></div>
14-
<div class="weui_text_area">
15-
<h2 class="weui_msg_title">注册成功</h2>
16-
<p class="weui_msg_desc">您的注册成功啦</p>
10+
<div class="container" id="container">
11+
<div class="page msg_success js_show">
12+
<div class="weui-msg">
13+
<div class="weui-msg__icon-area"><i class="weui-icon-success weui-icon_msg"></i></div>
14+
<div class="weui-msg__text-area">
15+
<h2 class="weui-msg__title">注册成功</h2>
16+
<p class="weui-msg__desc">内容详情,可根据实际需要安排,如果换行则不超过规定长度,居中展现<a href="javascript:">文字链接</a></p>
17+
</div>
18+
<div class="weui-msg__opr-area">
19+
<p class="weui-btn-area">
20+
<a href="javascript:history.back();" class="weui-btn weui-btn_primary">继续注册</a>
21+
</p>
22+
</div>
23+
<div class="weui-msg__tips-area">
24+
<p class="weui-msg__tips">提示详情,可根据实际需要安排,如果换行则不超过规定长度,居中展现<a href="javascript:">文字链接</a></p>
25+
</div>
26+
<div class="weui-msg__extra-area">
27+
<div class="weui-footer">
28+
<p class="weui-footer__links">
29+
<a href="javascript:" class="weui-footer__link">底部链接文本</a>
30+
</p>
31+
<p class="weui-footer__text">Copyright © 2008-2016 weui.io</p>
32+
</div>
33+
</div>
1734
</div>
18-
<div class="weui_opr_area">
19-
<p class="weui_btn_area">
20-
<a class="weui_btn weui_btn_primary" href="javascript:;">确定</a>
21-
<a class="weui_btn weui_btn_default" href="javascript:;">取消</a>
22-
</p>
23-
</div>
24-
<div class="weui_extra_area">
25-
<a href="">查看详情</a>
35+
36+
<div class="page__ft j_bottom">
37+
<a href="javascript:home()"><img src="images/icon_footer_link.png"></a>
2638
</div>
2739
</div>
2840
</div>

0 commit comments

Comments
(0)

AltStyle によって変換されたページ (->オリジナル) /