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 (t足毂忍珩itle,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;} }