用户注册



邮箱：

密码：

用户登录


邮箱：

密码：
记住登录一个月忘记密码？

发表随想


还能输入：200字
云代码 - java代码库

宿舍

2017-09-11 作者： 云代码会员举报

[java]代码库

view sourceprint?
package com.dao;
 
import com.db.DBHelper;
import com.bean.BuildingBean;
 
import java.util.*;
import java.sql.*;
 
public class BuildingDao {
     
    //获取列表
    public List<BuildingBean> GetList(String strwhere,String strorder){
        String sql="select * from Building";
        if(!(isInvalid(strwhere)))
        {
            sql+=" where "+strwhere;
        }
        if(!(isInvalid(strorder)))
        {
            sql+=" order by "+strorder;
        }
        Statement stat = null;
        ResultSet rs = null;
        Connection conn = new DBHelper().getConn();
        List<BuildingBean> list=new ArrayList<BuildingBean>();
        try{
            stat = conn.createStatement();
            rs = stat.executeQuery(sql);
            while(rs.next()){
                BuildingBean cnbean=new BuildingBean();
                cnbean.setBuilding_ID(rs.getInt("Building_ID"));
                cnbean.setBuilding_Name(rs.getString("Building_Name"));
                cnbean.setBuilding_Introduction(rs.getString("Building_Introduction"));
                list.add(cnbean);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (conn != null)
                    conn.close();
                if (stat != null)
                    stat.close();
                if (rs != null)
                    rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return list;
    }
     
    //获取指定ID的实体Bean
    public BuildingBean GetBean(int id){
        String sql="select * from Building where Building_ID="+id;
        Statement stat = null;
        ResultSet rs = null;
        Connection conn = new DBHelper().getConn();
        BuildingBean cnbean=new BuildingBean();
        try{
            stat = conn.createStatement();
            rs = stat.executeQuery(sql);
            while(rs.next()){
                cnbean.setBuilding_ID(rs.getInt("Building_ID"));
                cnbean.setBuilding_Name(rs.getString("Building_Name"));
                cnbean.setBuilding_Introduction(rs.getString("Building_Introduction"));
                 
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (conn != null)
                    conn.close();
                if (stat != null)
                    stat.close();
                if (rs != null)
                    rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return cnbean;
    }
     
    //添加
    public void Add(BuildingBean cnbean){
        String sql="insert into Building (";
        sql+="Building_Name,Building_Introduction";
        sql+=") values(";
        sql+="'"+cnbean.getBuilding_Name()+"','"+cnbean.getBuilding_Introduction()+"'";
        sql+=")";
        Statement stat = null;
        ResultSet rs = null;
        Connection conn = new DBHelper().getConn();
        try{
            stat = conn.createStatement();
            stat.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (conn != null)
                    conn.close();
                if (stat != null)
                    stat.close();
                if (rs != null)
                    rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    //修改
    public void Update(BuildingBean cnbean){
        String sql="update Building set ";
        sql+="Building_Name='"+cnbean.getBuilding_Name()+"',";
        sql+="Building_Introduction='"+cnbean.getBuilding_Introduction()+"'";
         
        sql+=" where Building_ID='"+cnbean.getBuilding_ID()+"'";
        Statement stat = null;
        ResultSet rs = null;
        Connection conn = new DBHelper().getConn();
        try{
            stat = conn.createStatement();
            stat.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (conn != null)
                    conn.close();
                if (stat != null)
                    stat.close();
                if (rs != null)
                    rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    //删除
    public void Delete(String strwhere){
        String sql="delete Building where ";
        sql+=strwhere;
        Statement stat = null;
        ResultSet rs = null;
        Connection conn = new DBHelper().getConn();
        try{
            stat = conn.createStatement();
            stat.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (conn != null)
                    conn.close();
                if (stat != null)
                    stat.close();
                if (rs != null)
                    rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
 
     
    //判断是否空值
    private boolean isInvalid(String value) {
        return (value == null || value.length() == 0);
    }
     
    //测试
    public static void main(String[] args) {
        System.out.println("");
    }
     
}

[代码运行效果截图]


宿舍


网友评论    (发表评论)


发表评论：

评论须知：

  • 1、评论每次加2分，每天上限为30；
  • 2、请文明用语，共同创建干净的技术交流环境；
  • 3、若被发现提交非法信息，评论将会被删除，并且给予扣分处理，严重者给予封号处理；
  • 4、请勿发布广告信息或其他无关评论，否则将会删除评论并扣分，严重者给予封号处理。


扫码下载

加载中，请稍后...

输入口令后可复制整站源码

加载中，请稍后...