2021-03-24——Servlet+JDBC

最新推荐文章于 2023-12-29 17:11:08 发布
最新推荐文章于 2023-12-29 17:11:08 发布
阅读量140 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_53371536/article/details/115175654
版权

Servlet+JDBC

  1. 创建数据库表
create  table t_student(

stu_id  int primary key auto_increment,

stu_name varchar(20),

stu_pass varchar(20),

stu_age int,

stu_address varchar(30)

);
  1. 创建javaweb项目StudentManger,[修改Content Root为student],修改工程访问名称
  2. 导入第三方依赖【druid-1.1.10.jar  mysql-connector-java-5.1.38-bin.jar】
  3. 在src下创建数据库连接配置文件【xxxxxxxx.properties】

driverClassName=com.mysql.jdbc.Driver

url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8

username=root

password=123456

initialSize=100

maxActive=300

maxWait=60000

  1. 创建javabean
package com.wangxing.student.bean;

/**

 * 保存学生信息的javabean

 * @author Administrator

 *

 */

public class StudentBean {

         private int stuid;

         private String  stuname;

         private String stupass;

         private int stuage;

         private String stuaddress;

         public int getStuid() {

                  return stuid;

         }

         public void setStuid(int stuid) {

                  this.stuid = stuid;

         }

         public String getStuname() {

                  return stuname;

         }

         public void setStuname(String stuname) {

                  this.stuname = stuname;

         }

         public String getStupass() {

                  return stupass;

         }

         public void setStupass(String stupass) {

                  this.stupass = stupass;

         }

         public int getStuage() {

                  return stuage;

         }

         public void setStuage(int stuage) {

                  this.stuage = stuage;

         }

         public String getStuaddress() {

                  return stuaddress;

         }

         public void setStuaddress(String stuaddress) {

                  this.stuaddress = stuaddress;

         }

}
  1. 创建数据访问接口以及实现类
package com.wangxing.student.dao.impl;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import com.wangxing.student.bean.StudentBean;

import com.wangxing.student.dao.StudentDao;

public class StudentDaoImpl implements StudentDao{

         private static StudentDaoImpl studentDao=null;

         // 定义保存druid数据源对象

         private DataSource dataSource = null;

         private StudentDaoImpl() {

                          if(dataSource==null){

                                   try {

                                   Properties pro=new Properties();

                                   InputStream inStream=this.getClass().getResourceAsStream("/mysqldata.properties");

                                   pro.load(inStream);

                                   dataSource=DruidDataSourceFactory.createDataSource(pro);

                                   }catch(Exception e) {

                                            e.printStackTrace();

                                   }

                          }

                  }

         public static StudentDaoImpl getStudentDaoImpl(){

                  if(studentDao==null){

                          studentDao=new StudentDaoImpl();

                  }

                  return studentDao;

         }

         @Override

         public void insertStudent(StudentBean student)throws Exception{

                      Connection conn = dataSource.getConnection();

                          String insert = "insert into t_student values(null,?,?,?,?);";

                          PreparedStatement statement = conn.prepareStatement(insert);

                          statement.setString(1, student.getStuname());

                          statement.setString(2, student.getStupass());

                          statement.setInt(3, student.getStuage());

                          statement.setString(4, student.getStuaddress());

                          int temp = statement.executeUpdate();

                          statement.close();

                          conn.close();

         }

         @Override

         public void updateStudent(StudentBean student)throws Exception{

                  Connection conn = dataSource.getConnection();

                  String update = "update t_student set stu_name=?,stu_pass=?,stu_age=?,stu_address=? where stu_id=?;";

                  PreparedStatement statement = conn.prepareStatement(update);

                  statement.setString(1, student.getStuname());

                  statement.setString(2, student.getStupass());

                  statement.setInt(3, student.getStuage());

                  statement.setString(4, student.getStuaddress());

                  statement.setInt(5, student.getStuid());

                  int temp = statement.executeUpdate();

                  statement.close();

                  conn.close();

         }

         @Override

