今天小编来给大家介绍一下JS如何实现数据库数据更新
方法/步骤
1、首先创建News,然后实现其中方法packagecn.hpu.model;publicclassNews{privateintid;privateStringtitle;privateStringcontext;publicintgetId(){returnid;}
2、publicvoidsetId(intid){this.id=id;}publicStringgetTitle(){returntitle;}publicvoidsetTitle(Stringtitle){this.title=title;}
3、publicStringgetContext(){returncontext;}publicvoidsetContext(Stringcontext){this.context=context;}}然后创建操作接口packagecn.hpu.service;importcn.hpu.model.News;
4、importjava.util.List;publicinterfaceNewsMa{publicList<News>getNews();publicbooleanadd(Newsnews);}实现接口中的方法packagecn.hpu.service;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.util.List;
5、importcn.hpu.model.News;importcn.hpu.util.DBO;publicclassNewsMaImplimplementsNewsMa{publicList<News>getNews(){//TODOAuto-generatedmethodstubreturnnull;}publicbooleanadd(Newsnews){returntrue;}}
6、链接数据库packagecn.hpu.util;import咯悝滩镞java.sql.Connection;importjava.sql.DriverManager稆糨孝汶;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;static{try{Class.forName(DBDRIVER);}catch(ClassNotFoundExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}
7、创建登陆页面并实现验证。此处省略实现添加的时候别忘了接口add里面的publicbooleanadd(Newsnews){//TODOAuto-generatedmethodstubbooleanflag=false;Connectionconn=null;PreparedStatementpst=null;try{
8、conn屏顿幂垂=DBO.getConnection();Stringsql=("insertintonews(t足毂忍珩itle,context)value(?,?)");pst=conn.prepareStatement(sql);pst.setString(1,news.getTitle());pst.setString(2,news.getContext());introws=pst.executeUpdate();if(rows>0){flag=true;}}catch(Exceptione){//TODO:handleexception}finally{DBO.close(pst,conn);}returnflag;}}