阅读背景:

一个servlet处理多个请求,地址字符串怎么处理呢

来源:互联网 
package web;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class AllEmp extends HttpServlet{
	public void service(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{
		Connection conn=null;
		PreparedStatement ps=null;
		ResultSet rs = null;
		String uri = request.getRequestURI();
		String path = uri.substring(uri.lastIndexOf("/"),uri.lastIndexOf("."));
		try {
			
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=Heros","sa","caxa");
			if(path.equals("/load")){
				ps=conn.prepareStatement("select * from s_emp where name=?");
				String name = request.getParameter("name");
				ps.setString(1, name);
				rs=ps.executeQuery();
				PrintWriter pw = response.getWriter();
				pw.println("<h1>hello</h1>");
				if(rs.next()){
					pw.println("<form action='update.do' method='post' />");
					pw.println("name:"+"<input   readonly='true' type='text' name='name' "+"value='"+name+"'/>"+"<br>");
					pw.println("salary:"+"<input type='text' name='salary' "+"value='"+rs.getString(2)+"'/><br>");
					pw.println("<input type='submit' value='ok'/>");
					pw.println("</form>");
				}
				
			}
			if(path.equals("/list")){
				ps=conn.prepareStatement("select * from s_emp");
				rs=ps.executeQuery();
				PrintWriter pw = response.getWriter();
				//pw.println("<h1>add success</h1>");
				pw.println("<a href='/go.html?url=addEmp.html' style='font-size:30pt;'>addEmp</a>");
				pw.println("<table  width='60%' border='1' cellpadding='2' cellspacing='0' id='table1'>");
				while(rs.next()){
					pw.println("<tr><td>"+rs.getString(1)+"</td><td>"+rs.getString(2)
							+"</td><td><a href='/go.html?url=del.do?name="+rs.getString(1)
							+"'>delete</a>  <a href='/go.html?url=load.do?name="+rs.getString(1)
							+"'>update</a></td></tr>");
					
				}
				pw.print("</table>");
			}
			if(path.equals("/add")){
				String name = request.getParameter("name");
				String salary = request.getParameter("salary");
				ps = conn.prepareStatement("insert into s_emp values(?,?)");
				ps.setString(1, name);
				ps.setString(2, salary);
				int i = ps.executeUpdate();
				PrintWriter pw = response.getWriter();
				pw.println("<h1>add success</h1>");
				response.sendRedirect("list.do");
			}
			if(path.equals("/del")){
				ps=conn.prepareStatement("delete from s_emp where name=?");
				String name = request.getParameter("name");
				ps.setString(1, name);
				ps.executeUpdate();
				PrintWriter pw = response.getWriter();
				response.sendRedirect("list.do");
			}
			if(path.equals("/update")){
				ps=conn.prepareStatement("update s_emp set salary=? where name=?");
				String salary = request.getParameter("salary");
				String name = request.getParameter("name");
				ps.setString(1, salary);
				ps.setString(2, name);
				ps.executeUpdate();
				PrintWriter pw = response.getWriter();
				response.sendRedirect("list.do");
			}
			
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null) rs.close();
				if(ps!=null) ps.close();
				if(conn!=null) conn.close();
				
			} catch (Exception e2) {
				// TODO: handle exception
				e2.printStackTrace();
			}
		}
	}


}
package web;

import java.io.IOException;
i



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: