[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; } }}