addinfo.java
public class addinfo extends HttpServlet { private String url="jdbc:mysql://localhost:3306/student?useSSL=true"; private String useName="root"; private String password="2277092"; private Connection conn=null; private PreparedStatement pstmt=null; private Statement stmt=null; private ResultSet rs=null; private String sql=null; private static final long serialVersionUID = 1L; public addinfo() { super(); } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } //建立数据库的连接 public void setConn(){ try{ Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(url,useName,password); } catch(Exception e){ e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { setConn(); request.setCharacterEncoding("gb2312"); response.setContentType("text/html;charset=gb2312"); //int no=Integer.parseInt(request.getParameter("no")); String no=request.getParameter("no"); String name=request.getParameter("name"); String phone=request.getParameter("phone"); String sex=request.getParameter("sex"); String address=request.getParameter("address"); //System.out.print(name+phone+sex+address); if(no.equals("")||name.equals("")||phone.equals("")||sex.equals("")||address.equals("")){ request.setAttribute("tips", "信息不能为空"); RequestDispatcher dispatcher=request.getRequestDispatcher("/splitpage2/add.jsp"); dispatcher.forward(request, response); } try { //判断学号是否已经存在 stmt=conn.createStatement(); rs=stmt.executeQuery("select * from info;"); while(rs.next()){ int num=rs.getInt(1); if(no.equals(num)){ //System.out.print("该学号已经存在"); request.setAttribute("tips", "该学号已经存在"); RequestDispatcher dispatcher=request.getRequestDispatcher("/splitpage2/add.jsp"); dispatcher.forward(request, response); } } sql="insert into info values(?,?,?,?,?)"; pstmt=conn.prepareStatement(sql); pstmt.setString(1, no); pstmt.setString(2, name); pstmt.setString(3, phone); pstmt.setString(4, sex); pstmt.setString(5, address); pstmt.executeUpdate(); rs.close(); stmt.close(); pstmt.close(); if(conn!=null){ conn.close(); //System.out.print("数据库关闭成功"); } //跳转回首页 RequestDispatcher dispatcher=request.getRequestDispatcher("/splitpage2/list.jsp"); dispatcher.forward(request, response); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.print("出错le"); } } public void init() throws ServletException { // Put your code here } }
deleteinfo.java
public class deleteinfo extends HttpServlet { private static final long serialVersionUID = 1L; private String url="jdbc:mysql://localhost:3306/student?useSSL=true"; private String useName="root"; private String password="2277092"; private String sql=""; private Connection conn=null; private Statement stmt=null,stmt2=null; private ResultSet rs=null; public deleteinfo() { super(); } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } //连接数据库 private void setConn(){ try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(url,useName,password); //System.out.print("数据库连接成功，加载驱动类成功"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { setConn(); request.setCharacterEncoding("gb2312"); response.setContentType("text/html;charset=gb2312"); String no=request.getParameter("no"); sql="select * from info;"; try { stmt=conn.createStatement(); stmt2=conn.createStatement(); rs=stmt.executeQuery(sql); //执行完后rs会关闭，所以要用stmt2，即使也能运行，但会抛出异常 while(rs.next()){ String num=rs.getString(1); if(no.equals(num)){ stmt2.execute("delete from info where no="+no+";"); RequestDispatcher dispatcher=request.getRequestDispatcher("/splitpage2/list.jsp"); dispatcher.forward(request, response); } } rs.close(); stmt.close(); stmt2.close(); } catch (SQLException e) { e.printStackTrace(); } try{ conn.close(); //System.out.print("成功关闭数据库"); } catch(SQLException e){ e.printStackTrace(); } } public void init() throws ServletException { // Put your code here } }
downfile.java
public class downfile extends HttpServlet { private static final long serialVersionUID = 1L; public downfile() { super(); } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { super.service(request, response); String path="E:\Tomcat\webapps\MyWeb\myfile\"; //文件读取路径 response.reset(); //清除缓冲区中的任何数据存在的状态码和标题 try { String str = request.getParameter("name"); //第一个参数为要解码的字节字符,第二个参数为解码方法 //getBytes()里面的参数为str原来的编码方式 //str = new String(str.getBytes("UTF-8"), "UTF-8"); //path = path.substring(0, path.lastIndexOf("\")); //path = path + "\myfile\"; //第一个参数为路径，第二个参数文件名 File fileLoad = new File(path, str); response.reset(); //输出流 OutputStream o = response.getOutputStream(); BufferedOutputStream bos = new BufferedOutputStream(o); //增强写入文件的能力 //输出文件用的字节数组，每次发送500个字节到输出流 //在内存开辟内存空间，最大一次读取500字节 byte b[] = new byte[500]; //客户端使用保存文件的对话框 response.setHeader( "Content-disposition", //指定文件的类型是文件的扩展名 "attachment;filename=" //指定文件的名字 + new String(str.getBytes("UTF-8"), "UTF-8")); //通知客户文件的MIMIE类型 response.setContentType("application/x-tar"); long fileLength = fileLoad.length(); String length = String.valueOf(fileLength); response.setHeader("Content_length", length); //文件字节流读取文件 FileInputStream in = new FileInputStream(fileLoad); int n = 0; while ((n = in.read(b)) != -1) { //in.read(b),返回读到的字节数，没有时返回-1 //write(data,offset,length) bos.write(b, 0, n); //System.out.print(n); } in.close(); bos.close(); } catch (Exception e) { System.out.print(e); } } public void init() throws ServletException { // Put your code here } }
split.java
public class split { private Connection conn=null; private Statement stmt=null; private ResultSet rs=null; private ResultSetMetaData rsmd=null; private String url="jdbc:mysql://localhost:3306/student?useSSL=true"; private String useName="root"; private String password="2277092"; private String sqlStr; //SQL查询语句 private int rowCount=0; //总记录数目 private int pageCount=0; //所分的逻辑页数 private int pageSize=0; //每页显示的记录数 public void setCon(){ try{ Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(url,useName,password); //System.out.print("加载驱动类和数据库连接成功"); } catch(Exception e){ e.printStackTrace(); } } //初始化,第三个参数表示目前所显示的是第几页 public void initialize(String sqlStr,int pageSize,int ipage){ this.sqlStr=sqlStr; this.pageSize=pageSize; //检索开始位置=每页显示的记录数*(所在的页数-1) //实际是从第irows+1条记录开始检索 int irows=pageSize*(ipage-1); try{ //第一次执行SQL语句，获取所有数据库表所有信息 stmt=this.conn.createStatement(); rs=stmt.executeQuery(this.sqlStr); //执行SQL语句，获取MySQL里面的数据 if(rs!=null){ rs.last(); //将游标指向最后一行 this.rowCount=rs.getRow();//获取当前记录所在的行数，即记录总数 //rs.first(); //页数总数=(总记录数目-1)/每页显示的记录数+1 this.pageCount=(this.rowCount-1)/this.pageSize+1; } //第二次执行SQL语句，对数据库信息进行检索 this.sqlStr=sqlStr+" limit "+irows+","+pageSize+";"; //检索pageSize条数据 stmt=this.conn.createStatement(); rs=stmt.executeQuery(this.sqlStr); this.rsmd=rs.getMetaData(); //获取数据库中ColumnName的信息 //System.out.print(rsmd); } catch(SQLException e){ System.out.print(e.toString()); } } //将显示的结果保存到集合类中 public Vector<Object[]> getPage(){ Vector<Object[]> vData=new Vector<Object[]>(); try{ if(rs!=null){ while(rs.next()){ String[] sData=new String[5];//5表示一行中属性种类的个数 for(int j=0;j<rsmd.getColumnCount();j++){//获取一行中有几种属性的数目 sData[j]=rs.getString(j+1); } //System.out.print(rsmd.getColumnCount()); vData.addElement(sData); } } rs.close(); stmt.close(); } catch(SQLException e){ System.out.print(e.toString()); } return vData; } //获取页面总数 public int getPageCount(){ return this.pageCount; } //获取数据表中记录总数 public int getRowCount(){ return this.rowCount; } //关闭数据库连接 public void closeConn(){ if(conn!=null){ try { conn.close(); //System.out.print("成功关闭数据库连接"); } catch (SQLException e) { e.printStackTrace(); } } } }
updateinfo.java
public class updateinfo extends HttpServlet { private static final long serialVersionUID = 1L; private String url="jdbc:mysql://localhost:3306/student?useSSL=true"; private String useName="root"; private String password="2277092"; private String sql=""; private Connection conn=null; private Statement stmt=null; private ResultSet rs=null; public updateinfo() { super(); } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } //连接数据库 private void setConn(){ try{ Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(url,useName,password); } catch(ClassNotFoundException e){ e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { setConn(); request.setCharacterEncoding("gb2312"); response.setContentType("text/html;charset=gb2312"); String id=request.getParameter("id"); //System.out.print(id); try { sql="select * from info;"; stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()){ String no=rs.getString(1); String name=rs.getString(2); String phone=rs.getString(3); String sex=rs.getString(4); String address=rs.getString(5); try{ if(id.equals(no)){ request.setAttribute("no", no); request.setAttribute("name", name); request.setAttribute("phone", phone); request.setAttribute("sex", sex); request.setAttribute("address", address); RequestDispatcher dispatcher=request.getRequestDispatcher("/splitpage2/update.jsp"); dispatcher.forward(request, response); } } catch(Exception e){ e.printStackTrace(); } } rs.close(); stmt.close(); } catch (SQLException e) { e.printStackTrace(); } finally{ try{ if(conn!=null){ conn.close(); //System.out.print("关闭数据库成功"); } } catch(SQLException e){ e.printStackTrace(); } } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { setConn(); request.setCharacterEncoding("gb2312"); response.setContentType("text/html;charset=gb2312"); String no=request.getParameter("no"); String name=request.getParameter("name"); String phone=request.getParameter("phone"); String sex=request.getParameter("sex"); String address=request.getParameter("address"); //System.out.print(sex); try{ sql="update info set name='"+name+"',phone='"+phone+"',sex='"+sex+"',address='"+address+"' where no="+no+";"; stmt=conn.createStatement(); stmt.executeUpdate(sql); stmt.close(); conn.close(); RequestDispatcher dispatcher=request.getRequestDispatcher("/splitpage2/list.jsp"); dispatcher.forward(request, response); } catch(SQLException e){ e.printStackTrace(); } } public void init() throws ServletException { // Put your code here } }
upfile.java
public class upfile extends HttpServlet { private static final long serialVersionUID = 1L; public upfile() { super(); } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("gb2312"); response.setContentType("text/html;charset=gb2312"); SmartUpload up=new SmartUpload(); try{ /* 第一个参数是传递一个Servlet，在servlet中传递this就可以了； 第二个和第三个参数是request与response不多说明了； 第四个参数是发生错误后的url路径地址，如果没有可以键入null； 第五个参数是是否需要session，这里可以写入true； 第六个参数是缓存大小，我们用了8*1024； 第七个蚕食是是否需要刷新，键入ture；*/ PageContext context = JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true, 8*1024, true); up.initialize(context); up.setTotalMaxFileSize(5*1024*1024); //上传的总文件大小不能超过这个 up.upload(); //获取文件名 //String fn=up.getFiles().getFile(0).getFieldName(); String path="E:\Tomcat\webapps\MyWeb\myfile"; //java.io.File d=new java.io.File(path); File d=new File(path); if(!d.exists()){ d.mkdirs(); } up.save(path); //System.out.print(fn); //System.out.print("文件上传成功啦！！！"); RequestDispatcher dispatcher=request.getRequestDispatcher("/splitpage2/list.jsp"); dispatcher.forward(request, response); } catch(Exception e){ e.printStackTrace(); } } public void init() throws ServletException { // Put your code here } }
add.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <%request.setCharacterEncoding("gb2312"); %> <%response.setContentType("text/html;charset=gb2312"); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>添加/删除信息</title> <style type="text/css"> .bg{ background:url(image/3.jpeg); } </style> </head> <body class="bg"> <center> <h1>添加与删除信息</h1><hr><br> <form action="servlet/addinfo" method="post"> <table border="1" cellspacing="0" cellpadding="3"> <tr align="right"> <td>学号:</td> <td><input type="text" name="no" size="30" ></td> </tr> <tr align="right"> <td>姓名:</td> <td><input type="text" name="name" size="30"></td> </tr> <tr align="right"> <td>联系方式:</td> <td><input type="text" name="phone" size="30"></td> </tr> <tr align="right"> <td>性别:</td> <td align="left"> <input type="radio" name="sex" value="男">男 <input type="radio" name="sex" value="女">女 </td> </tr> <tr align="right"> <td>地址:</td> <td><input type="text" name="address" size="30"></td> </tr> <tr> <td></td> <td> <input type="submit" value="提交"> <input type="reset" value="重置"> </td> </tr> </table> </form> 提示：<input type="text" name="tips" value="<%=request.getAttribute("tips") %>" readonly> <a href="splitpage2/list.jsp">返回主页</a> </center> <br><br><br> <center> <form action="servlet/deleteinfo" method="post"> 请输入要删除的学号: <input type="text" name="no"> <input type="submit" value="提交"> <input type="reset" value="重置"> </form> </center> </body> </html>
downfile.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <%@ page import="java.io.*" %> <%request.setCharacterEncoding("gb2312"); %> <%response.setContentType("text/html;charset=gb2312"); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>文件下载站</title> <style type="text/css"> .bg{ background:url(image/3.jpeg); } .textS{ font-size:25px; } a:hover{ color:red; } </style> </head> <body class="bg"> <center> <font color="#00008b" size="6" >文件下载站</font><br><br> <table> <% path="E:\Tomcat\webapps\MyWeb"; File file=new File(path,"\myfile"); String str[]=file.list(); for(int i=0;i<str.length;i++){ String s=str[i]; out.print("<tr class='textS'><td>"+s+"</td><td><a href='servlet/downfile?name="+s+"'>下载</a></td></tr>"); } %> </table> <br><br> <form action="servlet/upfile" method="post" enctype="multipart/form-data"> <input type="file" name="file" size="20"/><br> <input type="submit" value="上传"/> </form> <br> <a href="splitpage2/list.jsp">返回主页</a> </center> </body> </html>
list.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <%@page import="java.sql.*" %> <%@page import="java.io.*" %> <%@page import="com.*" %> <jsp:useBean id="pages" scope="page" class="com.split"/> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>蓝霸学院名册</title> <style type="text/css"> .tablebg{ width:440px; height:247px; background-color:rgba(255,255,255,0.3); } .bg{ background:url(image/3.jpeg); } .left-message{ float:left; margin-top:10px; } .left-message-margin{ margin-top:10px; margin-left:15px; } .left-message-bg{ width:120px; height:260px; padding-left:10px; padding-top:10px; background-color:rgba(224,224,224,0.3) ; } a{ text-decoration:none; } a:hover{ text-decoration:underline; color:red; } </style> </head> <body class="bg"> <br> <!-- 标题 --> <center><div align="center"><h1>学员信息一览</h1></div><br></center> <!-- 友情提示 --> <div class="left-message left-message-bg"> <font size="5px">友情提示:</font><br> <div class="left-message-margin"><a href="splitpage2/list.jsp">查看信息</a><br></div> <div class="left-message-margin"><a href="splitpage2/add.jsp">添加信息</a><br></div> <div class="left-message-margin"><a href="splitpage2/add.jsp">删除信息</a><br></div> <div class="left-message-margin"><a href="splitpage2/update.jsp">修改信息</a></div> <div class="left-message-margin"><a href="splitpage2/downfile.jsp">资料上传</a></div> <div class="left-message-margin"><a href="splitpage2/downfile.jsp">资料下载</a></div> <div class="left-message-margin"><a href="">联系客服</a></div> <div class="left-message-margin"><a href="">关于我们</a></div> </div> <%! String sqlStr=""; int pageSize=5; //每页显示的记录数 int showPage=1; //当前页 %> <% //连接数据库 pages.setCon(); //这里后面不能加";"号,因为后面还有limit 0,2; sqlStr="select * from info order by no"; String strPage=null; strPage=request.getParameter("showPage");//获取目前显示的页数 if(strPage==null){ showPage=1; } else{ try{ showPage=Integer.parseInt(strPage); } catch(NumberFormatException e){ System.out.print(e.toString()); showPage=1; } if(showPage<1){ showPage=1; } } pages.initialize(sqlStr, pageSize, showPage); Vector<Object[]> vData=pages.getPage(); %> <div align="center" ><br> <div class="tablebg"> <!-- 表格区 --> <table border="1" cellspacing="1" cellpadding="10" > <tr align="center"> <td>学号</td> <td>姓名</td> <td>联系方式</td> <td>性别</td> <td>地址</td> </tr> <% for(int i=0;i<vData.size();i++){ String[] sData=(String[])vData.get(i); //显示数据 %> <tr align="center"> <td width="50"><%=sData[0] %></td> <td width="80"><%=sData[1] %></td> <td width="150"><%=sData[2] %></td> <td width="50"><%=sData[3] %></td> <td width="100"><%=sData[4] %></td> </tr> <% } %> </table> </div> <br> <br> <br> <!-- 分页区 --> <form action="splitpage2/list.jsp" method="get" target="_self"> 共<%=pages.getRowCount() %>条 <%=pageSize %>条/页 第<%=showPage %>页/共<%=pages.getPageCount() %>页 <a href="splitpage2/list.jsp?showPage=1" target="_self">[首页]</a> <!-- 上一页 --> <% if(showPage>1){ %> <a href="splitpage2/list.jsp?showPage=<%=showPage-1%>" target="_self">[上一页]</a> <% } else{ %> [上一页] <% } %> <!-- 下一页 --> <% if(showPage<pages.getPageCount()){ %> <a href="splitpage2/list.jsp?showPage=<%=showPage+1 %>" target="_self">[下一页]</a> <% } else{ %> [下一页] <% } %> <a href="splitpage2/list.jsp?showPage=<%=pages.getPageCount()%>">[尾页]</a> <!-- 转到第n页 --> 转到 <select name="showPage"> <% for(int i=1;i<=pages.getPageCount();i++){ %> <option value="<%=i%>" <% if(showPage==i) out.print("selected"); %>> <%=i %> </option> <% } %> </select> 页 <input type="submit" value="跳转"> </form> </div> <% pages.closeConn(); %> </body> </html>
update.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <%@page import="com.*" %> <%request.setCharacterEncoding("gb2312"); %> <%response.setContentType("text/html;charset=gb2312"); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>修改信息</title> <style type="text/css"> .bg{ background:url(image/3.jpeg); } </style> </head> <body class="bg"> <center> <h1>修改学员信息</h1><hr><br> <form action="servlet/updateinfo" method="get"> 输入要修改的学号: <input type="text" name="id"> <input type="submit" value="查询"> <input type="reset" value="重置"> </form> <form action="servlet/updateinfo" method="post"> <table border="1" cellspacing="0" cellpadding="3"> <tr align="right"> <td>学号:</td> <td><input type="text" name="no" size="30" value="<%=request.getAttribute("no")%>"></td> </tr> <tr align="right"> <td>姓名:</td> <td><input type="text" name="name" size="30" value="<%=request.getAttribute("name")%>"></td> </tr> <tr align="right"> <td>联系方式:</td> <td><input type="text" name="phone" size="30" value="<%=request.getAttribute("phone")%>"></td> </tr> <tr align="right"> <td>性别:</td> <td><input type="text" name="sex" size="30" value="<%=request.getAttribute("sex")%>"></td> </tr> <tr align="right"> <td>地址:</td> <td><input type="text" name="address" size="30" value="<%=request.getAttribute("address")%>"></td> </tr> <tr> <td></td> <td align="center"> <input type="submit" value="提交"> </td> </tr> </table> </form> <a href="splitpage2/list.jsp">返回主页</a> </center> </body> </html>