简单的数据库操作 增 删 改 查

public class TeacherManage
    {
        // 添加语句
        public static final String INSERTTEACHER = "insert into  teacher(name,password) values(?,?)";
 
        // 删除语句
        public static final String DELETEATEACHER = "delete from teacher where teaId = ?";
 
        // 修改语句
        public static final String UPDATETEACHER = "update teacher set name = ?,password = ? where teaid = ?";
 
        // 查询语句
        public static final String SELECTTEACHER = "select * from teacher";

        // 添加一条记录
        public static boolean insertTeacher(String name, String password)
        {
            boolean flag = false;
            Connection conn = DBManage.getConnection();
            PreparedStatement pstmt = null;
            int count = 0;
            try
            {
                pstmt = conn.prepareStatement(INSERTTEACHER);
                pstmt.setString(1, name);
                pstmt.setString(2, password);
                count = pstmt.executeUpdate(); // 记录操作执行的记录条数
                if (count != 0)
                {
                    flag = true;
                }
                conn.commit();
            }
            catch (SQLException e)
            {
                e.printStackTrace();
            }
            finally
            {
                if (null != conn)
                {
                    try
                    {
                        conn.close();
                    }
                    catch (SQLException e)
                    {
                        e.printStackTrace();
                    }
                }
                if (null != pstmt)
                {
                    try
                    {
                        pstmt.close();
                    }
                    catch (SQLException e)
                    {
                        e.printStackTrace();
                    }
                }
            }
            return flag;
        }
 

        // 删除一条信息
        public static boolean deleteATEacher(int id)
        {
            boolean flag = false;
            Connection conn = DBManage.getConnection();
            PreparedStatement pstmt = null;
            int count = 0;
            try
            {
                pstmt = conn.prepareStatement(DELETEATEACHER);
                pstmt.setInt(1, id);
                count = pstmt.executeUpdate();
                if (count != 0)
                {
                    flag = true;
                }
                conn.commit();
            }
            catch (SQLException e)
            {
                e.printStackTrace();
            }
            finally
            {
                if (null != conn)
                {
                    try
                    {
                        conn.close();
                    }
                    catch (SQLException e)
                    {
                        e.printStackTrace();
                    }
                }
                if (null != pstmt)
                {
                    try
                    {
                        pstmt.close();
                    }
                    catch (SQLException e)
                    {
                        e.printStackTrace();
                    }
                }
            }
            return flag;
        }
 

        // 修改一条记录
        public static boolean updateTeacher(int id, String name,
                                            String password)
        {
            boolean flag = false;
            Connection conn = DBManage.getConnection();
            PreparedStatement pstmt = null;
            int count = 0;
            try
            {
                pstmt = conn.prepareStatement(UPDATETEACHER);
                pstmt.setInt(1, id);
                pstmt.setString(2, password);
                pstmt.setString(3, name);
                count = pstmt.executeUpdate();
                if (count != 0)
                {
                    flag = true;
                }
                conn.commit();
            }
            catch (SQLException e)
            {
                e.printStackTrace();
            }
            finally
            {
                if (null != conn)
                {
                    try
                    {
                        conn.close();
                    }
                    catch (SQLException e)
                    {
                        e.printStackTrace();
                    }
                }
                if (null != pstmt)
                {
                    try
                    {
                        pstmt.close();
                    }
                    catch (SQLException e)
                    {
                        e.printStackTrace();
                    }
                }
            }
            return flag;
        }
 

        // 查询信息
        public static void seleteTeacher()
        {
            Connection conn = DBManage.getConnection();
            Statement stmt = null;
            ResultSet rs = null;
            try
            {
                stmt = conn.createStatement();
                rs = stmt.executeQuery(SELECTTEACHER);
                while (rs.next())
                {
                    System.out.print(rs.getInt("teaId") + "          ");
                    System.out.print(rs.getString("name") + "          ");
                    System.out.println(rs.getString("password"));
                }
                conn.commit();
            }
            catch (SQLException e)
            {
                e.printStackTrace();
            }
            finally
            {
                if (null != conn)
                {
                    try
                    {
                        conn.close();
                    }
                    catch (SQLException e)
                    {
                        e.printStackTrace();
                    }
                }
            }
        }
 
 
        // 测试
        public static void main(String[] args)
        {
            boolean flag = TeacherManage.insertTeacher("cc", "456");
            boolean flag = TeacherManage.deleteATEacher(42);
            boolean flag = TeacherManage.updateTeacher("haha", "147");
            System.out.println(flag);
            TeacherManage.seleteTeacher();
        }
    }
<script type=text/javascript charset=utf-8 src="http://static.bshare.cn/b/buttonLite.js#style=-1&uuid=&pophcol=3&lang=zh"></script> <script type=text/javascript charset=utf-8 src="http://static.bshare.cn/b/bshareC0.js"></script>
阅读(954) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值