         public void deleteStudent(int stuid)throws Exception {

                  Connection conn = dataSource.getConnection();

                  String delete = "delete from t_student where stu_id=?;";

                  PreparedStatement statement = conn.prepareStatement(delete);

                  statement.setInt(1, stuid);

                  int temp = statement.executeUpdate();

                  statement.close();

                  conn.close();

         }



         @Override

         public StudentBean selectStudentById(int stuid)throws Exception {

                  StudentBean student=null;

                  Connection conn = dataSource.getConnection();

                  String select = "select * from t_student where stu_id=?;";

                  PreparedStatement statement = conn.prepareStatement(select);

             statement.setInt(1, stuid);

                  ResultSet resultSet = statement.executeQuery();

                  if (resultSet.next()) {

                                   int id = resultSet.getInt("stu_id");

                                   String name = resultSet.getString("stu_name");

                                   String pass = resultSet.getString("stu_pass");

                                   int age = resultSet.getInt("stu_age");

                                   String address = resultSet.getString("stu_address");

                                   student= new StudentBean();

                                   student.setStuid(id);

                                   student.setStuname(name);

                                   student.setStupass(pass);

                                   student.setStuage(age);

                                   student.setStuaddress(address);

                          }

                  resultSet.close();

                  statement.close();

                  conn.close();

                  return student;

         }



         @Override

         public List<StudentBean> selectStudent()throws Exception {

                  List<StudentBean> studenlist=new ArrayList<StudentBean>();

                  Connection conn = dataSource.getConnection();

                  String select = "select * from t_student;";

                  PreparedStatement statement = conn.prepareStatement(select);

                  ResultSet resultSet = statement.executeQuery();

                  while(resultSet.next()) {

                                   int id = resultSet.getInt("stu_id");

                                   String name = resultSet.getString("stu_name");

                                   String pass = resultSet.getString("stu_pass");

                                   int age = resultSet.getInt("stu_age");

                                   String address = resultSet.getString("stu_address");

                                   StudentBean student= new StudentBean();

                                   student.setStuid(id);

                                   student.setStuname(name);

                                   student.setStupass(pass);

                                   student.setStuage(age);

                                   student.setStuaddress(address);

                                   studenlist.add(student);

                          }

                  resultSet.close();

                  statement.close();

                  conn.close();

                  return studenlist;

         }

}
  1. 创建业务访问接口以及实现类
package com.wangxing.student.service.impl;

import java.util.List;

import com.wangxing.student.bean.StudentBean;

import com.wangxing.student.dao.StudentDao;

import com.wangxing.student.service.StudentService;

public class StudentServiceImpl implements StudentService{

         private StudentDao  stuentDao=null;

         public StudentServiceImpl(StudentDao  stuentDao){

                  this.stuentDao=stuentDao;

         }

         @Override

         public void insertStudent(StudentBean student) throws Exception {

                  stuentDao.insertStudent(student);

         }

         @Override

         public void updateStudent(StudentBean student) throws Exception {

                  stuentDao.updateStudent(student);

         }

         @Override

         public void deleteStudent(int stuid) throws Exception {

                  stuentDao.deleteStudent(stuid);

         }

         @Override

         public StudentBean selectStudentById(int stuid) throws Exception {

                  return stuentDao.selectStudentById(stuid);

         }

         @Override

         public List<StudentBean> selectStudent() throws Exception {

                  return stuentDao.selectStudent();

         }

}
  1. 创建具体业务处理的Servlet
package com.wangxing.student.servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.wangxing.student.bean.StudentBean;

import com.wangxing.student.dao.impl.StudentDaoImpl;

import com.wangxing.student.service.StudentService;

import com.wangxing.student.service.impl.StudentServiceImpl;

/**

 * 处理添加操作的servlet

 * @author Administrator

 *

 */

public class StudentInsertServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  String stuname=req.getParameter("username");

                  String stupass=req.getParameter("password");

                  String stuage=req.getParameter("stuage");

                  String stuaddress=req.getParameter("stuaddress");

                  StudentBean  student=new StudentBean();

                  student.setStuname(stuname);

                  student.setStupass(stupass);

                  student.setStuage(Integer.parseInt(stuage));

                  student.setStuaddress(stuaddress);

                  StudentService studentService=new StudentServiceImpl(StudentDaoImpl.getStudentDaoImpl());

                  try {

                          studentService.insertStudent(student);

                           resp.sendRedirect("studentselectlist");

                  } catch (Exception e) {

                          e.printStackTrace();

                          resp.sendRedirect("studentselectlist");

                  }

         }

}



