?? addworknote.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="com.jspsmart.upload.*"%>
<%@ page import="com.bwm.string.Str"%>
<jsp:useBean id="myUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<%@ page import="com.zh.conpool.Condata"%>
<%@ page import="java.sql.*"%>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/style1.css" rel="stylesheet">
</HEAD>
<BODY BGCOLOR="white">
<%
Str str=new Str();
myUpload.initialize(pageContext);
myUpload.upload();
com.jspsmart.upload.File file1=myUpload.getFiles().getFile(0);
String path="/works/upload/"+request.getRemoteAddr()+"_"+((new java.util.Date()).toLocaleString()).substring(0,9)+"."+file1.getFileExt();
file1.saveAs(path);
String names= myUpload.getRequest().getParameter("names");
String branch= myUpload.getRequest().getParameter("branch");
String state= myUpload.getRequest().getParameter("state");
String times= str.toChinese(myUpload.getRequest().getParameter("times"));
String job= myUpload.getRequest().getParameter("job");
String contenttext= myUpload.getRequest().getParameter("contenttext");
String overthing= myUpload.getRequest().getParameter("overthing");
String days= myUpload.getRequest().getParameter("days");
String sql="insert into jobwork(Name,Branch,DateTime,BackPath,Content,Contenttext,Plcontent,Numday,Sign) values('"
+names+"','"+branch+"','"+times+"','"+path+"','"+job+"','"+contenttext+"','"+overthing+"','"+days+"','"+state+"')";
Condata conn=new Condata();
Connection con=null;
int rs=0;
try{
con=conn.getConnection();
rs=conn.executeUpdate(sql);
if(rs>=1){
out.println("<script language='javascript'>alert('添加成功');</script>");
%>
<jsp:include page="work_serach.jsp"/>
<%
}else if(rs<=0){
out.print("添加失敗，請返回！");
}
}catch(SQLException e){
out.print(e.toString());
}
if(con!=null){
con.close();
}
if(conn!=null){
conn.close();
}
%>
</BODY>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -