多语言展示
当前在线:970今日阅读:183今日分享:45

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

今天小编来给大家介绍一下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 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 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;}  }

推荐信息