package com.wangxing.student.servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.wangxing.student.bean.StudentBean;

import com.wangxing.student.dao.impl.StudentDaoImpl;

import com.wangxing.student.service.StudentService;

import com.wangxing.student.service.impl.StudentServiceImpl;

/**

 * 处理修改操作的servlet

 * @author Administrator

 *

 */

public class StudentUpdateServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  String stuid=req.getParameter("stuid");

                  String stuname=req.getParameter("username");

                  String stupass=req.getParameter("password");

                  String stuage=req.getParameter("stuage");

                  String stuaddress=req.getParameter("stuaddress");

                  StudentBean  student=new StudentBean();

                  student.setStuid(Integer.parseInt(stuid));

                  student.setStuname(stuname);

                  student.setStupass(stupass);

                  student.setStuage(Integer.parseInt(stuage));

                  student.setStuaddress(stuaddress);

                  StudentService studentService=new StudentServiceImpl(StudentDaoImpl.getStudentDaoImpl());

                  try {

                          studentService.updateStudent(student);

                          resp.sendRedirect("studentselectlist");

                  } catch (Exception e) {

                          e.printStackTrace();

                          resp.sendRedirect("studentselectlist");

                  }

         }

}



package com.wangxing.student.servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.wangxing.student.bean.StudentBean;

import com.wangxing.student.dao.impl.StudentDaoImpl;

import com.wangxing.student.service.StudentService;

import com.wangxing.student.service.impl.StudentServiceImpl;

/**

 * 处理删除操作的servlet

 * @author Administrator

 *

 */

public class StudentDeleteServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  String stuid=req.getParameter("stuid");

                  StudentService studentService=new StudentServiceImpl(StudentDaoImpl.getStudentDaoImpl());

                  try {

                          studentService.deleteStudent(Integer.parseInt(stuid));

                          resp.sendRedirect("studentselectlist");

                  } catch (Exception e) {

                          e.printStackTrace();

                          resp.sendRedirect("studentselectlist");

                  }

         }

}



package com.wangxing.student.servlet;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.wangxing.student.bean.StudentBean;

import com.wangxing.student.dao.impl.StudentDaoImpl;

import com.wangxing.student.service.StudentService;

import com.wangxing.student.service.impl.StudentServiceImpl;

/**

 * 处理根据id查询操作的servlet

 * @author Administrator

 *

 */

public class StudentSelectStudentServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  String stuid=req.getParameter("stuid");

                  StudentService studentService=new StudentServiceImpl(StudentDaoImpl.getStudentDaoImpl());

                  try {

                          StudentBean student=studentService.selectStudentById(Integer.parseInt(stuid));

                          req.setAttribute("student", student);

                          req.getRequestDispatcher("update").forward(req, resp);

                  } catch (Exception e) {

                          e.printStackTrace();

                  }

         }

}



package com.wangxing.student.servlet;

import java.io.IOException;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.wangxing.student.bean.StudentBean;

import com.wangxing.student.dao.impl.StudentDaoImpl;

import com.wangxing.student.service.StudentService;

import com.wangxing.student.service.impl.StudentServiceImpl;

/**

 * 处理查询所有操作的servlet

 * @author Administrator

 *

 */

public class StudentSelectListServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  StudentService studentService=new StudentServiceImpl(StudentDaoImpl.getStudentDaoImpl());

                  try {

                          List<StudentBean> studentlist=studentService.selectStudent();

                          req.setAttribute("studentlist", studentlist);

                          req.getRequestDispatcher("/main").forward(req, resp);

                  } catch (Exception e) {

                          e.printStackTrace();

                  }

         }

}
  1. 创建页面Servlet
package com.wangxing.student.ui;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.wangxing.student.bean.StudentBean;

/**

 * 主页面

 * @author Administrator

 *

 */

