首页 > 其他分享 >5.29

5.29

时间：2023-06-11 09:02:04浏览次数：46  
标签：String rs state SQLException 5.29 null conn

今日对昨天考试的功能又增加了一些,完成了在考试的时候没有完成的功能:

代码如下:

Dao.java

复制代码 
package dao;

import Util.DBUtil;
import bean.Sbean;
import bean.Tbean;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Dao {

    public boolean add(Sbean ten) throws ClassNotFoundException , SQLException
    {
        String sql="insert into student(num,name,banji,sex,nianji)values"
                + "('" + ten.getNum() + "','" + ten.getName() + "','"+ ten.getBanji() + "','" + ten.getSex()+ "','"+ten.getNianji() + "')";

        Connection conn= DBUtil.getConnection();
        Statement state=null;
        boolean f=false;
        int a = 0;
        try {
            state = conn.createStatement();
            state.executeUpdate(sql);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {

            DBUtil.close(state, conn);
        }
        if(a>0)
            f=true;
        return f;
    }
    public boolean add1(Tbean ten) throws ClassNotFoundException , SQLException
    {
        String sql="insert into teacher(Tnum,Tname,Tsex,course)values"
                + "('" + ten.getTnum() + "','" + ten.getTname() + "','"+ ten.getTsex()+ "','"+ten.getCourse() + "')";

        Connection conn= DBUtil.getConnection();
        Statement state=null;
        boolean f=false;
        int a = 0;
        try {
            state = conn.createStatement();
            state.executeUpdate(sql);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {

            DBUtil.close(state, conn);
        }
        if(a>0)
            f=true;
        return f;
    }
    //update
   public boolean update(Sbean b)
    {
        Connection con=null;
        PreparedStatement pstmt=null;
        ResultSet rs=null;
        try {
            con=DBUtil.getConnection();
            String sql="update student set name=?,banji=?,sex=?,nianji=? where num=?";
            pstmt=con.prepareStatement(sql);
            pstmt.setString(1, b.getName());
            pstmt.setString(2, b.getBanji());
            pstmt.setString(3, b.getSex());
            pstmt.setString(4, b.getNianji());
            pstmt.setString(5, b.getNum());

            pstmt.executeUpdate();
            return true;
        }
        catch (SQLException | ClassNotFoundException e) {
            System.out.println("更新失败");
            e.printStackTrace();
        }
        finally {
            DBUtil.close(rs, pstmt, con);
        }
        return false;
    }
    public Sbean getbytitle(String name) throws ClassNotFoundException ,SQLException
    {
        String sql = "select * from student where num ='" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;
        Sbean ten = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {


                String title2 = rs.getString("num");
                String zi2 = rs.getString("name");
                String person2 = rs.getString("banji");
                String date2=rs.getString("sex");
                String neirong2=rs.getString("nainji");

                ten = new Sbean(title2, zi2 ,person2 ,date2,neirong2);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return ten;
    }

    public boolean update1(Tbean b)
    {
        Connection con=null;
        PreparedStatement pstmt=null;
        ResultSet rs=null;
        try {
            con=DBUtil.getConnection();
            String sql="update teacher set Tname=?,Tsex=?,course=? where Tnum=?";
            pstmt=con.prepareStatement(sql);
            pstmt.setString(1, b.getTname());
            pstmt.setString(2, b.getTsex());
            pstmt.setString(3, b.getCourse());
            pstmt.setString(4, b.getTnum());


            pstmt.executeUpdate();
            return true;
        }
        catch (SQLException | ClassNotFoundException e) {
            System.out.println("更新失败");
            e.printStackTrace();
        }
        finally {
            DBUtil.close(rs, pstmt, con);
        }
        return false;
    }
    public Tbean getbytitle1(String name) throws ClassNotFoundException ,SQLException
    {
        String sql = "select * from teacher where Tnum ='" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;
        Tbean ten = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {


                String title2 = rs.getString("Tnum");
                String zi2 = rs.getString("Tname");
                String person2 = rs.getString("banji");
                String date2=rs.getString("sex");


                ten = new Tbean(title2, zi2 ,person2 ,date2);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return ten;
    }
    //delete
    public boolean delete(String name) throws SQLException, ClassNotFoundException {
        String sql="delete from student where num='" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        int a = 0;
        boolean f = false;
        try {
            state = conn.createStatement();
            a = state.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(state, conn);
        }

        if (a > 0) {
            f = true;
        }
        return f;
    }
    //update
    public boolean delete1(String name) throws SQLException, ClassNotFoundException {
        String sql="delete from teacher where Tnum='" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        int a = 0;
        boolean f = false;
        try {
            state = conn.createStatement();
            a = state.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(state, conn);
        }

        if (a > 0) {
            f = true;
        }
        return f;
    }
    //查找
    public boolean name(String name) throws SQLException, ClassNotFoundException {
        boolean flag = false;
        String sql = "select num from student where num = '" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }
        return flag;
    }


    public List<Sbean> search(String zi, String date) throws SQLException, ClassNotFoundException {
        String sql = "select * from student where ";


        if (zi != "") {
            sql += "num like '%" +zi+ "%'";
        }



        List<Sbean> list = new ArrayList<>();
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;
        Sbean bean = null;
        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                String title2 = rs.getString("num");
                String zi2 = rs.getString("name");
                String person2 = rs.getString("banji");
                String date2=rs.getString("sex");
                String neirong2=rs.getString("nianji");
                bean = new Sbean(title2, zi2 ,person2,date2,neirong2);

                list.add(bean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return list;
    }

    public List<Sbean> list() throws SQLException, ClassNotFoundException {
        String sql = "select * from student";
        List<Sbean> list = new ArrayList<>();
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                Sbean bean = null;

                String title2 = rs.getString("num");
                String zi2 = rs.getString("name");
                String person2 = rs.getString("banji");
                String date2=rs.getString("sex");
                String neirong2=rs.getString("nianji");

                bean = new Sbean(title2, zi2 ,person2,date2,neirong2);

                list.add(bean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return list;
    }
    public boolean name1(String name) throws SQLException, ClassNotFoundException {
        boolean flag = false;
        String sql = "select Tnum from teacher where Tnum = '" + name + "'";
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }
        return flag;
    }


    public List<Tbean> search1(String zi, String date) throws SQLException, ClassNotFoundException {
        String sql = "select * from teacher where ";


        if (zi != "") {
            sql += "Tnum like '%" +zi+ "%'";
        }



        List<Tbean> list = new ArrayList<>();
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;
        Tbean bean = null;
        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                String title2 = rs.getString("Tnum");
                String zi2 = rs.getString("Tname");
                String person2 = rs.getString("Tsex");
                String date2=rs.getString("course");

                bean = new Tbean(title2, zi2 ,person2,date2);

                list.add(bean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return list;
    }

    public List<Tbean> list1() throws SQLException, ClassNotFoundException {
        String sql = "select * from teacher";
        List<Tbean> list = new ArrayList<>();
        Connection conn = DBUtil.getConnection();
        Statement state = null;
        ResultSet rs = null;

        try {
            state = conn.createStatement();
            rs = state.executeQuery(sql);
            while (rs.next()) {
                Tbean bean = null;

                String title2 = rs.getString("Tnum");
                String zi2 = rs.getString("Tname");
                String person2 = rs.getString("Tsex");
                String date2=rs.getString("nianji");


                bean = new Tbean(title2, zi2 ,person2,date2);

                list.add(bean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(rs, state, conn);
        }

        return list;
    }
}
复制代码

service.java

复制代码 
package service;

import bean.Sbean;
import bean.Tbean;
import dao.Dao;

import java.sql.SQLException;
import java.util.List;

public class Service {
  Dao tDao=new Dao();
    public boolean add(Sbean ten) throws SQLException, ClassNotFoundException {
        boolean f = false;
        if(!tDao.name(ten.getNum()))
        {
            tDao.add(ten);
            f=true;
        }
        return f;
    }
    public boolean add1(Tbean ten) throws SQLException, ClassNotFoundException {
        boolean f = false;
        if(!tDao.name(ten.getTnum()))
        {
            tDao.add1(ten);
            f=true;
        }
        return f;
    }
    public boolean delete(String title) throws SQLException, ClassNotFoundException {
        tDao.delete(title);
        return true;
    }
    public boolean delete1(String title) throws SQLException, ClassNotFoundException {
        tDao.delete(title);
        return true;
    }
    public boolean update(Sbean ten)
    {
        tDao.update(ten);
        return true;
    }

    public Sbean getbytitle(String title) throws SQLException, ClassNotFoundException {
        return tDao.getbytitle(title);
    }

    public List<Sbean> search(String zi, String date) throws SQLException, ClassNotFoundException {
        return tDao.search(zi,date);
    }


    public List<Sbean> list() throws SQLException, ClassNotFoundException {
        return tDao.list();
    }
    public boolean update1(Tbean ten)
    {
        tDao.update1(ten);
        return true;
    }

    public Tbean getbytitle1(String title) throws SQLException, ClassNotFoundException {
        return tDao.getbytitle1(title);
    }

    public List<Tbean> search1(String zi, String date) throws SQLException, ClassNotFoundException {
        return tDao.search1(zi,date);
    }


    public List<Tbean> list1() throws SQLException, ClassNotFoundException {
        return tDao.list1();
    }
}

标签：String,rs,state,SQLException,5.29,null,conn
From： https://www.cnblogs.com/ruipengli/p/17472472.html

相关文章

  • 5.29学习总结
    CSS3框大小CSS3 box-sizing 属性可以设置width和height属性中包含了padding(内边距)和border(边框)。浏览器支持表格中的数字表示支持该属性的第一个浏览器的版本号。紧跟在数字后面的-webkit-或-moz-为指定浏览器的前缀。属性     box-sizing10.04......
  • 23.5.29-6.4 每周总结
    本周是考试周，我参加了数据库，web，体育等多门课程的考试。考试内容涵盖了各个学期的知识点和实践能力，题型形式多样。在考试过程中，我尽力发挥自己的实力和水平，同时也充分体验到学习和复习的重要性。目前正在备考下周的多门专业课考试。......
  • 5.29每日总结
    今天课上做了一个测试河北宏志大学学生成绩管理系统1、项目需求：学生管理是各大院校的管理工作中尤为重视的一项工作，它一直以来是学校管理的一项重要的衡量指标。学生管理系统的应用解决了学校日常学生管理工作中的信息量大、数据难以统计、数据更新困难等问题。河北宏志大学为......
  • 5.29每日总结
      今天上课考试，大体功能实现了，但是在成绩查询的页面出现bug，不显示结果，测验主要就是这方面还没弄好。  三个增删改查＋分页查询。     2021级《软件工程》开发技能测试试卷（180分钟） 河北宏志大学学生成绩管理系统（卷面成绩40分） 河北宏志大学学生成绩管理系统1......
  • sql学习5.29
    length()返回字符串的长度，例如可以返回数据库名字的长度substr()⽤来截取字符串ascii()返回字符的ascii码sleep(n)将程序挂起⼀段时间，n为n秒if(expr1,expr2,expr3)判断语句如果第⼀个语句正确就执⾏第⼆个语句如果错误执⾏第三个语句报错回显注入：1、通过floor报错,......
  • 5.29
    今天Java考试代码如下packageservlet;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importmodel.PageBean;i......
  • 2023.5.29Linux系统压缩打包
    02.Linux系统压缩打包1.zip压缩工具2.TAR压缩工具3.TAR实践案例windows下我们接触最多的压缩文件就是rar格式，但linux有自己所特有的压缩工具如果希望windiows和linux互相能使用的压缩工具，建议.zip格式压缩的好处主要有节省磁盘空间占用率节省网络传输带宽消耗网络传输更......
  • 5.29每日总结
    今天上课做了这学期的测试，虽然长时间没有写html及前端的东西，但是还是比较顺利的完成了；林另外下面是我们团队队员总结团队内部的问题：在项目开发的过程中，我们团队存在诸多潜在问题。经过改进的用户界面仍然不够友好。由于开发团队没有专业的界面美工设计人员，以及没有足够的用......
  • 2023.5.29每日总结
    publicAllMethods()throwsException{Class.forName("com.mysql.jdbc.Driver");Stringurl="jdbc:mysql://localhost:3306/rjgc?useSSL=false&useUnicode=true&characterEncoding=utf8";Stringusername="......
  • 每日总结-23.5.29
    <%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http://www.w3.org/TR/html4/loose.dtd"&g......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99