java 数据库 操作_Java简单数据库操作

importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.List;importjava.util.Vector;public classDbOperation {private static DbOperation instance = null;public static DbOperation getInstance() { //返回DbOperation类实例的静态方法,单例模式！！！！

if (instance == null) {

instance= newDbOperation();

}returninstance;

}public boolean addTbNews(TbNews tns) { //添加数据方法

Connection conn=null;boolean result=false;try{

conn=DbTool.getConn(); //建立与数据库的连接

String sqlInsert="INSERT INTO tbNews(topicId,contentTxt)VALUES(?,?)";

PreparedStatement stm=conn.prepareStatement(sqlInsert);

stm.setString(1, tns.getTopicId());

stm.setString(2, tns.getContentTxt());int i=stm.executeUpdate();if (i==1) {

result=true;

}

}catch(SQLException e) {

e.printStackTrace();

}finally{try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}returnresult;

}public Vector queryTbNews(){ //返回Vector类型方式查询数据

Vector list =new Vector();

Connection conn=null;try{

conn=DbTool.getConn();

Statement stmt=conn.createStatement();

String querySql="select * from TbNews";

ResultSet rs=stmt.executeQuery(querySql);while(rs.next()) {

TbNews tbs=newTbNews();

tbs.setTopicId(rs.getString(1));

tbs.setContentTxt(rs.getString(2));

list.add(tbs);

}

}catch(Exception e) {

e.printStackTrace();

}finally{try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}returnlist;

}public List selectTbNews(){ //查询数据方法

List tbsList=new ArrayList();

Connection conn=null;try{

conn=DbTool.getConn();

Statement stmt=conn.createStatement();

String selectSql="select * from TbNews";

ResultSet rs=stmt.executeQuery(selectSql); //执行SQL并返回结果集

while(rs.next()) {

String tbs=rs.getString("topicId")+","+rs.getString("contentTxt");

tbsList.add(tbs);

}

}catch(Exception e) {

e.printStackTrace();

}finally{try{

conn.close();//关闭连接

}catch(SQLException e) {

e.printStackTrace();

}

}returntbsList;

}

}