public class MainServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  PrintWriter out=resp.getWriter();

                  out.println("<!DOCTYPE html>");

                  out.println("<html>");

                  out.println("<head>");

                  out.println("<meta charset=\"UTF-8\">");

                  out.println("<title>学生信息</title>");

                  out.println("</head>");

                  out.println("<body>");

                  out.println("<center>");

                  out.println("<table border=\"1px\" width=\"500px\">");

                  out.println("<tr align=\"left\">");

                  out.println("<td colspan=\"7\"><h1><a href=\"add\">新建</a></h1></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td colspan=\"7\"><h1>学生信息</h1></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>学生编号</td>");

                  out.println("<td>学生姓名</td>");

                  out.println("<td>登陆密码</td>");

                  out.println("<td>学生年龄</td>");

                  out.println("<td>学生地址</td>");

                  out.println("<td colspan=\"2\">相关操作</td>");

                  out.println("</tr>");

                  List<StudentBean> studentlist=(List<StudentBean>)req.getAttribute("studentlist");

                  if(studentlist.size()==0){

                          out.println("<tr align=\"center\">");

                          out.println("<td colspan=\"7\">没有记录</td>");

                          out.println("</tr>");

                  }else{

                          for(StudentBean  student:studentlist){

                                   out.println("<tr align=\"center\">");

                                   out.println("<td>"+student.getStuid()+"</td>");

                                   out.println("<td>"+student.getStuname()+"</td>");

                                   out.println("<td>"+student.getStupass()+"</td>");

                                   out.println("<td>"+student.getStuage()+"</td>");

                                   out.println("<td>"+student.getStuaddress()+"</td>");

                                   out.println("<td><a href=\"studentselectstudent?stuid="+student.getStuid()+"\">修改</a></td>");

                                   out.println("<td><a href=\"studentdelete?stuid="+student.getStuid()+"\">删除</a></td>");

                                   out.println("</tr>");

                          }

                  }

                  out.println("</table>");

                  out.println("</center>");

                  out.println("</body>");

                  out.println("</html>");

                  out.close();

         }

}



package com.wangxing.student.ui;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

/**

 * 添加页面

 * @author Administrator

 *

 */

public class AddServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  PrintWriter out=resp.getWriter();

                  out.println("<!DOCTYPE html>");

                  out.println("<html>");

                  out.println("<head>");

                  out.println("<meta charset=\"UTF-8\">");

                  out.println("<title>新建用户信息</title>");

                  out.println("</head>");

                  out.println("<body>");

                  out.println("<center>");

                  out.println("<form action=\"studentinsert\" method=\"post\">");

                  out.println("<table border=\"1px\">");

                  out.println("<tr align=\"center\">");

                  out.println("<td colspan=\"2\"><h1>新建用户信息</h1></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>学生姓名:</td>");

                  out.println("<td><input type=\"text\" name=\"username\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>登陆密码:</td>");

                  out.println("<td><input type=\"password\" name=\"password\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>学生年龄:</td>");

                  out.println("<td><input type=\"text\" name=\"stuage\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>学生地址:</td>");

                  out.println("<td><input type=\"text\" name=\"stuaddress\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td colspan=\"2\"><input type=\"submit\" value=\"新建\"/></td>");

                  out.println("</tr>");

                  out.println("</table>");

                  out.println("</form>");

                  out.println("</center>");

                  out.println("</body>");

                  out.println("</html>");

                  out.close();

         }

}



package com.wangxing.student.ui;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.wangxing.student.bean.StudentBean;

/**

 * 修改页面

 * @author Administrator

 *

 */

public class UpdateServlet extends HttpServlet{

