javaweb11

bean.jdbc

package bean;
import java.sql.*;


public class jdbc {
static Connection conn=null;
public static   Connection getConnection() throws ClassNotFoundException, SQLException {
String user="root";
String drivername="com.mysql.jdbc.Driver";
String usepwd="test";
String dbname="sys";
String url1="jdbc:mysql://localhost:3306/"+dbname;
String url2="?user="+user+"&password="+usepwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(drivername);
try{conn=DriverManager.getConnection(url);
return conn;}catch(Exception e) {
e.printStackTrace();
return null;
}
}
public static void free(ResultSet rs,Statement st,Connection conn)
{  
    try
    { 
        if(rs!=null)              
            rs.close();                       
    }catch (SQLException e) 
    { 
        e.printStackTrace();  
    }finally{
             try
             {
                 if(st!=null)
                     st.close();                 
             }catch (SQLException e) { e.printStackTrace();  
             } finally{
                 if(conn!=null)                       
                     try
                 { 
                         conn.close();  
                 }
                 catch (SQLException e) {  
                     e.printStackTrace();  
                  }  
                 }   
               }
    }

}

bean.Dao

package bean;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;


public class Dao {




public List<student> select(String id) throws ClassNotFoundException, SQLException{
Connection conn=null;
   PreparedStatement ps=null;
   conn=jdbc.getConnection();
   String sql="select * from "+id;
   ps=conn.prepareStatement(sql);
   List<student>list=new ArrayList<>();
   ResultSet rs=ps.executeQuery();
   while(rs.next()) {
    student p=new student();
    p.setName(rs.getString("name"));
    p.setId(rs.getInt("id"));
    p.setSex(rs.getString("sex"));
        list.add(p);}
   return list;
}

public void insert(student s,String classid) throws ClassNotFoundException, SQLException {
Connection conn=null;
   PreparedStatement ps=null;
   conn=jdbc.getConnection();
   String sql="insert into "+classid+" values(?,?,?)";
   ps=conn.prepareStatement(sql);
   ps.setString(1, s.getName());
   ps.setInt(2, s.getId());
   ps.setString(3, s.getSex());
   ps.executeUpdate();
}



public student select1(int id,String classid) throws ClassNotFoundException, SQLException {
Connection conn=null;
   PreparedStatement ps=null;
   conn=jdbc.getConnection();
   String sql="select * from "+classid+" where id=?";
   ps=conn.prepareStatement(sql);
   ps.setInt(1, id);
   ResultSet rs=ps.executeQuery();
   rs.next();
   student s=new student();
   s.setName(rs.getString("name"));
   s.setId(rs.getInt("id"));
   s.setSex(rs.getString("sex"));
   return s;
}


public void delete(int id, String classid) throws ClassNotFoundException, SQLException {
Connection conn=null;
   PreparedStatement ps=null;
   conn=jdbc.getConnection();
   String sql="delete from "+classid+" where id=?";
   ps=conn.prepareStatement(sql);
   ps.setInt(1, id);
   ps.executeUpdate();
}




public void update(int id,student s,String classid) throws ClassNotFoundException, SQLException {
Connection conn=null;
   PreparedStatement ps=null;
   conn=jdbc.getConnection();
   String sql="update "+classid+" set name=?,id=?,sex=? where id=?";
   ps=conn.prepareStatement(sql);
   ps.setString(1, s.getName());
   ps.setInt(2, s.getId());
   ps.setString(3, s.getSex());
   ps.setInt(4, id);
   ps.executeUpdate();
}

}

bean.student

package bean;


public class student {
String name;
int id;
String sex;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}

}

servelet.servelet

package servelet;


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


import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
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 bean.Dao;
import bean.student;


/**
 * Servlet implementation class servelet
 */
@WebServlet("/servelet")
public class servelet extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public servelet() {
        super();
        // TODO Auto-generated constructor stub
    }


/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Dao d=new Dao();
String id=request.getParameter("id");
HttpSession session=request.getSession();
session.setAttribute("classid", id);
try {
List<student>list=d.select(id);
request.setAttribute("list", list);
RequestDispatcher rd=request.getRequestDispatcher("web8.jsp");
rd.forward(request, response);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}


/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

}

servelet.servelet1

package servelet;


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


import javax.servlet.RequestDispatcher;
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 bean.Dao;


/**
 * Servlet implementation class servelet1
 */
@WebServlet("/servelet1")
public class servelet1 extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public servelet1() {
        super();
        // TODO Auto-generated constructor stub
    }


/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}


/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
String id[]=request.getParameterValues("id");
HttpSession session =request.getSession();
String classid=(String)session.getAttribute("classid");
Dao d=new Dao();
for(int i=0;i<id.length;i++) {
if(id!=null) {
int id1=Integer.parseInt(id[i]);
try {
d.delete(id1,classid);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}
PrintWriter out=response.getWriter();
out.print("批量删除成功");
}


}

servelet.servelet2

package servelet;


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


import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
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 bean.Dao;


/**
 * Servlet implementation class servelet2
 */
@WebServlet("/servelet2")
public class servelet2 extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public servelet2() {
        super();
        // TODO Auto-generated constructor stub
    }


/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");



