java基本的增删改_JAVA数据库基本操作增删改查(精)

JAVA 数据库基本操作, 增删改查

package mypack; JAVA 数据库基本操作, 增删改查

import java.sql.Connection;

import java.sql.ResultSet;

import java.util.ArrayList;

public class DbOper {//查询多行记录public ArrayList select({Connection conn =null;

ResultSet rs =null;

try {import java.sql.PreparedStatement; import java.sql.SQLException; PreparedStatement pstmt =null; ArrayList al =new ArrayList(;

conn =DbConn.getConn(;pstmt =conn.prepareStatement(“select *from titles ”; rs =pstmt.executeQuery(;while (rs.next({Titles t =new

Titles(;t.setTitleid(rs.getString(1;t.setTitle(rs.getString(2;al.add(t;}}catch (SQLExceptione {

e.printStackTrace(;}finally {try {//TODO 自动生成catch 块if (rs!=null rs.close(;if (pstmt!=nullpstmt.close(;if (conn!=nullconn.close(;}catch (SQLExceptione {

e.printStackTrace(;}}//TODO 自动生成catch 块

return al; }//查询单个对象public Titles selectOne(Stringtitleid{Connection conn =null;

ResultSet rs =null;

try {PreparedStatement pstmt =null; Titles t =new Titles(;