         @Override

        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  doPost(req, resp);

         }

         @Override

         protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

                  StudentBean student=(StudentBean)req.getAttribute("student");

                  PrintWriter out=resp.getWriter();

                  out.println("<!DOCTYPE html>");

                  out.println("<html>");

                  out.println("<head>");

                  out.println("<meta charset=\"UTF-8\">");

                  out.println("<title>修改用户信息</title>");

                  out.println("</head>");

                  out.println("<body>");

                  out.println("<center>");

                  out.println("<form action=\"studentupdate\" method=\"post\">");

                  out.println("<input type=\"hidden\" name=\"stuid\" value=\""+student.getStuid()+"\"/>");

                  out.println("<table border=\"1px\">");

                  out.println("<tr align=\"center\">");

                  out.println("<td colspan=\"2\"><h1>修改用户信息</h1></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>学生姓名:</td>");

                  out.println("<td><input type=\"text\" name=\"username\" value=\""+student.getStuname()+"\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>登陆密码:</td>");

                  out.println("<td><input type=\"password\" name=\"password\" value=\""+student.getStupass()+"\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>学生年龄:</td>");

                  out.println("<td><input type=\"text\" name=\"stuage\" value=\""+student.getStuage()+"\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td>学生地址:</td>");

                  out.println("<td><input type=\"text\" name=\"stuaddress\" value=\""+student.getStuaddress()+"\"/></td>");

                  out.println("</tr>");

                  out.println("<tr align=\"center\">");

                  out.println("<td colspan=\"2\"><input type=\"submit\" value=\"修改\"/></td>");

                  out.println("</tr>");

                  out.println("</table>");

                  out.println("</form>");

                  out.println("</center>");

                  out.println("</body>");

                  out.println("</html>");

                  out.close();

         }

}
  1. 创建字符过滤器
  2. 配置web.xml
  3. 测试http://127.0.0.1:8080/student/studentselectlist

 