HttpSession session=request.getSession();
String classid=(String)session.getAttribute("classid");

int id=Integer.parseInt(request.getParameter("id"));
Dao d=new Dao();
try {
d.delete(id,classid);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
PrintWriter out=response.getWriter();
out.print("删除成功");
}


/**
* @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);
}


}

sevelet.servelet3

package servelet;


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


import javax.servlet.RequestDispatcher;
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 bean.Dao;
import bean.student;


/**
 * Servlet implementation class servelet3
 */
@WebServlet("/servelet3")
public class servelet3 extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public servelet3() {
        super();
        // TODO Auto-generated constructor stub
    }


/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.getWriter().append("Served at: ").append(request.getContextPath());
}


/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
String name=request.getParameter("name");
int id=Integer.parseInt(request.getParameter("id"));
HttpSession session =request.getSession();
String classid=(String)session.getAttribute("classid");
String sex=request.getParameter("sex");
student s=new student();
s.setName(name);
s.setId(id);
s.setSex(sex);
Dao d=new Dao();
try {
d.insert(s,classid);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
PrintWriter out=response.getWriter();
out.print("添加成功");
}

}

servelet.servelet4

package servelet;


import java.io.IOException;
import java.io.PrintWriter;


import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


/**
 * Servlet implementation class servelet4
 */
@WebServlet("/servelet4")
public class servelet4 extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public servelet4() {
        super();
        // TODO Auto-generated constructor stub
    }


/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
String id=request.getParameter("id");
if(id==null)
{ServletRequest session = null;
id=(String)session.getParameter("id");}
PrintWriter out=response.getWriter();
out.print(id);
}


/**
* @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);
}

}

web11.jsp

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page import="bean.jdbc" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"  pageEncoding="UTF-8"%>  


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<table border="1"align="center" valign="center"> 
<tr><td>班级</td><td>人数</td><td>修改</td></tr>
<%
Connection conn=jdbc.getConnection();
String sql="select * from web11";
PreparedStatement pstmt=conn.prepareStatement(sql);
ResultSet rs=pstmt.executeQuery();
while(rs.next()){%>
<tr><td><%=rs.getString("name") %></td>
<td><%=rs.getInt("personnum") %></td>
<% String id=rs.getString("classid");
%>
<td><a href="servelet?id=<%=id %>">修改</a></td>
       
</tr>



<% }


%>
</table>
</body>

</html>

web8.jsp

<%@page import="java.util.List"%>
<%@page import="bean.student" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<table border="1"align="center" valign="center" ;


> 
<tr>
     <td>选择</td>
<td>姓名</td>
<td>学号</td>
<td>性别</td>
<td>删除</td>
<td>修改</td>
</tr>
<form action="servelet1" method="post">
　　　　　　　　　　　　　　　　　　　　　　　　　　
<input type="submit" value="删除">
<br>
<% 
List<student>list=(List<student>)request.getAttribute("list");
if(list!=null)
{student s=new student();
 for(int i=0;i<list.size();i++){
s=list.get(i);
%>
<tr>
<td><input type="checkbox" name="id" value=<%=s.getId() %>></td>
<td><%=s.getName() %></td>
<td><%=s.getId() %></td>
<td><%=s.getSex() %></td>
<td><a href="servelet2?id=<%=s.getId()%>">删除</a></td>
<td><a href="web8-1.jsp?id=<%=s.getId()%>">修改</a></td>
</tr>
<%  }
 
}
%>
<div align="center"><a href="web8-3.jsp">添加</a></div>
</form>
</table>
</body>

</html>

web8-1.jsp

<%@page import="bean.Dao"%>
<%@page import="bean.student"%>
<%@page import="java.sql.Connection"%>
<%@page import="bean.jdbc" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
int id=Integer.parseInt(request.getParameter("id"));
session.setAttribute("id", id);
String classid=(String)session.getAttribute("classid");
Connection conn=jdbc.getConnection();
student s=new student();
Dao d=new Dao();
s=d.select1(id, classid);
%>
 <form action="web8-2.jsp">
 <br> <br> <br> <br> <br> <br>
<div align="center">
请输入修改的名字:<input name="name1" value=<%=s.getName() %>><br> <br>
请输入修改的学号:<input name="id1"value=<%=id %>><br> <br>
请输入修改的性别:<input name="sex1"value=<%=s.getSex() %>><br> <br>
<input type="submit" value="修改">


</div>
</form> 
</body>

</html>

web8-2.jsp

<%@page import="bean.Dao"%>
<%@page import="bean.student"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
int id=(Integer)session.getAttribute("id");
int id1=Integer.parseInt(request.getParameter("id1"));
String classid=(String)session.getAttribute("classid");
String name=request.getParameter("name1");
String sex=request.getParameter("sex1");
student s=new student();
s.setId(id1);
s.setName(name);
s.setSex(sex);
Dao d=new Dao();
d.update(id, s,classid);
out.print("修改成功");
%>
</body>

</html>

web8-3.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<br><br><br><br><br><br><br>
<form action="servelet3" method="post">
<div align="center">
姓名:<input name="name"><br><br>
学号:<input name="id"><br><br>
性别:<input name="sex"><br><br>
<input type="submit"value="提交"> 
</div>
</form>
</body>
</html>