JS如何实现数据库数据更新

1、首先创建News，然后实现其中方法

package cn.hpu.model;public class News {    private int id;    private String title;    private String context;public int getId() {return id;}

2、public void setId(int id) {this.id = id;}public String getTitle() {return title;}public void setTitle(String title) {this.title = title;}

3、public String getContext() {return context;}public void setContext(String context) {this.context = context;}    }

然后创建操作接口

package cn.hpu.service;import cn.hpu.model.News;

4、import java.util.List;public interface NewsMa {    public List<News> getNews();        public boolean add(News news);}

实现接口中的方法

package cn.hpu.service;import java.sql.Connection;import java.sql.PreparedStatement;import java.util.List;

5、import cn.hpu.model.News;import cn.hpu.util.DBO;public class NewsMaImpl implements NewsMa{public List<News> getNews() {// TODO Auto-generated method stubreturn null;}public boolean add(News news) {return true;}  }

6、链接数据库

package cn.hpu.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;static{ try {Class.forName(DBDRIVER);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}}

7、创建登陆页面并实现验证。此处省略

     实现添加的时候别忘了接口add里面的

public boolean add(News news) {// TODO Auto-generated method stubboolean flag=false;Connection conn=null;PreparedStatement pst =null;try {

8、conn=DBO.getConnection();String sql=("insert into news (title,context) value(?,?)");pst=conn.prepareStatement(sql);pst.setString(1,news.getTitle());pst.setString(2, news.getContext());int rows=pst.executeUpdate();if(rows>0){flag=true;}} catch (Exception e) {// TODO: handle exception}finally{DBO.close(pst, conn);}return flag;}  }