JDBC项目案例经典实现

《JDBC项目案例经典实现》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.List;publicclassMain{/***@paramargs*@throws*/publicstaticvoidmain(String[]args){//1加载驱动类try{Clas

2、s.forName("com.mysql.jdbc.Driver");}catch(ClassNotFoundExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}//查询全部的元素Listlist=newArrayList();list=selAllPerson();for(Personp:list){System.out.print(p.getId()+"");System.out.print(p.getName()+"");System.out

3、.print(p.getAge()+"");System.out.println(p.getAddress());}//根据Id地址进行查询操作/**Personp=selPersonById(1);System.out.print(p.getId()+"");*System.out.print(p.getName()+"");*System.out.print(p.getAge()+"");*System.out.println(p.getAddress());*///增加操作/**Personp=newPerson();p.setI

4、d(3);p.setName("zxs");p.setAge(30);*p.setAddress("beijing");addPerson(p);*///删除操作//delPersonById(3);//修改元素（传入P）/**Personp=newPerson();p.setId(3);p.setName("zhuxiaoshuai");*p.setAge(22);p.setAddress("beijing");updatePerson(p);*/}//2创建连接对象，供一下代码使用publicstaticConnectionconn

5、ff(){Connectionconn=null;try{conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javab","root","123456");}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}returnconn;}publicstaticvoidaddPerson(Personp){//insertintopersonvalues(null,'zhang

6、san',10,'anhuihefei')//TODOAuto-generatedmethodstubConnectionconn=null;Statementstmt=null;Stringsql="insertintopersonvalues("+p.getId()+",'"+p.getName()+"',"+p.getAge()+",'"+p.getAddress()+"')";//id不是自增长的时候不是nulltry{conn=connff();stmt=conn.createStatement();stmt.executeU

7、pdate(sql);}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}finally{try{stmt.close();conn.close();}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}}publicstaticvoiddelPersonById(intid){Connectionconn=null;Statementstmt=nul

8、l;Stringsql="deletefrompersonwhereid="+id;try{conn=connff();stmt=conn.createStatement();stmt.executeUpd