點擊下載
本文文檔

當前位置：首頁 - 科技 - 知識百科 - 正文

信息管理系統的增刪改查

來源：懂視網責編：小采時間：2020-11-09 16:28:50

信息管理系統的增刪改查

信息管理系統的增刪改查:代碼在修改更新上有一些缺陷，應該先把相應的要修改的部分查詢顯示顯示出來再進行修改。其實完成增刪改查的原理與登錄注冊是一樣的。 1.首先建student類。 public class Studentmodel {private int id;private String name;privat

推薦度：

點擊下載本文 文檔為doc格式

導讀信息管理系統的增刪改查:代碼在修改更新上有一些缺陷，應該先把相應的要修改的部分查詢顯示顯示出來再進行修改。其實完成增刪改查的原理與登錄注冊是一樣的。 1.首先建student類。 public class Studentmodel {private int id;private String name;privat

代碼在修改更新上有一些缺陷，應該先把相應的要修改的部分查詢顯示顯示出來再進行修改。其實完成增刪改查的原理與登錄注冊是一樣的。 1.首先建student類。 public class Studentmodel {private int id;private String name;private String grade;private Str

代碼在修改更新上有一些缺陷，應該先把相應的要修改的部分查詢顯示顯示出來再進行修改。其實完成增刪改查的原理與登錄注冊是一樣的。

1.首先建student類。

public class Studentmodel {
	
	private int id;
	private String name;
	private String grade;
	private String gender;
	private int age;
	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 getGrade() {
	return grade;
	}
	public void setGrade(String grade) {
	this.grade = grade;
	}
	public String getGender() {
	return gender;
	}
	public void setGender(String gender) {
	this.gender = gender;
	}
	public int getAge() {
	return age;
	}
	public void setAge(int age) {
	this.age = age;
	}
	public String getAddress() {
	return address;
	}
	public void setAddress(String address) {
	this.address = address;
	}

}

2. 1)建接口類。

package cn.edu.hpu.service;

import cn.edu.hpu.model.Studentmodel;

public interface Student {
	public boolean addStu(Studentmodel studentmodel);
 public boolean delStu(int id);
 public boolean updStu(int id,Studentmodel studentmodel);
 public Studentmodel selStu(int id);
}

2)接口類的實現

package cn.edu.hpu.service;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;

import cn.edu.hpu.model.Studentmodel;
import cn.edu.hpu.util.Util;

public class StudentImpl implements Student {

	@Override
	public boolean addStu(Studentmodel studentmodel) {
	
	boolean flag=false;
	String sql="insert into student1(id,name,grade,gender,age,address) value(?,?,?,?,?,?)";
	Connection conn=Util.getConnection();
	PreparedStatement pst;
	try {
	pst = conn.prepareStatement(sql);
	pst.setInt(1, studentmodel.getId());
	pst.setString(2, studentmodel.getName());
	pst.setString(3, studentmodel.getGrade());
	pst.setString(4, studentmodel.getGender());
	pst.setInt(5, studentmodel.getAge());
	pst.setString(6, studentmodel.getAddress());
	pst.executeUpdate();
	flag=true;
	} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	}
	return flag;
	}

	@Override
	public boolean delStu(int id) {
	
	boolean flag=false;
	String sql="delete from student1 where id="+id;
	Connection conn=Util.getConnection();
	try {
	PreparedStatement pst=conn.prepareStatement(sql);
	pst.executeUpdate();
	flag=true;
	} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	}
	return flag;
	}

	@Override
	public boolean updStu(int id, Studentmodel studentmodel) {
	
	boolean flag=false;
	String sql="update student1 set id=?,name=?,grade=?,gender=?,age=?,address=? where id="+id;
	Connection conn=Util.getConnection();
	PreparedStatement pst;
	try {
	pst = conn.prepareStatement(sql);
	pst.setInt(1, studentmodel.getId());
	pst.setString(2, studentmodel.getName());
	pst.setString(3,studentmodel.getGrade());
	pst.setString(4, studentmodel.getGender());
	pst.setInt(5, studentmodel.getAge());
	pst.setString(6, studentmodel.getAddress());
	pst.executeUpdate();
	flag=true;
	} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	}
	return flag;
	}

	@Override
	public Studentmodel selStu(int id) {
	Studentmodel studentmodel=new Studentmodel();
	String sql="select * from student1 where id=?";
	Connection conn=Util.getConnection();
	try {
	PreparedStatement pst=conn.prepareStatement(sql);
	pst.setInt(1,id);
	ResultSet rs=pst.executeQuery();
	while(rs.next()){
	//遍歷結果集
	studentmodel.setId(rs.getInt("id"));
	studentmodel.setName(rs.getString("name"));
	studentmodel.setGrade(rs.getString("grade"));
	studentmodel.setGender(rs.getString("gender"));
	studentmodel.setAge(rs.getInt("age"));
	studentmodel.setAddress(rs.getString("address"));
	}
	} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
	}
	// TODO Auto-generated method stub
	return studentmodel;
	}

}

3.建立每個接口方法的servlet。

