怎样编写一个java程序能通过jdbc访问数据库实现对数据库的插入、删除、修改和查询？

1.增加\x0d\x0aString s1="insert into tableNames (id,name,password) values(myseq.nextval,?,?)"\x0d\x0aClass.forName(driver)\x0d\x0aConnection conn = DriverManager.getConnection(url,dbUser,dbPwd)\x0d\x0aPreparedStatement prepStmt = conn.prepareStatement(s1)\x0d\x0aprepStmt.setString(1,name)\x0d\x0aprepStmt.setString(2,password)\x0d\x0aResultSet rs=stmt.executeUpdate()\x0d\x0a2、删除\x0d\x0aString s2="delete from tbNames where name=?"\x0d\x0aClass.forName(driver)\x0d\x0aConnection conn = DriverManager.getConnection(url,dbUser,dbPwd)\x0d\x0aPreparedStatement prepStmt = conn.prepareStatement(s2)\x0d\x0aprepStmt.setString(1,name)\x0d\x0aResultSet rs=stmt.executeUpdate()\x0d\x0a3、修改\x0d\x0aString s3=“update tbNames set name=? where id=?”\x0d\x0aClass.forName(driver)\x0d\x0aConnection conn = DriverManager.getConnection(url,dbUser,dbPwd)\x0d\x0aPreparedStatement prepStmt = conn.prepareStatement(s3)\x0d\x0aprepStmt.setString(1,name)\x0d\x0aprepStmt.setString(2,id)\x0d\x0aResultSet rs=stmt.executeUpdate()\x0d\x0a4、查询\x0d\x0aString s4="select id,name,password from tbNames"\x0d\x0aClass.forName(driver)\x0d\x0aConnection conn = DriverManager.getConnection(url,dbUser,dbPwd)\x0d\x0aStatement stmt=conn.createStatement()\x0d\x0aResultSet rs = stmt.executeQuery(s4)\x0d\x0awhile(rs.next){\x0d\x0aint id=rs.getInt(1)\x0d\x0aString name = rs.getString(2)\x0d\x0aString pwd=rs.getString(3)\x0d\x0aSystem.out.println(id+name+pwd)} \x0d\x0a\x0d\x0a以上四步必须都得关闭连接；！！！\x0d\x0ars.close()\x0d\x0astmt.close()\x0d\x0aconn.close()

1.增加

String s1="insert into tableNames (id,name,password) values(myseq.nextval,?,?)"

Class.forName(driver)

Connection conn = DriverManager.getConnection(url,dbUser,dbPwd)

PreparedStatement prepStmt = conn.prepareStatement(s1)

prepStmt.setString(1,name)

prepStmt.setString(2,password)

ResultSet rs=stmt.executeUpdate()

2、删除

String s2="delete from tbNames where name=?"

Class.forName(driver)

Connection conn = DriverManager.getConnection(url,dbUser,dbPwd)

PreparedStatement prepStmt = conn.prepareStatement(s2)

prepStmt.setString(1,name)

ResultSet rs=stmt.executeUpdate()

3、修改

String s3=“update tbNames set name=? where id=?”

Class.forName(driver)

Connection conn = DriverManager.getConnection(url,dbUser,dbPwd)

PreparedStatement prepStmt = conn.prepareStatement(s3)

prepStmt.setString(1,name)

prepStmt.setString(2,id)

ResultSet rs=stmt.executeUpdate()

4、查询

String s4="select id,name,password from tbNames"

Class.forName(driver)

Connection conn = DriverManager.getConnection(url,dbUser,dbPwd)

Statement stmt=conn.createStatement()

ResultSet rs = stmt.executeQuery(s4)

while(rs.next){

int id=rs.getInt(1)

String name = rs.getString(2)

String pwd=rs.getString(3)

System.out.println(id+name+pwd)}

以上四步必须都得关闭连接；！！！

rs.close()

stmt.close()

conn.close()

---