锐单电子商城，一站式电子元器件采购平台！

电话：400-990-0325

一个简单的管理系统功能（增加，删除，显示数据）

时间：2022-08-27 11:00:00 低浓度甲烷传感器gjc4

一.开启SQL Server Management Studio数据库服务

二.建库建表

create database db_yuchangglxt--渔场管理系统 use db_yuchangglxt--运行 create table tb_yc ( bh int primary key identity(1，1)-编号 mc varchar(100),--名称 lx varchar(100),--类型 jg float,--价格 ms varchar(100)--描述 ) --插数据 insert into tb_yc values --(某渔场1'，真的很好，9.九、还不错，很多鱼， (某渔场2'，真的很好，9.9,还不错，很多鱼， (某渔场3'，真的很好，9.9,还不错，很多鱼， (某渔场4'，真的很好，9.9,还不错，很多鱼， (某渔场5'，真的很好，9.9,还不错，很多鱼， (某渔场6'，真的很好，9.9,还不错，很多鱼， ('某渔场7','真不错',9.九、还不错，很多鱼， (某渔场8'，真的很好，9.九、还不错，很多鱼， (某渔场9'，真的很好.九、还不错，很多鱼都是 select *from tb_yc

三.用eclipse编写代码和方法

1.建五个包

2.布局主页

3.增加、删除和显示数据功能

代码如下

utils：DBHelper类

package com.utils;  import java.sql.Connection; import java.sql.Driver; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet;  import com.sun.corba.se.spi.presentation.rmi.PresentationManager; import com.sun.xml.internal.fastinfoset.util.PrefixArray;  public class DBHelper {     static {      try {    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");   } catch (Exception e) {    e.printStackTrace();   }     }     public static Connection getConn() {      Connection conn  =null;      try {    conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=db_yuchangglxt","sa","123");   } catch (Exception e) {    e.printStackTrace();   }      return conn;     }          public static void myClose(Connection conn, PreparedStatement ps, ResultSet rs) {      try {    if(conn!=null && conn.isClosed()) {     conn.close();    }    if(ps!=null && conn.isClosed()) {     conn.close();    }    if(ps!=null) {    ps.close();     }    if(rs!=null) {     rs.close();    }   } catch (Exception e) {    e.printStackTrace();   }           }      }

entity:YC类

package com.entity;  public class YC { // bh int primary key identity(1，1)-编号 // mc varchar(100),--名称 // lx varchar(100),--类型 // jg float,--价格 // ms varchar(100)--描述     private int bh;     private String mc;     private String lx;     private float jg;     private String ms;     public YC() {   // TODO Auto-generated constructor stub  }  public YC(String mc, String lx, float jg, String ms) {   super();   this.mc = mc;   this.lx = lx;   this.jg = jg;   this.ms = ms;  }  public YC(int bh, String mc, String lx, float jg, String ms) {   super();   this.bh = bh;   this.mc = mc;   this.lx = lx;   this.jg = jg;   this.ms = ms;  }  public int getBh() {   return bh;  }  public void setBh(int bh) {   this.bh = bh;  }  public String getMc() {   return mc;  }  public void setMc(String mc) {   this.mc = mc;  }  public String getLx() {   return lx;  }  public void setLx(String lx) {   this.lx = lx;  }  public float getJg() {   return jg;  }  public void setJg(float jg) {   this.jg = jg;  }  public String getMs() {   return ms;  }  public void setMs(String ms) {   this.ms = ms;  }  @Override  public String toString() {   return "YC [bh="   bh   ", mc="   mc   ", lx="   lx   ", jg="   jg   ", ms="   ms   "]";  }     }

dao:IYCDao接口

package com.dao;  import java.util.List;  import com.entity.YC;  /**  * 数据访问层  * @author Administrator  *  */ public interface IYCDao {  /**   * 查询所有   * @return   */     List cxsy();     /**      * 删除渔场      */     int scyc(int bh);     /**      *       * 增加渔场      */     int zjyc(YC yc); }

dao:接口实现类：YCDaoimpl

package com.dao;  import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List;  import com.entity.YC; import com.utils.DBHelper;  public class YCDaoimpl implements IYCDao {  public static void main(String[] args) {   Listcxsy =new YCDaoimpl().cxsy();   System.out.println(cxsy);  }  /**   * 查询所有   */  @Override  public List cxsy() {   Connection conn = null;   PreparedStatement ps = null;   ResultSet rs = null;   YC yc = null;   List list = new ArrayList();   int n = 0;   String sql = null;   try {    conn = DBHelper.getConn();    sql = "select*from tb_yc";    ps = conn.prepareStatement(sql);    rs = ps.executeQuery();    while (rs.next()) {     yc = new YC();     yc.setBh(rs.getInt(1));     yc.setMc(rs.getString(2));     yc.setLx(rs.getString(3));     yc.setJg(rs.getFloat(4));     yc.setMs(rs.getString(5));     list.add(yc);    }   } catch (Exception e) {    e.printStackTrace();   } finally {    DBHelper.myClose(conn, ps, null);   }    return list;  }   /**   * 删除渔场   */  @Override  public int scyc(int bh) {   Connection conn = null;   PreparedStatement ps  null;
		int n = 0;
		String sql = null;
		try {
			conn = DBHelper.getConn();
			sql = "dalete from tb_yc where bh="+bh;
			ps = conn.prepareStatement(sql);
			n=ps.executeUpdate();
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBHelper.myClose(conn, ps, null);
		}

		return n;
	}

	/**
	 * 增加渔场
	 */
	@Override
	public int zjyc(YC yc) {
		Connection conn = null;
		PreparedStatement ps = null;
		int n = 0;
		String sql = null;
		try {
			conn = DBHelper.getConn();
			sql = "insert into tb_yc values(?,?,?,?)";
			ps = conn.prepareStatement(sql);
			ps.setString(1, yc.getMc());
			ps.setString(2, yc.getLx());
			ps.setFloat(3, yc.getJg());
			ps.setString(4, yc.getMs());
			n=ps.executeUpdate();
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBHelper.myClose(conn, ps, null);
		}

		return n;
	}

}

biz接口类：IYCBiz

package com.biz;

import java.util.List;

import com.entity.YC;

public interface IYCBiz {

		/**
		 * 查询所有
		 * @param gjc 
		 * @param zd 
		 * @return
		 */
	    List cxsy();
	    /**
	     * 删除渔场
	     */
	    int scyc(int bh);
	    /**
	     * 
	     * 增加渔场
	     */
	    int zjyc(YC yc);

}

biz接口实现类：YCBizimpl

package com.biz;

import java.util.List;

import com.dao.YCDaoimpl;
import com.entity.YC;

public class YCBizimpl implements IYCBiz{

	public List cxsy() {
		return new YCDaoimpl().cxsy();
	}
 
	@Override
	public int scyc(int bh) {
		return new YCDaoimpl().scyc(bh);
	}

	@Override
	public int zjyc(YC yc) {
		return new YCDaoimpl().zjyc(yc);
	}


	

	
    
}

实现增加功能servlet类

package com.servlet;

import java.io.IOException;

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 com.biz.IYCBiz;
import com.biz.YCBizimpl;
import com.entity.YC;

/**
 * 新增图书的servlet控制器
 */
@WebServlet("/XZYCServlet")
public class XZYCServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.设置编码
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		
		//获取编号
		//int bh = Integer.valueOf(request.getParameter("bh"));
		
		//名称
		String mc = request.getParameter("mc");
		//类型
		String lx = request.getParameter("lx");
		//价格
		float jg = Float.valueOf(request.getParameter("jg"));
		//描述
		String ms = request.getParameter("ms");
		
		//封装实体
		YC yc = new YC(mc, lx, jg, ms);
		
		//2.调用biz
		IYCBiz isb = new YCBizimpl();
		int n = isb.zjyc(yc);
		if(n>0) {
			response.getWriter().println("");
		}else {
			response.getWriter().println("");
		}

		
		
	}

}

实现删除功能servlet类

package com.servlet;

import java.io.IOException;

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 com.biz.IYCBiz;
import com.biz.YCBizimpl;

/**
 * 删除图书的servlet控制器
 */
@WebServlet("/SCTSServlet")
public class SCYCServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.设置编码
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		
		//获取编号
		int bh = Integer.valueOf(request.getParameter("bh"));
		
		//2.调用biz
		IYCBiz isb = new YCBizimpl();
		int n = isb.scyc(bh);
		if(n>0) {
			response.getWriter().println("");
		}else {
			response.getWriter().println("");
		}

		
		
	}

}

实现显示数据servlet类

package com.servlet;

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

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 com.biz.IYCBiz;
import com.biz.YCBizimpl;
import com.entity.YC;

/**
 * 查询所有的servlet控制器
 */
@WebServlet("/CXSYServlet")
public class CXSYServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//1.设置编码
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		
		//获取zd和gjc
		String zd = request.getParameter("zd");
		if(zd == null) {
			zd = "mc";
		}
		String gjc = request.getParameter("gjc");
		if(gjc == null) {
			gjc = "";
		}
		
		
		//2.调用biz
		IYCBiz isb = new YCBizimpl();
		List cxsy = isb.cxsy();
		//模糊查询
//		List cxsy = isb.cxsy(zd, gjc);
		
		//3.保存到域对象
		HttpSession session = request.getSession();
		session.setAttribute("cxsy", cxsy);
		
		//4.跳转
		response.sendRedirect("index.jsp");
		
		
	}

}

主界面代码

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    
    
    




Insert title here



	
	
		
	
	


	渔场管理系统首页
	
	
	
		
		
		
	
	
	


	
	


	
	
			
		
			编号
			名称
			类型
			价格
			操作
		
		
				${yc.bh }
				${yc.mc }
				${yc.lx }
				${yc.jg }

主界面显示图片

实现增加功能xzyc.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>




Insert title here




	新增渔场
	

	
	
	
		
			名称
			
		
		
			类型
			
		
		
			价格
			
		
		
			描述

实现显示数据功能cxsy.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>




Insert title here




	查看渔场
	

		
	
		
			编号
			
		
		
			名称
			
		
		
			类型
			
		
		
			价格
			
		
		
			描述

增加页面

锐单商城拥有海量元器件数据手册、IC替代型号，打造电子元器件IC百科大全！

编号	名称	类型	价格	操作
${yc.bh }	${yc.mc }	${yc.lx }	${yc.jg }

一个简单的管理系统功能（增加，删除，显示数据）

一.开启SQL Server Management Studio数据库服务

二.建库建表

三.用eclipse编写代码和方法

代码如下

渔场管理系统首页

新增渔场

查看渔场

相关文章