1）添加的servlet

package cn.edu.hpu.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 cn.edu.hpu.model.Studentmodel;
import cn.edu.hpu.service.Student;
import cn.edu.hpu.service.StudentImpl;

public class tianjia extends HttpServlet {


	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	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("utf-8");
	int Id = Integer.parseInt(request.getParameter("id"));
 String Name=request.getParameter("name");
 String Grade=request.getParameter("grade");
 String Gender=request.getParameter("gender");
 int Age=Integer.parseInt(request.getParameter("age"));
 String Address=request.getParameter("address");
 
 Studentmodel studentmodel=new Studentmodel();
 studentmodel.setId(Id);
 studentmodel.setName(Name);
 studentmodel.setGrade(Grade);
 studentmodel.setGender(Gender);
 studentmodel.setAge(Age);
 studentmodel.setAddress(Address);
 
 Student stu=new StudentImpl();
 boolean flag=stu.addStu(studentmodel);
 if(flag){
 	StudentDaoServlet s=new StudentDaoServlet();
 	s.doPost(request, response);
 }
	}
}

2）刪除的servlet。

package cn.edu.hpu.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 cn.edu.hpu.model.Studentmodel;
import cn.edu.hpu.service.Student;
import cn.edu.hpu.service.StudentImpl;

public class shanchu extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;


	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("UTF-8");
	int Id=Integer.parseInt(request.getParameter("id"));
 
	Studentmodel studentmodel=new Studentmodel();
	studentmodel.setId(Id);
	
	Student stu=new StudentImpl();
	boolean flag=stu.delStu(Id);
	if(flag){
	StudentDaoServlet s=new StudentDaoServlet();
	s.doPost(request, response);
	}
	}
}

3）更新的servlet。

package cn.edu.hpu.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 cn.edu.hpu.model.Studentmodel;
import cn.edu.hpu.service.Student;
import cn.edu.hpu.service.StudentImpl;

public class gengxin extends HttpServlet {
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	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("UTF-8");
 int Id=Integer.parseInt(request.getParameter("id"));
 String Name=request.getParameter("name");
 String Grade=request.getParameter("grade");
 String Gender=request.getParameter("gender");
 int Age=Integer.parseInt(request.getParameter("age"));
 String Address=request.getParameter("address");
 
 Studentmodel studentmodel=new Studentmodel();
 studentmodel.setId(Id);
 studentmodel.setName(Name);
 studentmodel.setGrade(Grade);
 studentmodel.setGender(Gender);
 studentmodel.setAge(Age);
 studentmodel.setAddress(Address);
 
 Student stu=new StudentImpl();
 boolean flag=stu.updStu(Id, studentmodel);
 if(flag){
 	StudentDaoServlet s=new StudentDaoServlet();
 	s.doPost(request, response);
 }
 
 }
}

4）查詢的servlet。

以上即完成了增刪改查的操作。

4. 建jsp頁面。這是登錄注冊完成后跳轉到的頁面。有添加，刪除，修改，查詢的超鏈接，點擊后跳轉到相應頁面可以進行相應的操作。

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>



 可以 My JSP 'success.jsp' starting page
 
	
	

 
 
 
 
 歡迎你！<%=session.getAttribute("username") %>
 歡迎登陸教務處系統
 
 
 添加

 
 刪除

 
 更新


 查找
 
 
 
 

 
 	
 	
 	ID：
 	Name：
 	Grade：
 	Gender:
 	Age:
 	Address:
 	
 	
 	${studentmodel.id }
 	 ${studentmodel.name }
 	${studentmodel.grade }
 	${studentmodel.gender}
 	${studentmodel.age}
 	${studentmodel.address}
 	
 	
 	
 

 <%@include file="/Page.jsp" %>

至此完成了增刪改查的相應操作。

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

信息管理系統的增刪改查

推薦度：

點擊下載本文 文檔為doc格式

標簽：信息修改更新

熱門焦點

信息管理系統的增刪改查

信息管理系統的增刪改查

代碼在修改更新上有一些缺陷，應該先把相應的要修改的部分查詢顯示顯示出來再進行修改。其實完成增刪改查的原理與登錄注冊是一樣的。

1.首先建student類。

2.

1)建接口類。

2)接口類的實現

3.建立每個接口方法的servlet。

1）添加的servlet

2）刪除的servlet。

3）更新的servlet。

4）查詢的servlet。

以上即完成了增刪改查的操作。

4. 建jsp頁面。這是登錄注冊完成后跳轉到的頁面。有添加，刪除，修改，查詢的超鏈接，點擊后跳轉到相應頁面可以進行相應的操作。

歡迎你！<%=session.getAttribute("username") %>

歡迎登陸教務處系統

添加

刪除

更新

查找

信息管理系統的增刪改查

最新推薦

猜你喜歡

熱門推薦

ID：	Name：	Grade：	Gender:	Age:	Address:
${studentmodel.id }	${studentmodel.name }	${studentmodel.grade }	${studentmodel.gender}	${studentmodel.age}	${studentmodel.address}