java oop 第十二章宠物商店

DAO层

package cn.happy.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class BaseDao {

Connection con = null;

PreparedStatement ps = null;

public ResultSet rs=null;

private static final String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static final String url = "jdbc:sqlserver://localhost:1433;DatabaseName=PetShop";

private static final String username = "sa";

private static final String pwd = "1";

public Connection getCon()throws Exception{

Class.forName(driver);

if(con==null||con.isClosed()){

con = DriverManager.getConnection(url, username, pwd);

}

return con;

}

//执行查询

public ResultSet executeQuery(String sql,Object... obje) throws Exception{

con=getCon();

ps=con.prepareStatement(sql);

for(int i=0;i<obje.length;i++){

ps.setObject(i+1, obje[i]);

}

rs=ps.executeQuery();

return rs;

}

//测试修改

//执行修改

public int execteUpdate(String sql,Object...object) throws Exception{

con=getCon();

ps=con.prepareStatement(sql);

for(int i=0;i<object.length;i++){

ps.setObject(i+1, object[i]);

}

int count=ps.executeUpdate();

return count;

}

//单测增加

//执行增加

public int execteadd(String sql,Object...object) throws Exception{

con=getCon();

ps=con.prepareStatement(sql);

ps.executeUpdate();

for(int i=0;i<object.length;i++){

ps.setObject(i+1, object[i]);

}

int count=ps.executeUpdate();

return count;

}

//执行删除

//执行删除

public int exectedelete(String sql,Object...object) throws Exception{

con=getCon();

ps=con.prepareStatement(sql);

ps.executeUpdate();

for(int i=0;i<object.length;i++){

ps.setObject(i+1, object[i]);

}

int count=ps.executeUpdate();

return count;

}

public void closeAll() throws Exception{

if(rs!=null){

rs.close();

}

if(ps!=null){

ps.close();

}

if(con!=null){

con.close();

}

}

//

}

package cn.happy.dao;

import java.util.List;

import cn.happy.entity.Pet;

import cn.happy.entity.PetOwner;

public interface Petdao {

public List<Pet> select1() throws Exception;

public List<Pet> se1() throws Exception;

public boolean up(int id) throws Exception;

public List<Pet> poselect(int id) throws Exception;

public List<Pet> selectquan() throws Exception;

Pet getPetById(int id) throws Exception;

int buyPet(int petid,int ownerid) throws Exception;

int sellPet(int storeid,int petid) throws Exception;

public List<Pet> getOwnerPet(int ownerid) throws Exception ;

}

package cn.happy.dao;

import java.util.List;

import cn.happy.entity.Pet;

import cn.happy.entity.PetOwner;

public interface PetOwnerdao {

public List<PetOwner> select2() throws Exception;

public PetOwner DL(String name1) throws Exception;

public boolean update1(int money,int id) throws Exception;

public List<PetOwner> getnamebyid()throws Exception;

public int getIdByName(String name) throws Exception ;

public int updateByName(int money,String name) throws Exception ;

public int updateMoneyByName(int money, String name) throws Exception ;

}

package cn.happy.dao;

import java.util.List;

import cn.happy.entity.PetStore;

public interface PetStoredao {

public List<PetStore> select3() throws Exception;

public PetStore DL(String name1) throws Exception;

}

package cn.happy.dao;

public interface Accountdao {

public boolean add(int id)throws Exception;

int addAccount(int dealtype,int petid,int ownerid) throws Exception;

int addSellAccount(int dealtype,int petid,int ownerid,int storeid) throws Exception;

}

DAO Impl

package cn.happy.Impl;

import cn.happy.dao.Accountdao;

import cn.happy.dao.BaseDao;

public class AccountdaoImpl extends BaseDao implements Accountdao {

@Override

public boolean add(int id) throws Exception {

boolean flag=false;

String sql="insert into Account values(?,?,?)";

int count=this.execteU

相关知识

java oop 第十二章宠物商店
java宠物商店代码
mysql 项目案例宠物商店
java宠物商店项目
java宠物作业 java实训项目宠物商店
Java宠物商店源代码
mysql第十章宠物商店 宠物商店代码
Java宠物商店项目案例分析与实践
1218宠物商店简单设计说明书
宠物商店系统开发教程：Java课设源码解析

网址: java oop 第十二章宠物商店 https://www.mcbbbk.com/newsview808516.html