DatabaseConnection
package org.lzch.dbc;
import java.sql.Connection;
import java.sql.DriverManager;
public class DatabaseConnection {
private static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=login";
private static final String DBUSER="sa";
private static final String DBPASSWORD="000000";
private Connection conn=null;
public DatabaseConnection(){
try{
Class.forName(DBDRIVER);
this.conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
}catch(Exception e){
e.printStackTrace();
}
}
public Connection getConnection(){
return this.conn;
}
public void closeConnection(){
if(this.conn!=null){
try{
this.conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
}
DAOFactory
package org.lzch.factory;
import org.lzch.dao.IEmpDAO;
import org.lzch.dao.proxy.EmpDAOProxy;
public class DAOFactory {
public static IEmpDAO getIEmpDAOInstance(){
return new EmpDAOProxy();
}
}
EmpEncodingFilter
package org.lzch.filter;
import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
public class EmpEncodingFilter implements Filter {
private String charset=null;
public void destroy() {
// TODO Auto-generated method stub
}
public void doFilter(ServletRequest req, ServletResponse resp,
FilterChain chain) throws IOException, ServletException {
// TODO Auto-generated method stub
req.setCharacterEncoding(this.charset);
chain.doFilter(req, resp);
}
public void init(FilterConfig config) throws ServletException {
// TODO Auto-generated method stub
this.charset=config.getInitParameter("charset");
}
}
EmpServlet
package org.lzch.servlet;
import java.io.File;
import java.io.IOException;
import java.io.PrintWriter;
import java.net.URLDecoder;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.lzch.factory.DAOFactory;
import org.lzch.util.IPTimeStamp;
import org.lzch.vo.Emp;
import com.jspsmart.upload.SmartUpload;
public class EmpServlet extends HttpServlet {
public void service(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException{
String p=req.getParameter("p");
if(p.equals("emp_insert")){
this.doCreate(req, resp);
}
if(p.equals("doUpdatePage")){
this.doUpdatePage(req, resp);
}
if(p.equals("doUpdate")){
this.doUpda