📄 public.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.util.Date,
java.util.*,
java.io.*,
java.lang.*,
java.sql.*,
java.text.SimpleDateFormat,
com.gs.db.*,
com.gs.templet.*,
com.gs.db.dbimp.*,
com.gs.util.*,
com.gs.db.util.*"
%>
<%!
private static boolean isPermission(int[] types){
boolean bper = false;
for(int i = 0;i < types.length;i++){
if(PermissionsID == types[i])
return true;
}
return bper;
}
private static int i_permission = 5;
%>
<% ////////////////////////
// Authorization check
// check for the existence of an authorization token
Authorization authToken = SkinUtils.getUserAuthorization(request,response);
if ( authToken == null )
{
%>
<html> <body><p>未通过身份认证，请重新登录！</body></html>
<%
return;
}
IofficeFactory forumFactory = IofficeFactory.getInstance(authToken);
int userID = authToken.getUserID();
ProfileManager profileManager = forumFactory.getProfileManager();
User user = forumFactory.getProfileManager().getUser(authToken.getUserID());
if(user.isDisabled())
{
%>
<html> <body><p>用户已删除或禁用，请重新登录！</body></html>
<%
return;
}
String ipaddr = request.getRemoteAddr();
forumFactory.reportPulse(ipaddr,doThing);
int[] uPermType = forumFactory.getUserPermissionTypes(user);
boolean bper = isPermission(uPermType);
if(!bper){
%>
<html> <body><p>你无权访问本业务</body></html>
<%
return;
}
%>
<%! ////////////////////////
private final SimpleDateFormat todayDateFormatter =
new SimpleDateFormat("yyyy-MM-dd");
private final SimpleDateFormat todayDateFormatter2 =
new SimpleDateFormat("yyyyMMdd");
private final SimpleDateFormat todayTimeFormatter =
new SimpleDateFormat("HH:mm:ss");
%>
<%
String s_date = todayDateFormatter.format( new Date() );
String s_time = todayTimeFormatter.format( new Date() );
String s_date2 = todayDateFormatter2.format( new Date() );
%>
<%!private static final String INSERT_NR =
"INSERT INTO u_djnrb(djbh,djjg,gxdw,cldw, clr,tslx,lrr,clbz,tsly,tslybm,tslylxr,"
+
"tslylxdh,tsrmc,tsrq,tssj,tsfs,tsrdh,tsrdz,tsrem,tsyzbm,tslxr,btsdw,btsdwdz,"
+ "btsdwdh,btsdwlxr,btsdwlxrdh,btsdwyzbm,btspart,btsbrand,btsstyle,btsxflxdl,btsxflxzl,btsxflxxl,"
+ "tsnr,slqk,bz,ktwhmc,lrrID,lrryj,djjgjdyyj,djjghzryj,djjgjzyj,zbdwjdyyj,zbdwhzryj,zbdwjzyj"
+ ") " +
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
public void inserDB(Dbdjnr djnr) throws Exception {
String djbh = Dbdjnr.createID(djnr.getdjjg()+"20050410");
Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(INSERT_NR);
pstmt.setString(1, djbh);
pstmt.setString(2, djnr.getdjjg());
pstmt.setString(3, djnr.getgxdw());
pstmt.setString(4, djnr.getcldw());
pstmt.setString(5, djnr.getclr());
pstmt.setString(6, djnr.gettslx());
pstmt.setString(7, djnr.getlrr());
pstmt.setString(8, djnr.getclbz());
pstmt.setString(9, djnr.gettsly());
pstmt.setString(10, djnr.gettslybm());
pstmt.setString(11, djnr.gettslylxr());
pstmt.setString(12, djnr.gettslylxdh());
pstmt.setString(13, djnr.gettsrmc());
pstmt.setString(14, djnr.gettsrq());
pstmt.setString(15, djnr.gettssj());
pstmt.setString(16, djnr.gettsfs());
pstmt.setString(17, djnr.gettsrdh());
pstmt.setString(18, djnr.gettsrdz());
pstmt.setString(19, djnr.gettsrem());
pstmt.setString(20, djnr.gettsyzbm());
pstmt.setString(21, djnr.gettslxr());
pstmt.setString(22, djnr.getbtsdw());
pstmt.setString(23, djnr.getbtsdwdz());
pstmt.setString(24, djnr.getbtsdwdh());
pstmt.setString(25, djnr.getbtsdwlxr());
pstmt.setString(26, djnr.getbtsdwlxrdh());
pstmt.setString(27, djnr.getbtsdwyzbm());
pstmt.setString(28, djnr.getbtspart());
pstmt.setString(29, djnr.getbtsbrand());
pstmt.setString(30, djnr.getbtsstyle());
pstmt.setString(31, djnr.getbtsxflxdl());
pstmt.setString(32, djnr.getbtsxflxzl());
pstmt.setString(33, djnr.getbtsxflxxl());
pstmt.setString(34, djnr.gettsnr());
pstmt.setString(35, djnr.getslqk());
pstmt.setString(36, djnr.getbz());
pstmt.setString(37, djnr.getktwhmc());
pstmt.setString(38, djnr.getlrrID());
pstmt.setString(39, djnr.getlrryj());
pstmt.setString(40, djnr.getdjjgjdyyj());
pstmt.setString(41, djnr.getdjjghzryj());
pstmt.setString(42, djnr.getdjjgjzyj());
pstmt.setString(43, djnr.getzbdwjdyyj());
pstmt.setString(44, djnr.getzbdwhzryj());
pstmt.setString(45, djnr.getzbdwjzyj());
pstmt.executeUpdate();
}
catch (Exception sqle) {
sqle.printStackTrace();
throw new Exception("创建内容失败");
}
finally {
try {
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -