jquery倒计时插件
jquery倒计时插件;简单实用,学习学习,说不定哪天就能用得上!
jquery.validate
基于jquery的验证框架,简单实用,有效! 学习学习没错!
SmartUpload上传
SmartUpload的上传实例;简单实用!是一款很轻巧的上传组件!
java用servlet实现文件上传到数据库
java用servlet实现文件上传到数据库
2009-03-19 14:26
index.jsp
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>文件上传</title>
<script>
</script>
</head>
<body>
<table align="center">
<form name="form1" enctype="multipart/form-data" method="POST" action="servletUpload">
<tr>
<td>
<div id="uploadDiv">
<input name=filename type=hidden>
<input name=file type=file>
<input type=submit value="上传文件">
</div>
</td>
</tr>
</table>
</body>
</html>
web.xml
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<servlet>
<servlet-name>upload</servlet-name>
<servlet-class>servletUpload</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>upload</servlet-name>
<url-pattern>/servletUpload</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
lib:jspupload.jar
java:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.jspsmart.upload.*;
public class servletUpload extends HttpServlet {
private ServletConfig config;
/**
* 初始化Servlet
*/
final public void init(ServletConfig config) throws ServletException {
this.config = config;
}
/**
* 处理GET请求
*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
out.println("<HTML>");
out.println("<BODY BGCOLOR='white'>");
out.println("<H1>jspSmartUpload : Servlet Sample</H1>");
out.println("<HR><BR>");
out.println("The method of the HTML form must be POST.");
out.println("</BODY>");
out.println("</HTML>");
}
/**
* 响应POST请求
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out = response.getWriter();
out.println("<HTML>");
out.println("<BODY BGCOLOR='white'>");
out.println("<H1>Upload File</H1>");
out.println("<HR>");
// 变量定义
SmartUpload mySmartUpload = new SmartUpload();
String myFileName = ""; //myFileName为带文件后缀
String filename = ""; //filename为不带文件后缀
String fileext = "";
int filesize = 0;
//连接数据库
Connection conn = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=TestUpload;User=sa;Password=sa");
System.out.println("Success to connect database");
}
catch (Exception e) {
System.out.println("Fail to connect database");
e.printStackTrace();
}
try {
// 初始化
mySmartUpload.initialize(config,request,response);
// 上载
mySmartUpload.upload();
com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(1);
if (!myFile.isMissing())
{
int t1;
myFileName = myFile.getFileName();
filename = myFileName.substring(0,myFileName.lastIndexOf('.'));
t1 = myFileName.lastIndexOf('.')+1;
fileext = myFileName.substring(t1,myFileName.length());
filesize = myFile.getSize();
}
String trace="c:/"+myFileName;
myFile.saveAs(trace,mySmartUpload.SAVE_PHYSICAL);
java.io.File file = new java.io.File(trace);
java.io.FileInputStream fis = new java.io.FileInputStream(file);
String sql="insert into fileinfo values (?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,filename);
pstmt.setString(2,fileext);
pstmt.setInt(3,filesize);
pstmt.setBinaryStream(4,fis,(int)file.length());
pstmt.executeUpdate();
//删除上传的原始文件
java.io.File origFile = new java.io.File("c:\\"+myFileName);
if (origFile.isFile() && origFile.exists()) {
origFile.delete();
}
// 显示处理结果
out.println(filename + "." + fileext + " has been uploaded.");
} catch (Exception e){
out.println("Unable to upload the file.<br>");
out.println("Error : " + e.toString());
}
out.println("</BODY>");
out.println("</HTML>");
}
}
Swing制作的ERP图表
用swing实现的制作(ERP)报表;很好很简单方便!
用mySmartUpload实现的文件上传和下载
很好很方便!比操作IO流简单多啦!而且很容易理解,mySmartUpload本身的操作类也很简单!