用JDBC实现对MySQL的“增删改查”

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.bean.NoticeBean;public class JDBCTest {/** * * @param args */public static void main(String[] args) {Connection conn=null;Statement stmt=null;ResultSet rs=null;try {String driverName="com.mysql.jdbc.Driver";Class.forName(driverName);String url="jdbc:mysql://localhost:3306/java?useUnicode=true&characterEncoding=gb2312";conn=DriverManager.getConnection(url,"root","root");System.out.println("连接MySql成功!!!");stmt=null;rs=null;String strSql=null;NoticeBean bean=null;String title=null;String content=null;try {title="标题";content="内容";strSql="INSERT INTO notice(title,content) VALUES('"+title+"','"+content+"')";stmt=conn.createStatement();stmt.executeUpdate(strSql);System.out.println("插入语句执行成功:"+strSql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();System.out.println("插入失败");}strSql="select * from notice";stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);rs=stmt.executeQuery(strSql);if(rs.next()){int id=rs.getInt("id");title =rs.getString("title");content=rs.getString("content");if(rs.next()){bean=new NoticeBean(id,title,content);}System.out.println("notice第一行数据是"+bean.getId()+" "+bean.getTitle()+" "+bean.getContent());}try {strSql="delete from notice";stmt=conn.createStatement();stmt.executeUpdate(strSql);System.out.println("删除完成");} catch (RuntimeException e) {// TODO Auto-generated catch blocke.printStackTrace();System.out.println("删除失败");}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{try {if(rs!=null){rs.close();rs=null;}if(stmt!=null){stmt.close();stmt=null;}if(conn!=null){conn.close();conn=null;}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}