做网站建设的公司有哪些方面,jquery 网站模板,做爰片姿势网站,网站的开发方式用IDEA开发工具和MySql实现登录和增删改查的功能。
功能分析#xff1a; 1.登录 2.增加 3.删除 4.修改 5.查询
效果演示
登陆页面 信息显示页面
一 #xff1a;数据库设计
MySql数据库名为 school 登录表名为 login 信息表名为 student 登录表插入合适的数据 信息表…用IDEA开发工具和MySql实现登录和增删改查的功能。
功能分析 1.登录 2.增加 3.删除 4.修改 5.查询
效果演示
登陆页面 信息显示页面
一 数据库设计
MySql数据库名为 school 登录表名为 login 信息表名为 student 登录表插入合适的数据 信息表自己插入
二 代码展示
目录结构 注意我们需要引入相关架包
完整代码
信息类 Student
package com.zsh.bean;public class Student {private int id;private String name;private String sex;private String address;public int getId() {return id;}public void setId(int id) {this.id id;}public String getName() {return name;}public void setName(String name) {this.name name;}public String getSex() {return sex;}public void setSex(String sex) {this.sex sex;}public String getAddress() {return address;}public void setAddress(String address) {this.address address;}public Student() {super();// TODO Auto-generated constructor stub}public Student(int id, String name, String sex, String address) {super();this.id id;this.name name;this.sex sex;this.address address;}
}
增删改查登录 AddServlet
package com.zsh.servlet;import com.zsh.util.DBUtil;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 java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;WebServlet(name AddServlet)
public class AddServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);String name request.getParameter(name);String sex request.getParameter(sex);String address request.getParameter(address);Connection conn DBUtil.getConn();PreparedStatement ps null;String sql insert into student(name,sex,address) values(?,?,?);try {ps conn.prepareStatement(sql);ps.setString(1,name);ps.setString(2,sex);ps.setString(3,address);ps.executeUpdate();} catch (SQLException e) {e.printStackTrace();}finally {DBUtil.closeConn(conn,ps,null);}response.sendRedirect(select);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}
}
DeleteServlet
package com.zsh.servlet;import com.zsh.util.DBUtil;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 java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;WebServlet(name DeleteServlet)
public class DeleteServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);String id request.getParameter(id);Connection conn DBUtil.getConn();PreparedStatement ps null;String sql delete from student where id ?;try {ps conn.prepareStatement(sql);ps.setInt(1,Integer.parseInt(id));ps.executeUpdate();} catch (SQLException e) {e.printStackTrace();}finally {DBUtil.closeConn(conn,ps,null);}response.sendRedirect(select);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}
}
LoginServlet
package com.zsh.servlet;import com.zsh.util.DBUtil;import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;javax.servlet.annotation.WebServlet(name LoginServlet)
public class LoginServlet extends javax.servlet.http.HttpServlet {protected void doPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {request.setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);String name request.getParameter(name);String pwd request.getParameter(pwd);boolean flag false;Connection conn DBUtil.getConn();PreparedStatement ps null;ResultSet rs null;String sql select * from login where name ? and pwd ?;try {ps conn.prepareStatement(sql);ps.setString(1,name);ps.setString(2,pwd);rs ps.executeQuery();if(rs.next()){flag true;}else{flag false;}} catch (SQLException e) {e.printStackTrace();}finally {DBUtil.closeConn(conn,ps,rs);}if(flag){response.sendRedirect(select);}else {response.sendRedirect(index.jsp);}}protected void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {}
}
SelectServlet
package com.zsh.servlet;import com.zsh.bean.Student;
import com.zsh.util.DBUtil;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 java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;WebServlet(name SelectServlet)
public class SelectServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);Connection conn DBUtil.getConn();PreparedStatement ps null;ResultSet rs null;String sql select * from student;ListStudent students new ArrayListStudent();try {ps conn.prepareStatement(sql);rs ps.executeQuery();while (rs.next()){Student student new Student(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4));students.add(student);}} catch (SQLException e) {e.printStackTrace();}finally {DBUtil.closeConn(conn,ps,rs);}HttpSession session request.getSession();session.setAttribute(stu,students);response.sendRedirect(success.jsp);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}
}
UpdateServlet
package com.zsh.servlet;import com.zsh.util.DBUtil;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 java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;WebServlet(name UpdateServlet)
public class UpdateServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);String id request.getParameter(id);String name request.getParameter(name);String sex request.getParameter(sex);String address request.getParameter(address);Connection conn DBUtil.getConn();PreparedStatement ps null;String sql update student set name?,sex?,address? where id ?;try {ps conn.prepareStatement(sql);ps.setString(1,name);ps.setString(2,sex);ps.setString(3,address);ps.setInt(4,Integer.parseInt(id));ps.executeUpdate();} catch (SQLException e) {e.printStackTrace();}finally {DBUtil.closeConn(conn,ps,null);}response.sendRedirect(select);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}
}
链接驱动类 DBUtil
package com.zsh.util;import java.sql.*;public class DBUtil {public static Connection getConn(){Connection conn null;String url jdbc:mysql://localhost:3306/school;String user root;String pwd 111;try {Class.forName(com.mysql.jdbc.Driver);conn DriverManager.getConnection(url, user, pwd);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}return conn;}public static void closeConn(Connection conn, PreparedStatement ps, ResultSet rs){if(conn!null){try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(ps!null){try {ps.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(rs!null){try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}
}
路径文件 web.xml
?xml version1.0 encodingUTF-8?
web-app xmlnshttp://xmlns.jcp.org/xml/ns/javaeexmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsdversion4.0servletservlet-nameLoginServlet/servlet-nameservlet-classcom.zsh.servlet.LoginServlet/servlet-class/servletservletservlet-nameSelectServlet/servlet-nameservlet-classcom.zsh.servlet.SelectServlet/servlet-class/servletservletservlet-nameDeleteServlet/servlet-nameservlet-classcom.zsh.servlet.DeleteServlet/servlet-class/servletservletservlet-nameAddServlet/servlet-nameservlet-classcom.zsh.servlet.AddServlet/servlet-class/servletservletservlet-nameUpdateServlet/servlet-nameservlet-classcom.zsh.servlet.UpdateServlet/servlet-class/servletservlet-mappingservlet-nameLoginServlet/servlet-nameurl-pattern/login/url-pattern/servlet-mappingservlet-mappingservlet-nameSelectServlet/servlet-nameurl-pattern/select/url-pattern/servlet-mappingservlet-mappingservlet-nameDeleteServlet/servlet-nameurl-pattern/del/url-pattern/servlet-mappingservlet-mappingservlet-nameAddServlet/servlet-nameurl-pattern/add/url-pattern/servlet-mappingservlet-mappingservlet-nameUpdateServlet/servlet-nameurl-pattern/update/url-pattern/servlet-mapping/web-appJSP页面 add.jsp
%--Created by IntelliJ IDEA.User: 张叔行Date: 2019/12/3Time: 16:22To change this template use File | Settings | File Templates.
--%
% page contentTypetext/html;charsetUTF-8 languagejava %
html
headtitle添加/title
/head
body
form actionadd methodpost姓名input typetext namenamebr性别input typetext namesexbr住址input typetext nameaddressbrinput typesubmit value添加
/form
/body
/html
index.jsp
%--Created by IntelliJ IDEA.User: 张叔行Date: 2019/12/3Time: 14:28To change this template use File | Settings | File Templates.
--%
% page contentTypetext/html;charsetUTF-8 languagejava %
htmlheadtitle登录/titlescript srcjquery.js/script/headbodyform actionlogin methodpost账号input typetext namename idnamebr密码input typepassword namepwd idpwdbrinput typesubmit value登录/form/bodyscript$(form).submit(function(){var name $(#name).val();var pwd $(#pwd).val();var nameFlag false;var pwdFlag false;if(name || name undefined){nameFlag false;alert(账户不能为空);}else{nameFlag true;}if(pwd || pwd undefined){pwdFlag false;alert(密码不能为空);}else{pwdFlag true;}if(nameFlag false || pwdFlag false){return false;}else{return true;}})/script
/html
success.jsp
% page importjava.util.List %
% page importcom.zsh.bean.Student %
% page importjava.util.ArrayList %%--Created by IntelliJ IDEA.User: 张叔行Date: 2019/12/3Time: 14:40To change this template use File | Settings | File Templates.
--%
% page contentTypetext/html;charsetUTF-8 languagejava %
html
headtitle信息显示/title
/head
body
tabletheadtrtd序号/tdtd姓名/tdtd性别/tdtd住址/tdtd colspan2操作/tdtd/tdtda hrefadd.jsp添加/a/td/tr/theadtbody%ListStudent students (ArrayList)session.getAttribute(stu);for (Student student : students){%trtd%student.getId() %/tdtd%student.getName() %/tdtd%student.getSex() %/tdtd%student.getAddress() %/tdtda hrefdel?id%student.getId() %删除/a/tdtda hrefupdate.jsp?id%student.getId() %更新/a/td/tr%}%/tbody
/table/body
/html
update.jsp
% page importjava.sql.Connection %
% page importcom.zsh.util.DBUtil %
% page importjava.sql.PreparedStatement %
% page importjava.sql.ResultSet %%--Created by IntelliJ IDEA.User: 张叔行Date: 2019/12/3Time: 16:38To change this template use File | Settings | File Templates.
--%
% page contentTypetext/html;charsetUTF-8 languagejava %
html
headtitle更新/title
/head
body%request.setCharacterEncoding(utf-8);response.setCharacterEncoding(utf-8);String id request.getParameter(id);Connection conn DBUtil.getConn();PreparedStatement ps null;ResultSet rs null;String sql select * from student where id ?;try{ps conn.prepareStatement(sql);ps.setInt(1,Integer.parseInt(id));rs ps.executeQuery();while (rs.next()){String name rs.getString(name);String sex rs.getString(sex);String address rs.getString(address);%form actionupdate methodpostID:input typetext nameid value%id % readonlyreadonlybr姓名input typetext namename value%name %br性别input typetext namesex value%sex %br住址input typetext nameaddress value%address %brinput typesubmit value添加/form%}}catch (Exception e){e.printStackTrace();}finally {DBUtil.closeConn(conn,ps,rs);}%/body
/html
希望上述例子能对你有所帮助。
了解更多关注我哟
