1、以下所說的包名可根據需要自行決定，只要把相關代碼中的包名改成你自己設計的包名即可javabean包代碼如下：（包名：daofactory）clientbeanpackage org.hzb.daofactory;public class clientbean private int id; private string kname; private string kshort; private string kaddress; private string kpost; private string ktel; private string kfax; private string kconn

2、ect; private string kconnecttel; private string kemail; private string kbank; private string kbanknum; public int getid() return id;public void setid(int id) this.id = id;public string getkname() return kname;public void setkname(string kname) this.kname = kname;public string getkshort() return ksho

3、rt;public void setkshort(string kshort) this.kshort = kshort;public string getkaddress() return kaddress;public void setkaddress(string kaddress) this.kaddress = kaddress;public string getkpost() return kpost;public void setkpost(string kpost) this.kpost = kpost;public string getktel() return ktel;p

4、ublic void setktel(string ktel) this.ktel = ktel;public string getkfax() return kfax;public void setkfax(string kfax) this.kfax = kfax;public string getkconnect() return kconnect;public void setkconnect(string kconnect) this.kconnect = kconnect;public string getkconnecttel() return kconnecttel;publi

5、c void setkconnecttel(string kconnecttel) this.kconnecttel = kconnecttel;public string getkemail() return kemail;public void setkemail(string kemail) this.kemail = kemail;public string getkbank() return kbank;public void setkbank(string kbank) this.kbank = kbank;public string getkbanknum() return kb

6、anknum;public void setkbanknum(string kbanknum) this.kbanknum = kbanknum;daofactory;package org.hzb.daofactory;import java.sql.connection;import java.sql.drivermanager;import java.sql.resultset;import java.sql.sqlexception;import java.sql.statement;import java.util.arraylist;import java.util.list;/*

7、 * author administrator *和數據庫進行交互 */public class daofactory private int id;private static string url=jdbc:mysql:/localhost:3306/csdn_crm;/提供數據庫連接的urlprivate static string user=root;/提供數據庫連接的用戶名private static string password=root;/提供數據庫連接的密碼private static connection getconnection() connection conn=nu

