logdaoimp.java~25~

用户登录,增加,删除,修改,查询数据库,验证码的使用

package com.hanb.log.dao;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.*;//list
import com.hanb.log.jdbc.ResourceManager;
import com.hanb.log.bean.Stu;
import com.hanb.log.form.LogForm;
import com.hanb.log.tool.TransCode;
public class LogDAOIMP {
    public LogDAOIMP() {
    }


    TransCode ts=new TransCode();
    /**
     *
     * @param userName String
     * @param psw String
     * @return boolean
     * @throws Exception
     */
    public boolean checkUser(String userName, String psw) throws Exception {
        boolean flag = false;
        String sql = "select * from myuser where userName='" + userName +
                     "' and psw='" + psw + "'";
        System.out.println("sql=" + sql);
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        try {
            con = ResourceManager.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if (rs.next()) {
                System.out.println("检验成功");
                flag = true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            ResourceManager.close(rs);
            ResourceManager.close(st);
            ResourceManager.close(con);
        }
        return flag;
    }
    public List viewAllStu()throws Exception{
        List list =new ArrayList();
        String sql = "select * from stu";
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        try {
            con = ResourceManager.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            while (rs != null && rs.next()) {
                Stu stu = new Stu();
                stu.setId(rs.getInt("id"));
                stu.setStuAge(rs.getString("stuAge"));
                stu.setStuCity(rs.getString("stuCity"));
                stu.setStuName(rs.getString("stuName"));
                stu.setStuSex(rs.getString("stuSex"));
                list.add(stu);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
         ResourceManager.close(rs);
         ResourceManager.close(st);
         ResourceManager.close(con);
     }
     return list;
 }
 /**
  *
  * @param form LogForm
  * @return boolean
  * @throws Exception
  */
 public boolean addStu(LogForm form) throws Exception {
        boolean flag = false;
        System.out.println("姓名:"+form.getStuName());
        System.out.println("年龄:"+form.getStuAge());
        System.out.println("性别:"+form.getStuSex());
        System.out.println("城市:"+form.getStuCity());

        String stuName=form.getStuName();
        String stuSex=form.getStuSex();
        String stuCity=form.getStuCity();


//        String stuName=ts.toChinese(form.getStuName());
//        String stuSex=ts.toChinese(form.getStuSex());
//        String stuCity=ts.toChinese(form.getStuCity());


        String sql = "insert into stu (stuName,stuAge,stuSex,stuCity) values ('"+stuName+"','"+form.getStuAge()+"','"+stuSex+"','"+stuCity+"')";
        System.out.println("sql=" + sql);
        Connection con = null;
        Statement st = null;
        int rs = 0;
        try {
            con = ResourceManager.getConnection();
            st = con.createStatement();
            rs = st.executeUpdate(sql);
            if (rs>0) {
                System.out.println("增加纪录成功");
                flag = true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            ResourceManager.close(st);
            ResourceManager.close(con);
        }
        return flag;
    }
    /**
     *
     * @param id int
     * @return Stu
     * @throws Exception
     */
    public Stu viewSingleStuById(int id)throws Exception{
        Stu stu=new Stu();
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        String sql="select * from stu where id="+id;
        try {
            con = ResourceManager.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if(rs != null && rs.next()) {
                stu.setId(rs.getInt("id"));
                stu.setStuAge(rs.getString("stuAge"));
                stu.setStuCity(rs.getString("stuCity"));
                stu.setStuName(rs.getString("stuName"));
                stu.setStuSex(rs.getString("stuSex"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
         ResourceManager.close(rs);
         ResourceManager.close(st);
         ResourceManager.close(con);
     }
        return stu;
    }
    /**
     * 修改纪录
     * @param form LogForm
     * @return boolean
     * @throws Exception
     */
    public boolean changeStu(LogForm form) throws Exception {
        boolean flag = false;
        System.out.println("姓名:"+form.getStuName());
        System.out.println("年龄:"+form.getStuAge());
        System.out.println("性别:"+form.getStuSex());
        System.out.println("城市:"+form.getStuCity());

        String stuName=form.getStuName();
        String stuSex=form.getStuSex();
        String stuCity=form.getStuCity();


//        String stuName=ts.toChinese(form.getStuName());
//        String stuSex=ts.toChinese(form.getStuSex());
//        String stuCity=ts.toChinese(form.getStuCity());


        String sql = "insert into stu (stuName,stuAge,stuSex,stuCity) values ('"+stuName+"','"+form.getStuAge()+"','"+stuSex+"','"+stuCity+"')";
        System.out.println("sql=" + sql);
        Connection con = null;
        Statement st = null;
        int rs = 0;
        try {
            con = ResourceManager.getConnection();
            st = con.createStatement();
            rs = st.executeUpdate(sql);
            if (rs>0) {
                System.out.println("修改纪录成功");
                flag = true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            ResourceManager.close(st);
            ResourceManager.close(con);
        }
        return flag;
    }


    /**
     * 删除纪录
     * @param id int
     * @return boolean
     * @throws Exception
     */

    public boolean delStu(int id) throws Exception {
           boolean flag = false;
           String sql = "delete from stu where id="+id;
           System.out.println("sql=" + sql);
           Connection con = null;
           Statement st = null;
           int rs = 0;
           try {
               con = ResourceManager.getConnection();
               st = con.createStatement();
               rs = st.executeUpdate(sql);
               if (rs>0) {
                   System.out.println("删除纪录成功");
                   flag = true;
               }
           } catch (Exception e) {
               e.printStackTrace();
           } finally {
               ResourceManager.close(st);
               ResourceManager.close(con);
           }
           return flag;
    }

}