Java中Admindao是什么_AdminDao.java

package dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.ArrayList;

import dbc.JDBCUtils;

import vo.PetItem;

/**

* 管理员数据访问类

*/

public class AdminDao {

//获取所有数据

public ArrayList queryAllData(){

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

ArrayList list = new ArrayList();

try{

conn = JDBCUtils.getConnection(1);

stmt = conn.createStatement();

String sql = "select number,name,age,count,price from pet";

rs = stmt.executeQuery(sql);

while(rs.next()){

PetItem thisPet = new PetItem(sql, sql, sql, sql, sql);

thisPet.setNumber(rs.getString("number"));

thisPet.setName(rs.getString("name"));

thisPet.setAge(rs.getString("age"));

thisPet.setCount(rs.getString("count"));

thisPet.setPrice(rs.getString("price"));

list.add(thisPet);

}

return list;

}catch(Exception e ){

e.printStackTrace();

}finally{

JDBCUtils.close(conn);

}

return null;

}

//添加数据

public boolean addPetItem(PetItem pet){

Connection conn = null;

PreparedStatement pstmt = null;

boolean result=false;

try{

conn = JDBCUtils.getConnection(1);

String sql = "insert into fruit (number,name,age,count,price) values (?,?,?,?,?)";

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, pet.getNumber());

pstmt.setString(2,pet.getName());

pstmt.setString(3, pet.getAge());

pstmt.setString(4, pet.getCount());

pstmt.setString(5,pet.getPrice());

int num = pstmt.executeUpdate();

if(num > 0){

result = true;

}

}catch(Exception e ){

e.printStackTrace();

}finally{

JDBCUtils.close(conn);

}

return result;

}

//删除数据

public boolean delPetItem(String delNumber){

boolean result=false;

Connection conn = null;

PreparedStatement pstmt = null;

try{

conn = JDBCUtils.getConnection(1);

String sql="delete from pet where number=?";

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, delNumber);

if(pstmt.executeUpdate()>0){

result = true;

}

}catch(Exception e ){

e.printStackTrace();

}finally{

JDBCUtils.close(conn);

}

return result;

}

}

一键复制

编辑

Web IDE

原始数据

按行查看

历史