8、ll;try class.forname(com.mysql.jdbc.driver);conn=drivermanager.getconnection(url, user, password); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace(); catch (classnotfoundexception e) / todo auto-generated catch blocke.printstacktrace();return conn;/* * 根據用戶名和密碼驗證數據庫是否存在該用戶

9、* param user * return */public static usersbean checkuser(usersbean user)usersbean userbean=new usersbean();statement st=null;resultset rs=null;connection conn=getconnection ();try st=conn.createstatement();rs=st.executequery(select * from users where username = + user.getusername()+ and password =

10、+ user.getpassword() + );while (rs.next()userbean=new usersbean();string name=rs.getstring(username);string password=rs.getstring(password);int state=rs.getint(state);userbean.setusername(name);userbean.setpassword(password);userbean.setstate(state); catch (sqlexception e) / todo auto-generated catc

11、h blocke.printstacktrace(); finallyif(rs!=null);try rs.close(); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();if(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexception

12、e2) / todo auto-generated catch blocke2.printstacktrace();return userbean;/* * 添加客戶信息 */public static boolean insertinfo(clientbean client)clientbean clientbean=new clientbean();statement st=null;int i = 0;resultset rs=null;connection conn=getconnection ();try st=conn.createstatement();i=st.executeu

13、pdate(insert into khtable (kname,kshort,kaddress,kpost,ktel,kfax,kconnect,kconnecttel,kemail,kbank,kbanknum)values(+client.getkname()+,+client.getkshort()+,+client.getkaddress()+,+client.getkpost()+,+client.getktel()+,+client.getkfax()+,+client.getkconnect()+,+client.getkconnecttel()+,+client.getkem

14、ail()+,+client.getkbank()+,+client.getkbanknum()+); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();finallyif(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexception e2) /

15、 todo auto-generated catch blocke2.printstacktrace();if(i!=0)return true;elsereturn false;/* * 查詢客戶表中所有數據 */public static list selectall()connection conn=null;statement st=null;resultset rs=null;conn=getconnection();list vc=new arraylist();clientbean client=null;try st=conn.createstatement();rs=st.e

16、xecutequery(select *from khtable);while(rs.next()client=new clientbean();client.setid(rs.getint(id);string clienttext=rs.getstring(kname);client.setkname(clienttext);string shorttext=rs.getstring(kshort);client.setkshort(shorttext);string addresstext=rs.getstring(kaddress);client.setkaddress(address

17、text);string posttext=rs.getstring(kpost);client.setkpost(posttext);string teltext=rs.getstring(ktel); client.setktel(teltext);string faxtext=rs.getstring(kfax);client.setkfax(faxtext);string concattext=rs.getstring(kconnect);client.setkconnect(concattext);string concatteltext=rs.getstring(kconnectt

18、el);client.setkconnecttel(concatteltext);string emailtext=rs.getstring(kemail);client.setkemail(emailtext);string banktext=rs.getstring(kbank);client.setkbank(banktext);string banknumtext=rs.getstring(kbanknum);client.setkbanknum(banknumtext);vc.add(client); catch (sqlexception e) / todo auto-genera

19、ted catch blocke.printstacktrace();finallyif(rs!=null);try rs.close(); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();if(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexc

20、eption e2) / todo auto-generated catch blocke2.printstacktrace();return vc;/* * 按客戶id找尋信息 * */public static clientbean findbyid(int id)clientbean cli = new clientbean();connection conn=null;statement st=null;resultset rs = null;conn=getconnection();/int i=0;try st=conn.createstatement();rs =st.execu

21、tequery(select * from khtable where id=+id+); while(rs.next()/cli = new clientbean();cli.setid(rs.getint(id);cli.setkname(rs.getstring(kname);cli.setkshort(rs.getstring(kshort);cli.setkaddress(rs.getstring(kaddress);cli.setkpost(rs.getstring(kpost);cli.setktel(rs.getstring(ktel);cli.setkfax(rs.getst

22、ring(kfax);cli.setkconnect(rs.getstring(kconnect);cli.setkconnecttel(rs.getstring(kconnecttel);cli.setkemail(rs.getstring(kemail);cli.setkbank(rs.getstring(kbank);cli.setkbanknum(rs.getstring(kbanknum); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();finallyif(rs!=null)tr

23、y rs.close(); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();if(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexception e2) / todo auto-generated catch blocke2.printstack

24、trace(); return cli;/* * 修改客戶信息 */public static boolean updateinfo(clientbean client)connection conn=null;statement st=null;/resultset rs=null;int i=0;conn=getconnection();try st=conn.createstatement();i=st.executeupdate(update khtable set kname=+client.getkname()+,kshort=+client.getkshort()+,kaddre

25、ss=+client.getkaddress()+,kpost=+client.getkpost()+,ktel=+client.getktel()+,kfax=+client.getkfax()+,connect=+client.getkconnect()+,kconnecttel=+client.getkconnecttel()+,kemail=+client.getkemail()+,kbank=+client.getkbank()+,kbanknum=+client.getkbanknum()+ where id =+client.getid(); catch (sqlexceptio

26、n e) / todo auto-generated catch blocke.printstacktrace(); if(i!=0)return true;elsereturn false;/* * 刪除客戶信息 */public static boolean deletebyid (int id )connection conn=null;statement st=null;conn=getconnection();int i=0;try st=conn.createstatement();i=st.executeupdate(delete from khtable where id=+i

27、d+); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();finallyif(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexception e2) / todo auto-generated catch blocke2.printstacktr

28、ace();if(i!=0)return true;elsereturn false;/* * 檢索客戶 */public static list kh_checkclient(clientbean client)statement st=null;resultset rs=null;connection conn=getconnection();list list=new arraylist(); clientbean clientbean=null;try st=conn.createstatement();rs=st.executequery(select * from khtable

29、where kname=+client.getkname()+and kconnect=+client.getkconnect()+ );while(rs.next()client=new clientbean();client.setid(rs.getint(id);client.setkname(rs.getstring(kname);client.setkshort(rs.getstring(kshort);client.setkaddress(rs.getstring(kaddress);client.setkpost(rs.getstring(kpost);client.setkte

30、l(rs.getstring(ktel);client.setkfax(rs.getstring(kfax);client.setkconnect(rs.getstring(kconnect);client.setkconnecttel(rs.getstring(kconnecttel);client.setkemail(rs.getstring(kemail);client.setkbank(rs.getstring(kbank);client.setkbanknum(rs.getstring(kbanknum);list.add(client); catch (sqlexception e

31、) / todo auto-generated catch blocke.printstacktrace();finallyif(rs!=null)try rs.close(); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();if(st!=null)try st.close(); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace(); return list;/* * 添加供應商信息 * */

32、public static boolean insertproviderinfo(providerbean provider)providerbean providerbean=new providerbean();statement st=null;int i = 0;/resultset rs=null;connection conn=getconnection ();try st=conn.createstatement();i=st.executeupdate(insert into gystable (gname,gshort,gaddress,gpost,gtel,gfax,gco

33、nnect,gconnecttel,gbank,gemail)values(+provider.getgname()+,+provider.getgshort()+,+provider.getgaddress()+,+provider.getgpost()+,+provider.getgtel()+,+provider.getgfax()+,+provider.getgconnect()+,+provider.getgconnecttel()+,+provider.getgbank()+,+provider.getgemail()+); catch (sqlexception e) / tod

34、o auto-generated catch blocke.printstacktrace();finallyif(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexception e2) / todo auto-generated catch blocke2.printstacktrace();if(i!=0)return true;elseret

35、urn false;/* * 查詢供應商表中所有數據 */public static list selecprovidertall()connection conn=null;statement st=null;resultset rs=null;conn=getconnection();list vc=new arraylist();providerbean client=null;try st=conn.createstatement();rs=st.executequery(select *from gystable);while(rs.next()client=new provider

36、bean();client.setid(rs.getint(id);string clienttext=rs.getstring(gname);client.setgname(clienttext);string shorttext=rs.getstring(gshort);client.setgshort(shorttext);string addresstext=rs.getstring(gaddress);client.setgaddress(addresstext);string posttext=rs.getstring(gpost);client.setgpost(posttext

37、);string teltext=rs.getstring(gtel); client.setgtel(teltext);string faxtext=rs.getstring(gfax);client.setgfax(faxtext);string concattext=rs.getstring(gconnect);client.setgconnect(concattext);string concatteltext=rs.getstring(gconnecttel);client.setgconnecttel(concatteltext);string emailtext=rs.getst

38、ring(gemail);client.setgemail(emailtext);string banktext=rs.getstring(gbank);client.setgbank(banktext);vc.add(client); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();finallyif(rs!=null);try rs.close(); catch (sqlexception e) / todo auto-generated catch blocke.printstackt

39、race();if(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexception e2) / todo auto-generated catch blocke2.printstacktrace();return vc;/* * 根據供應商id查詢相關信息 * param id * return */public static providerbe

40、an findproviderbyid(int id)providerbean cl=new providerbean();connection conn=null;statement st=null;resultset rs = null;conn=getconnection();try st=conn.createstatement();rs=st.executequery(select *from gystable where id=+id+);while(rs.next()cl.setid(rs.getint(id);cl.setgname(rs.getstring(gname);cl

41、.setgshort(rs.getstring(gshort);cl.setgpost(rs.getstring(gpost);cl.setgaddress(rs.getstring(gaddress);cl.setgtel(rs.getstring(gtel);cl.setgfax(rs.getstring(gfax);cl.setgconnect(rs.getstring(gconnect);cl.setgconnecttel(rs.getstring(gconnecttel);cl.setgbank(rs.getstring(gbank);cl.setgemail(rs.getstrin

42、g(gemail); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();finallyif(rs!=null)try rs.close(); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();if(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktra

43、ce();if(conn!=null);try conn.close(); catch (sqlexception e2) / todo auto-generated catch blocke2.printstacktrace();return cl; /* * 刪除供應商信息 * param id * return */public static boolean deleteproviderbyid(int id)connection conn=null;statement st=null;conn=getconnection();int i=0;try st=conn.createstat

44、ement();i=st.executeupdate(delete from gystable where id=+id+); catch (sqlexception e) / todo auto-generated catch blocke.printstacktrace();finallyif(st!=null);try st.close(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();if(conn!=null);try conn.close(); catch (sqlexc

45、eption e2) / todo auto-generated catch blocke2.printstacktrace();if(i!=0)return true;elsereturn false; /* * 修改供應商信息 */public static boolean updateproviderinfo(providerbean client)connection conn=null;statement st=null;/resultset rs=null;int i=0;conn=getconnection();try st=conn.createstatement();i=st.executeupdate(update gystable set gname=+client.getgname()+,gshort=+client.getgshort()+,gaddress=+client.getgaddress()+,gpost=+client.getgpost()+,gtel=+client.getgtel()+,gfax=+client.getgfax()+,gconnect=+client.getgconnect()+,gconnecttel=+client.getgc