Jdbc单表 增删改查 通用的操作 整理

          Jdbc增删改查

1. 增

              Connection conn = null;

              PreparedStatement ps = null;

              try {

                     Class.forName("com.mysql.jdbc.Dirver");

                     conn = DriverManager.getConnection(

                                   "jdbc:mysql://localhost:3306/数据库名", "root", "");

                     ps = conn.prepareStatement("insert into 表名vaues(?,?)");

                     ps.setInt(1,值);

                     ps.setString(2,"值");

                     int n = ps.executeUpdate();//增删改用executeUpdate() 方法

                     if (n > 0) {

                            System.out.println("添加成功");

                     }

              } catch (Exception e) {

                     e.printStackTrace();

              } finally {

                     try {

if(ps!=null)