dao层增删改查.docxVIP

/** * */packagecom.ys.dao.impl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.List;importcom.ys.bean.Person;importcom.ys.dao.PersonDao;/** * @author Administrator * */publicclassPersonDaoImplimplementsPersonDao {privatestatic Connection connection;static {try {connection = DBUtils.getConn();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}/* (non-Javadoc) * @see com.ys.dao.impl.PersonDao#addPerson(com.ys.model.Person) */publicbooleanaddPerson(Person person) {boolean result = false;try {String sql = insert into person(id,name) values (?,?);PreparedStatementps = connection.prepareStatement(sql);ps.setInt(1, person.getId());ps.setString(2, person.getName());ps.execute();result = true;System.out.println(result = + result);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();result = false;} /*finally {try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}*/return result;}/* (non-Javadoc) * @see com.ys.dao.impl.PersonDao#delPerson(int) */publicbooleandelPerson(intidValue) {boolean result = false;try {String sql = delete from person where id = + idValue;PreparedStatementps = connection.prepareStatement(sql);ps.execute();int count = ps.getUpdateCount(); if(count != -1) {result = true;} else {result = false;}System.out.println(result = + result);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();result = false;} /*finally {try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}*/return result;}/* (non-Javadoc) * @see com.ys.dao.impl.PersonDao#getById(int) */public Person getById(intidValue) {// TODO Auto-generated method stubString sql = select * from person where id = + idValue;Statement st;Person person = newPerson();try {st = connection.createStatemen