rmarket bill management system improves the work efficiency, save a lot of time.
Keywords: java ,Servlet,PL/SQL,jsp,oracle,Supermarket bill management system
致 谢
在这里我要感谢我的导师周琼,从论文的选题到定稿的过程都是周老师的帮助和严格要求。
在Java学习中,每次遇到困难,导师和同学都会鼓励我,给我开导,给我很大帮助,也给我很大信心。在导师和同学的帮助下,让我顺利完成我的毕业设计。
从那以后我有了自信,有了希望。有的错误他也不能解决,我只好硬着头皮,去钻研,终于我成功,我很开心。他不仅教会如何自信,还让我学会如何利用网上的知识。我比以前更自信,更强大了。我非常感谢我的导师和同学,还要感谢那些为我默默付出的人。
附录1
登录代码:
账单表Dao层:
public class BillDaoImpl extends BaseDao implements BillDao{
private List
getBillsBySql(String sql,Object...args){
List list =new ArrayList();
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs =null;
conn=getConn();
try {
pstmt=conn.prepareStatement(sql);
if(args!=null||args.length>0){
for(int i=0;i pstmt.setObject(i+1, args[i]);
}
}
rs=pstmt.executeQuery();
while (rs.next()) {
Bill bill=new Bill();
bill.setBillnum(rs.getInt("BILLNUM"));
bill.setBillno(rs.getInt("BILLNO"));
bill.setBillname(rs.getString("BILLNAME"));
bill.setBillmoney(rs.getDouble("BILLMONEY"));
bill.setBillnumber(rs.getInt("BILLNUMBER"));
bill.setBillpay(rs.getInt("BILLPAY"));
bill.setBilltime(rs.getTimestamp("BILLTIME"));
bill.setGoods(rs.getString("GOODS"));
bill.setProvidid(rs.getInt("PROVIDID"));
if(existColumn(rs, "PROVIDERNAME")){
bill.setProvidername(rs.getString("PROVIDERNAME"));
}
bill.setBilldanwei(rs.getString("BILLDANWEI"));
list.add(bill);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeAll(rs,pstmt,conn);
}
return list;
}
public List getAllBill(){
String sql="select * from tt_bill";
return getBillsBySql(sql);
}
public List getBillsByPage(Pager pager,Bill condition) {
String sql = "select t1.* from (select b.*,p.providername,rownum rn from tt_bill b inner join tt_provider p on b.providid = p.providerno where rownum <= ? ";
String conditionSql = "";
if(condition != null){
if(condition.getBillname()!=null&& !"".equals(condition.getBillname().trim())){
conditionSql+="and billname like '%"+condition.getBillname().trim()+"%'";
}
if(condition.getBillpay()!=0){
conditionSql+="and billpay = "+condition.getBillpay();
}
}
sql += conditionSql;
sql +=") t1 where t1.rn > ?";
List list = getBillsBySql(sql, pager.getCurrentPage() * pager.getPageSize(),
(pager.getCurrentPage() - 1) * pager.getPageSize());
String countSql = "select count(*) from tt_bill where 1=1 " + conditionSql;
pager.setTotalCount(getCount(countSql));
return list;
}
public int getCount(String sql){
int row = 0; //返回的条数
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = getConn();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()){
row = rs.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
closeAll(rs, pstmt, conn);
}
return row;
}
public Bill getBillByBillno(int billno) {
String sql="select * from tt_bill where billno=?";
List list=getBillsBySql(sql,billno);
return list!=null && list.size()>0?list.get(0):null;
}
public int deleteBill(int billno){
String sql="delete from tt_bill where billno=?";
return super.executeSQL(sql, billno);
}
public int updateBill(Bill bill){
String sql="update tt_bill set billnum=?,billname=?,billnumber=?,billmoney=?,billpay=?,providid=?,goods=? ,billdanwei=? where billno=?";
return super.executeSQL(sql,bill.getBillnum(),bill.getBillname(),bill.getBillnumber(),bill.getBillmoney(),bill.getBillpay(),bill.getProvidid(),bill.getGoods(),bill.getBilldanwei(),bill.getBillno());
}
public int addBill(Bill bill){
String sql="insert into tt_bill values(seq_user.nextval,?,?,?,?,?,?,sysdate,?,?)";
return super.executeSQL(sql,bill.getBillname(),bill.getBillnumber(),bill.getBillmoney(),bill.getBillpay(),bill.getProvidid(),bill.getGoods(),bill.getBilldanwei(), bill.getBillnum());
}
public Bill getBillByProvidid(int providid){
String sql="select * from tt_bill where providid=?";
List list=getBillsBySql(sql,providid);
return list!=null && list.size()>0?list.get(0):null;
}
public Bill getBillByBillnum(int billnum){
String sql="select * from tt_bill where billnum=?";
List list=getBillsBySql(sql,billnum);
return list!=null&& list.size()>0?list.get(0):null;
}
}
供应商表dao层
public class ProviderDaoImpl extends BaseDao implements ProviderDao{
private List getProvidersBySql(String sql,Object...args){
List list=new ArrayList();
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs =null;
conn=getConn();
try {
pstmt=conn.prepareStatement(sql);
if(args!=null||args.length>0){
for(int i=0;i pstmt.setObject(i+1, args[i]);
}
}
rs=pstmt.executeQuery();
while (rs.next()) {
Provider provider=new Provider();
provider.setProviderfax(rs.getString("PROVIDERFAX"));
provider.setProvideraddress(rs.getString("PROVIDERADDRESS"));
provider.setProviderdescript(rs.getString("PROVIDERDESCRIPT"));
provider.setProvidername(rs.getString("PROVIDERNAME"));
provider.setProviderno(rs.getInt("PROVIDERNO"));
provider.setProvidertel(rs.getString("PROVIDERTEL"));
provider.setProvideruser(rs.getString("PROVIDERUSER"));
provider.setProvidernum(rs.getInt("PROVIDERNUM"));
list.add(provider);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeAll(rs,pstmt,conn);
}
return list;
}
public List getAllProviders(){
String sql="select * from tt_provider ";
return getProvidersBySql(sql);
}
public List getProvidersByPage(Pager pager,Provider condition) {
String sql = "select * from (select t1.*,rownum rn from tt_provider t1 where rownum <=? ";
String conditionSql = "";
if(condition != null){
if(condition.getProvidername()!= null && !"".equals(condition.getProvidername().trim())){
conditionSql += " and providername like '%"+condition.getProvidername().trim()+"%'";
}
if(condition.getProviderdescript()!= null && !"".equals(condition.getProviderdescript().trim())){
conditionSql += " and providerdescript like '%"+condition.getProviderdescript().trim()+"%'";
}
}
sql += conditionSql;
sql +=") t2 where t2.rn > ?";
List list = getProvidersBySql(sql, pager.getCurrentPage() * pager.getPageSize(),
(pager.getCurrentPage() - 1) * pager.getPageSize());
String countSql = "select count(*) from tt_provider where 1=1 " + conditionSql;
pager.setTotalCount(getCount(countSql));
return list;
}
public int getCount(String sql){
int row = 0; //返回的条数
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = getConn();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()){
row = rs.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
closeAll(rs, pstmt, conn);
}
return row;
}
public int addProvider(Provider provider){
String sql="insert into tt_provider values(seq_user.nextval,?,?,?,?,?,?,?)";
return super.executeSQL(sql, provider.getProvidername(),provider.getProviderdescript(),provider.getProvideruser(),provider.getProvidertel(),provider.getProvideraddress(),provider.getProviderfax(),provider.getProvidernum());
}
public Provider getProviderByProviderno(int providerno){
String sql="select * from tt_provider where providerno=?";
List list=getProvidersBySql(sql,providerno);
return list!=null && list.size()>0?list.get(0):null;
}
public int updateProvider(Provider provider){
String sql="update tt_provider set providernum=?,providername=?,providertel=?,provideruser=?,providerdescript=?,providerfax=?,provideraddress=? where providerno=?" ;
return super.executeSQL(sql,provider.getProvidernum() ,provider.getProvidername(),provider.getProvidertel(),provider.getProvideruser(),provider.getProviderdescript(),provider.getProviderfax(),provider.getProvideraddress(),provider.getProviderno());
}
public int deleteProvider(int providerno){
String sql="delete from tt_provider where providerno=?";
return super.executeSQL(sql, providerno);
}
public Provider getProviderByProvidernum(int providernum){
String sql="select * from tt_provider where providernum=?";
List list=getProvidersBySql(sql,providernum);
return list!=null && list.size()>0?list.get(0):null;
}
}
用户表dao层
public class UserDaoImpl extends BaseDao implements UserDao{
private List getUsersBySql(String sql,Object...args){
List list=new ArrayList();
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs =null;
conn=getConn();
try {
pstmt=conn.prepareStatement(sql);
if(args!=null||args.length>0){
for(int i=0;i pstmt.setObject(i+1, args[i]);
}
}
rs=pstmt.executeQuery();
while (rs.next()) {
User item = new User();
item.setUserid(rs.getInt("USERID"));
item.setUsername(rs.getString("USERNAME"));
item.setPassword(rs.getString("PASSWORD"));
item.setUserno(rs.getInt("USERNO"));
item.setUsersex(rs.getInt("USERSEX"));
item.setUserage(
上一篇:高校学生综合测评系统设计与实现