伟1314520
关注
Servlet + JDBC 简单应用 笔记
LizZfi的博客
03-31 1037
req resp sendRedirect
java servlet jdbc_使用Servlet+JDBC 开发java web应用
weixin_39534002的博客
02-13 356
一说到javaweb应用的开发，很多人肯定想到的是用springmvc、Struts2这些热门框架去开发，简单高效，只要配置好框架，剩下的工作就是体力活了。但是很多人用惯了框架，一但开发中遇到问题，就束手无策，究其原理是根本不理解javaweb最基础、最核心的东西。其实那些所谓的框架，其本质是在servlet和jdbc的基础上扩展功能，封装常用的函数、以xml配置的方式提供给开发者...
servlet+jdbc
weixin_43667990的博客
04-08 311
参考：https://how2j.cn/k/servlet/servlet-eclipse/558.html?p=136471 1.JDBC JDBC：Java DataBase Connectivity 可以为多种关系型数据库DBMS 提供统一的访问方式 具体是通过以下类/接口实现： DriverManager ： 管理jdbc驱动 Connection： 连接（通过DriverManage...
java+servlet+JDBC
qq_45744856的博客
06-09 462
JAVA连接数据库实验 1.实验思路 本实验后端采用的是JDBC连接数据库，服务端和客户端的连接采用的是servlet开发工具，主要的结构是采用servlet作为中间层实现信息交互和页面的重定向，后端则是采用JDBC实现页面和MYSQL数据库的交互。 2.代码结构图 3.实验开发工具 Intelij -IU 2018.3.6 旗舰版( 因为后续要使用tomcat插件，社区版没有该功能) ...
动力节点Java项目实战-来访咨询管理系统（servlet+jdbc）
07-24
动力节点的Java项目实战课程——来访咨询管理系统是一个典型的Web应用程序，它通过集成Servlet、JDBC、HTML、CSS、JavaScript、Tomcat服务器以及MySQL数据库来构建一个综合性的信息管理平台。这个系统旨在帮助机构或...
jsp+servlet+jdbc开发的java web学生成绩管理系统
01-15
本系统——"jsp+servlet+jdbc开发的java web学生成绩管理系统"正是这样一款专为教育领域设计的应用，旨在帮助学校更有效地管理和追踪学生的成绩数据。该系统采用经典的Java Web技术栈，包括JSP（JavaServer Pages）...
JDBC连接——mysql+myeclipse+servlet+navicat
m0_57210162的博客
10-23 709
1、软件介绍： myeclipse：java编译器 mysql:数据库 servlet：java浏览器服务 navicat：数据库管理工具 2、步骤 （1）软件安装 （2）mysql连接navicat及建库 （4）在myeclipse中建立javaweb项目并完成服务器的配置 3、javaweb项目连接mysql （1）mysql驱动安装（官网下载：mysql5.7可以使用5.1驱动） （2）mysql包引入 import java...
学校实训JSP项目-网上购物系统(JavaBean+Servlet+jsp).zip
09-04
《基于JavaBean、Servlet与JSP的网上购物系统——学校实训项目详解》 在IT行业中，Web开发是一项至关重要的技能，而Java技术栈是其中的主流之一。本实训项目“学校实训JSP项目-网上购物系统”正是一个典型的应用...
JSP+servlet+JDBC+Mysql 简易商品管理系统
11-06
本项目——“JSP + Servlet + JDBC + MySQL 简易商品管理系统”，就是一个典型的JavaWeb应用实例，旨在帮助初学者了解并掌握这一技术栈的使用。下面，我们将深入探讨这个系统的构成和关键技术。 首先，JSP（Java...
关于Java Web的Servlet+JDBC(封装)+JSP的登录（送给入门的你）
08-24
关于Java Web的Servlet+JDBC(封装)+JSP的登录（送给入门的你）
JDBC+Servlet入门示例
03-01
项目名称为Leaf，Servlet（com.leaf.web.LeafKingLaServlet）简单实现跳转示例，用户名密码访问示例。数据库采用Sqlite3，需要在数据库操作对象（com.leaf.dao.LeafDao）：main方法中，以Java Application执行initDB方法，实现数据库、数据表创建。 在登陆过程中，servlet接收用户名密码，检查数据库中是否存在，登陆成功与否通过alert提示在网页上。 本代码仅为入门示例，代码有不严谨、不工整之处，请见谅。谢谢。
Servlet（1）----------简介及Servlet+JDBC整合
sun_boy的博客
04-16 3741
1、Servlet是JAVAEE规范下的一个子规范，是运行于服务器端的一段JAVA程序，主要用于编写动态JAVAWEB网页。2、servlet技术特点：    1）功能强大：采用java语言编写，可以调用API中的对象及方法，servlet对象对web应用进行了封装，提供servlet对web应用的编程接口，还对Http请求进行相应的处理。    2）可移植：java语言是跨平台的，servlet...
Servlet+JDBC实现交互
羊肉串学爪哇的博客
05-11 147
AddProductServlet 类 package com.qiku.web; import com.qiku.dao.ProductDao; import com.qiku.entity.Product; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.ht.
「Servlet+JDBC」实现用户登录与注册
她的妈妈爱上我的博客
04-20 1349
书城第二阶段：用户登录&用户注册 （1）JDBC （2）Servlet 1-准备工作 （1）书城用户数据库与表创建 （2）编写用户类对象JavaBean （3）编写JdbcUtils对数据库进行交互（使用德鲁伊数据库连接池） （4）编写web层 最终编写好的第二阶段登陆注册文件结构为 dao中定义了基础的操作数据库代码，具体功能有 Insert、update、delete（修改） 查询一个对象（返回一个对象） 查询一个数组对象（数组返回多个对象） 返回某一个特定值对象（返回一个值） poj
servlet+JDBC web动态项目
weixin_41103348的博客
03-14 1549
servlet+JDBC web动态项目
一、servlet+Jdbc案例框架（MVC）
u013446026的博客
08-16 327
servlet+Jdbc案例框架（MVC）
JavaWeb 第三章 Servlet+JDBC实现登录注册
Rouer_jia的博客
12-27 575
JavaWeb 第三章 Servlet+JDBC实现登录注册。
servlet+jdbc实现用户注册功能
最新发布
CAUC_lin的博客
12-29 571
访问注册界面，发送注册请求，tomcat获取注册信息。创建空工程，在工程中创建javaEE模块。配置中设置tomcat的部署。编写register界面。
Java JDBC编程实践教程——从基础到JSP、Servlet应用
书中涵盖Java程序设计基础、SQL基础知识、JDBC接口和类的使用，以及在JSP和Servlet中的实践应用。" 在JDBC（Java Database Connectivity）API数据库编程中，Java程序员可以使用标准的API来与各种类型的数据库进行...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值