javabean servlt-优快云博客

本文链接：https://blog.youkuaiyun.com/achensuai/article/details/131368279

dao

StuInfDao.java

package dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import dbc.JdbcUtil;

import model.StuInf;

public class StuInfDao {

public int add(StuInf si) throws SQLException {

Connection conn = null;

PreparedStatement pst = null;

ResultSet rs = null;

int n = 0;

try {

conn = JdbcUtil.getConnection();

String sql = "insert into stu_info values(?,?,?,?,?,?)";

pst = conn.prepareStatement(sql);

pst.setInt(1, si.getId());

pst.setString(2, si.getName());

pst.setString(3, si.getSex());

pst.setInt(4, si.getAge());

pst.setFloat(5, si.getWeight());

pst.setFloat(6, si.getHeight());

n = pst.executeUpdate();

return n;

} finally {

JdbcUtil.free(rs, pst, conn);

}

public int delete(String name) throws SQLException {

Connection conn = null;

PreparedStatement pst = null;

ResultSet rs = null;

int n = 0;

try {

conn = JdbcUtil.getConnection();

String sql = "delete from stu_info where name=?";

pst = conn.prepareStatement(sql);

pst.setString(1, name);

n = pst.executeUpdate();

return n;

} finally {

JdbcUtil.free(rs, pst, conn);

}

public int update(StuInf si,int id) throws SQLException {

Connection conn = null;

PreparedStatement pst = null;

ResultSet rs = null;

int n = 0;

try {

conn = JdbcUtil.getConnection();

String sql="update stu_info set id=?,name=?,sex=?,age=?,weight=?,height=? where id=?";

pst=conn.prepareStatement(sql);

pst.setInt(1,si.getId());

pst.setString(2,si.getName());

pst.setString(3,si.getSex());

pst.setInt(4,si.getAge());

pst.setFloat(5,si.getWeight());

pst.setFloat(6,si.getHeight());

pst.setInt(7,id);

n=pst.executeUpdate();

return n;

} finally {

JdbcUtil.free(rs, pst, conn);

}

public StuInf selectById(int id) throws SQLException {

Connection conn = null;

PreparedStatement pst = null;

ResultSet rs = null;

StuInf si = null;

int n = 0;

try {

conn = JdbcUtil.getConnection();

String sql = "select * from stu_info where id=?";

pst = conn.prepareStatement(sql);

pst.setInt(1, id);

rs = pst.executeQuery();

if (rs.next()) {

si=new StuInf();

si.setId(rs.getInt("id"));

si.setName(rs.getString("name"));

si.setSex(rs.getString("sex"));

si.setAge(rs.getInt("age"));

si.setWeight(rs.getFloat("weight"));

si.setHeight(rs.getFloat("height"));

}

return si;

} finally {

JdbcUtil.free(rs, pst, conn);

}

public List<StuInf> selByMultiCondition(String sql) throws SQLException {

Connection conn = null;

PreparedStatement pst = null;

ResultSet rs = null;

StuInf si = null;

List<StuInf> list=new ArrayList<StuInf>();

try {

conn = JdbcUtil.getConnection();

pst = conn.prepareStatement(sql);

rs = pst.executeQuery();

while (rs.next()) {

si=new StuInf();

si.setId(rs.getInt("id"));

si.setName(rs.getString("name"));

si.setSex(rs.getString("sex"));

si.setAge(rs.getInt("age"));

si.setWeight(rs.getFloat("weight"));

si.setHeight(rs.getFloat("height"));

list.add(si);

}

return list;

} finally {

JdbcUtil.free(rs, pst, conn);

}

UsersDao.java

package dao;

import java.sql.*;

import dbc.JdbcUtil;

import model.Users;

public class UsersDao {

public int selectByIdPwd(Users us) throws SQLException

{

Connection conn=null;

PreparedStatement pst=null;

ResultSet rs=null;

int n=0;

try

{

conn=JdbcUtil.getConnection();

String sql="select * from users where userid=? and userpwd=? and usertype=?";

PreparedStatement ps=conn.prepareStatement(sql);

ps.setString(1, us.getUserid());

ps.setString(2, us.getUserpwd());

ps.setString(3, us.getUsertype());

rs=ps.executeQuery();

if(rs.next())

n=1;

}

finally

{

JdbcUtil.free(rs, pst, conn);

}

return n;

}

public int modiPwd(String newpwd,String userid) throws SQLException

{

Connection conn=null;

PreparedStatement pst=null;

ResultSet rs=null;

int n=0;

try

{

conn=JdbcUtil.getConnection();

String sql="update users set userpwd=? where userid=?";

PreparedStatement ps=conn.prepareStatement(sql);

ps.setString(1, newpwd);

ps.setString(2, userid);

n=ps.executeUpdate();

}

finally

{

JdbcUtil.free(rs, pst, conn);

}

return n;

}

public int insert(Users us)throws SQLException

{

Connection conn=null;

PreparedStatement pst=null;

ResultSet rs=null;

int n=0;

try

{

conn=JdbcUtil.getConnection();

String sql="insert into users values(?,?,?)";

pst=conn.prepareStatement(sql);

pst.setString(1, us.getUserid());

pst.setString(2, us.getUserpwd());

pst.setString(3, us.getUsertype());

n=pst.executeUpdate();

}

finally

{

JdbcUtil.free(rs, pst, conn);

}

return n;

}

servlet

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import model.Users;
import dao.UsersDao;

/**
* Servlet implementation class LoginServlet
*/
@WebServlet("/Login")
public class Login extends HttpServlet {
private static final long serialVersionUID = 1L;

   /**
   * @see HttpServlet#HttpServlet()
   */
   public Login() {
       super();
       // TODO Auto-generated constructor stub
   }

   /**
   * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
   *      response)
   */
   protected void doGet(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException {
       response.setContentType("text/html; charset=UTF-8");
       PrintWriter out = response.getWriter();
       HttpSession session = request.getSession();
       String userid = "";
       String userpwd = "";
       String usertype = "";
       int n;
       if ((request.getParameter("userid") == null) && (session.getAttribute("login") == null)) {
           out.print("<script>window.open('login.jsp','right');</script>");
       }
       if ((request.getParameter("userid") != null) && (request.getParameter("userpwd") != null)) {
           userid = request.getParameter("userid");
           userpwd = request.getParameter("userpwd");
           usertype = request.getParameter("usertype");
           Users us = new Users();
           us.setUserid(userid);
           us.setUserpwd(userpwd);
           us.setUsertype(usertype);
           UsersDao ud = new UsersDao();

           try {
               n = ud.selectByIdPwd(us);
               if (n == 1) {
                   session.setAttribute("pwd", userpwd);
                   session.setAttribute("login", userid);
                   out.print("<script>window.open('shujuadd_input.jsp','right');</script>");
               } else {
                   out.print("<script>alert('�û��󣡣�');</script>");
                   out.print("<script>window.open('login.jsp','right');</script>");
               }
           } catch (SQLException e) {
               e.printStackTrace();
           }
       }

   }

   /**
   * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
   *      response)
   */
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException {
       // TODO Auto-generated method stub
       doGet(request, response);
   }

}

ModifyPwd.java

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import dao.UsersDao;

/**

* Servlet implementation class ModifyPwdServlet

@WebServlet("/ModifyPwd")

public class ModifyPwd extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

public ModifyPwd() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse

* response)

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html; charset=UTF-8");

HttpSession session = request.getSession();

PrintWriter out = response.getWriter();

String oldpwd = request.getParameter("oldpwd");

String newpwd = request.getParameter("newpwd");

String renewpwd = request.getParameter("renewpwd");

String userid = (String) session.getAttribute("login");

System.out.println(userid);

String userpwd = (String) session.getAttribute("pwd");

// �ж��ȷ��һ��

if (!newpwd.equals(renewpwd)) {

out.print("<script>alert('��ȷ�Ͼ��벻һ��ȷ��');</script>");

// response.setHeader("refresh", "1;passwordmodi_input.jsp");

//out.print("<script>window.open('passwordmodi_input.jsp','right');</script>");

}

// �жϵ�½��Ƿ�һ��

if (!userpwd.equals(oldpwd)) {

out.print("<script>alert('��벻��ȷ��');</script>");

//out.print("<script>window.open('passwordmodi_input.jsp','right');</script>");

}

UsersDao ud = new UsersDao();

int n;

try {

n = ud.modiPwd(renewpwd, userid);

System.out.println(n);

if (n >= 1) {

out.print("<script>alert('��³ɹ��');</script>");

} else {

out.print("<script>alert('��ʧ�ܣ��');</script>");

}

out.print("<script>window.open('passwordmodi_input.jsp','right');</script>");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse

* response)

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import dao.UsersDao;

import model.Users;

/**

* Servlet implementation class RegisterServlet

@WebServlet("/Register")

public class Register extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

public Register() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html; charset=UTF-8");

PrintWriter out=response.getWriter();

String userid=request.getParameter("userid");

String userpwd=request.getParameter("userpwd");

String usertype=request.getParameter("usertype");

Users us=new Users();

us.setUserid(userid);

us.setUserpwd(userpwd);

us.setUsertype(usertype);

UsersDao ud=new UsersDao();

int n;

try {

n = ud.insert(us);

if(n>=1)

{

out.print("<script>window.open('login.jsp','right');</script>");

}

else

out.print("<script>alert('ע��ʧ�ܣ��');</script>");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

StuInfAdd.java

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import dao.StuInfDao;

import model.StuInf;

/**

* Servlet implementation class StuInfAddServlet

@WebServlet("/StuInfAdd")

public class StuInfAdd extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

public StuInfAdd() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html; charset=UTF-8");

PrintWriter out=response.getWriter();

int id=Integer.parseInt(request.getParameter("id"));

String name=request.getParameter("name");

String sex=request.getParameter("sex");

int age=Integer.parseInt(request.getParameter("age"));

float weight=Float.parseFloat(request.getParameter("weight"));

float height=Float.parseFloat(request.getParameter("height"));

StuInf si=new StuInf();

si.setId(id);

si.setName(name);

si.setSex(sex);

si.setAge(age);

si.setWeight(weight);

si.setHeight(height);

StuInfDao sid=new StuInfDao();

try {

int n=sid.add(si);

if(n==1)

out.print("<script>alert('添加成功');</script>");

else

out.print("<script>alert('添加失败');</script>");

out.print("<script>window.open('shujuadd_input.jsp','right');</script>");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

StuinfDelete.java

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import dao.StuInfDao;

/**

* Servlet implementation class StuInfDeleteServlet

@WebServlet("/StuInfDelete")

public class StuInfDelete extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

public StuInfDelete() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html; charset=UTF-8");

PrintWriter out=response.getWriter();

String name=request.getParameter("name");

StuInfDao sid=new StuInfDao();

int n;

try {

n = sid.delete(name);

if(n==1)

out.print("<script>alert('删除成功');</script>");

else

out.print("<script>alert('删除失败');</script>");

out.print("<script>window.open('shujudelete_input.jsp','right');</script>");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

StuinfSelect.java

package servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import dao.StuInfDao;
import model.StuInf;

/**
* Servlet implementation class StuInfSelect
*/
@WebServlet("/StuInfSelect")
public class StuInfSelect extends HttpServlet {
   private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public StuInfSelect() {
        super();
        // TODO Auto-generated constructor stub
    }

   /**
   * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
   */
   protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String sql="";
        int id;
        String name;
        float weight1;
        float weight2;
        if(!request.getParameter("id").equals(""))
        {
           id=Integer.parseInt(request.getParameter("id"));
           sql=sql+" and id="+id;
        }
        if(!request.getParameter("name").equals(""))
        {
           name=request.getParameter("name");
           sql=sql+" and name='"+name+"'";
        }
        if((request.getParameter("weight1")!="") && (request.getParameter("weight2")!=""))
        {
           weight1=Float.parseFloat(request.getParameter("weight1"));
           weight2=Float.parseFloat(request.getParameter("weight2"));
           sql=sql+" and weight between "+weight1+" and "+weight2;
        }
        sql="select * from stu_info where 1=1"+sql;
        StuInfDao sid=new StuInfDao();
        List<StuInf> list=new ArrayList<StuInf>();
        try {
           list=sid.selByMultiCondition(sql);
           request.setAttribute("result", list);
           request.getRequestDispatcher("shujuselect_process.jsp").forward(request, response);
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }

   }

   /**
   * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
   */
   protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       // TODO Auto-generated method stub
       doGet(request, response);
   }

}

Update

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import dao.StuInfDao;

import model.StuInf;

/**

* Servlet implementation class StuInfUpdate_SelectId

@WebServlet("/StuInfUpdate_SelById")

public class StuInfUpdate_SelById extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

public StuInfUpdate_SelById() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html; charset=UTF-8");

HttpSession session=request.getSession();

PrintWriter out=response.getWriter();

int idselect=Integer.parseInt(request.getParameter("id"));

session.setAttribute("id", idselect);

StuInfDao sid=new StuInfDao();

StuInf si=new StuInf();

try {

si = sid.selectById(idselect);

if(si!=null)

{

request.setAttribute("stuinf", si);

request.getRequestDispatcher("shujuupdate_process.jsp").forward(request, response);

}

else

{

out.print("<script>alert('没有该学生信息');</script>");

}

request.getRequestDispatcher("shujuupdate_input.jsp").forward(request, response);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

Update_SelByld

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import dao.StuInfDao;

import model.StuInf;

/**

* Servlet implementation class StuInfUpdate

@WebServlet("/StuInfUpdate")

public class StuInfUpdate extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

public StuInfUpdate() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html; charset=UTF-8");

PrintWriter out=response.getWriter();

HttpSession session=request.getSession();

int idselect=(int)(session.getAttribute("id"));

int id=Integer.parseInt(request.getParameter("id"));

String name=request.getParameter("name");

String sex=request.getParameter("sex");

int age=Integer.parseInt(request.getParameter("age"));

float weight=Float.parseFloat(request.getParameter("weight"));

float height=Float.parseFloat(request.getParameter("height"));

StuInf si=new StuInf();

si.setId(id);

si.setName(name);

si.setSex(sex);

si.setAge(age);

si.setWeight(weight);

si.setHeight(height);

StuInfDao sid=new StuInfDao();

try {

int n=sid.update(si, idselect);

if(n==1)

{

out.print("<script>alert('更新成功');</script>");

}

else

{

out.print("<script>alert('更新失败');</script>");

}

out.print("<script>window.open('shujuupdate_input.jsp','right');</script>");

}

catch (SQLException e) {

e.printStackTrace();

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}