[servlet+mysql]

ConnBean.java

package sun.yourservlet; import java.sql.Connection; import java.sql.DriverManager; public class ConnBean { /** * Variables * */ /** * Methods * */ /** * 得到MySQL的 连接 * */ public Connection getMYSQLConnection() throws Exception { Connection conn=null; String DBdriver=("org.gjt.mm.mysql.Driver"); String DBurl="jdbc:MySQL://localhost:3333/chatdb?user=guest&password=guest"; Class.forName(DBdriver); conn=DriverManager.getConnection(DBurl); return conn; } /** * 得到以Excel表格为数据源的 ODBC数据源 的连接 * */ public Connection getExcelConnection() throws Exception{ Connection conn=null; String DBdriver="sun.jdbc.odbc.JdbcOdbcDriver"; String DBurl="jdbc:odbc:dbs_Excel"; Class.forName(DBdriver); conn=DriverManager.getConnection(DBurl); return conn; } /** * 得到用SQLServer驱动为数据源的连接 * */ public Connection getSQLServerConnection() throws Exception{ Connection conn=null; String DBdriber="com.microsoft.JDBC.sqlserver.SQLServerDriver"; String DBurl="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=news"; conn =DriverManager.getConnection(DBurl,"sa",""); return conn; } }

HandleData.java

package sun.yourservlet; import moon.yourbean.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class HandleData extends HttpServlet { public void init(ServletConfig config) throws ServletException{ super.init(config); } public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{ Equation equ=new Equation();//创建javabean对象 request.setAttribute("Equation", equ); double a=Double.parseDouble(request.getParameter("a")); double b=Double.parseDouble(request.getParameter("b")); double c=Double.parseDouble(request.getParameter("c")); equ.setA(a); equ.setB(b); equ.setC(c); if(a!=0){ equ.setIsSquareEquation(true); } else{ equ.setIsSquareEquation(true); } double disk=b*b-4*a*c; if(disk<0){ equ.setRootOne("没有实根"); equ.setRootTwo("没有实根"); } else{ double root1=(-b+Math.sqrt(disk))/(2*a), root2=(-b-Math.sqrt(disk))/(2*a); equ.setRootOne(""+root1); equ.setRootOne(""+root2); } RequestDispatcher dispatcher=request.getRequestDispatcher("show.jsp"); dispatcher.forward(request,response); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } }

HandleSum.java

package sun.yourservlet; import moon.yourbean.*; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class HandleSum extends HttpServlet { /** * init() * */ public void init(ServletConfig config) throws ServletException { super.init(config); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Series shulie=new Series(); request.setAttribute("lie",shulie); //将shulie储存到httpServletRequest对象中 double a=Double.parseDouble(request.getParameter("firstItem")); double d=Double.parseDouble(request.getParameter("var")); int n=Integer.parseInt(request.getParameter("number")); shulie.setFirstItem(a); shulie.setVar(d); shulie.setNumber(n); //计算和 double sum=0,item=a; int i=1; shulie.setName("等差数列的公差"); while(i<=n){ sum=sum+item; i++; item=item+d ; } shulie.setSum(sum); RequestDispatcher dispatcher=request.getRequestDispatcher("showResult.jsp"); dispatcher.forward(request, response); //请求showResult.jsp显示shulie中的数据 } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Series shulie =new Series(); request.setAttribute("lie",shulie); double a=Double.parseDouble(request.getParameter("firstItem")); double d=Double.parseDouble(request.getParameter("var")); int n=Integer.parseInt(request.getParameter("number")); shulie.setFirstItem(a); shulie.setVar(d); shulie.setNumber(n); //计算和 double sum=0,item=a; int i=1; shulie.setName("等比数列的公比"); while(i<=n){ sum=sum+item; i++; item=item*d; } shulie.setSum(sum); RequestDispatcher dispatcher=request.getRequestDispatcher("showResult.jsp"); dispatcher.forward(request,response); } }

 

LoginServlet.java

package sun.yourservlet; import javax.servlet.*; import javax.servlet.http.*; import moon.yourbean.*; import java.sql.*; public class LoginServlet extends HttpServlet { /** * Variables * */ String state; /** * Methods * */ /** * doPost() * */ public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException{ try{ LoginSessionBean loginBean=new LoginSessionBean(); int userID=Integer.parseInt(request.getParameter("userID")); String userPWD= (request.getParameter("userPWD")); if(login(userID,userPWD)){ loginBean.setUserID(userID); loginBean.setUserPWD(userPWD); loginBean.setState("登陆成功!"); } else{ loginBean.setState("登陆失败:"+state); } request.setAttribute("loginBean", loginBean); RequestDispatcher requestDispatcher=request.getRequestDispatcher("loginResult.jsp"); requestDispatcher.forward(request, response); } catch(Exception loginE){ System.out.println("--doPost() Exception--"); loginE.printStackTrace(); } } public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException{ doPost(request,response); } /** * login(ID,PWD) * */ private boolean login(int userID,String userPWD){ try{ Connection conn=new ConnBean().getExcelConnection(); PreparedStatement pstmt=conn.prepareStatement("SELECT userPWD FROM userInfo WHERE userID=?"); pstmt.setInt(1, userID); pstmt.addBatch(); ResultSet rs=pstmt.executeQuery(); String truePWD=null; while(rs.next()){ truePWD=rs.getString("userPWD"); if(userPWD.equals(truePWD)||userPWD==truePWD){ return true; } } return false; } catch(Exception le){ state=le.toString()+le.getStackTrace(); return false; } } }