My sql数据库的增删改查

来源：互联网发布：手机端电影网站源码编辑：程序博客网时间：2024/04/16 23:55

增：

String insert = "insert into students(Sno,Sname,Ssex,Sage,Scno) value(?,?,?,?,?)";          PreparedStatement sta = con.prepareStatement(insert);          sta.setString(1, "1013");          sta.setString(2, "***");          sta.setString(3, "男");          sta.setInt(4, 20);          sta.setInt(5, 3);          int row=sta.executeUpdate();          if(row==1)          {              System.out.println("插入成功");          }

删：

String delete = "delete from students where Sno='1006'";          PreparedStatement dele = con.prepareStatement(delete);          dele.executeUpdate();

改：

String update = "update students set Sage=21 where Sno='1005'";          PreparedStatement upd = con.prepareStatement(update);          upd.executeUpdate();

查：

//数据库某表的逐条查询          String select = "select * from students";          PreparedStatement sts = con.prepareStatement(select);          ResultSet rs = sts.executeQuery();          System.out.println("学号       "+"姓名    "+"性别     "+"年龄     "+"课程号");          while(rs.next())          {              System.out.print(rs.getString("Sno")+" ");              System.out.print(rs.getString("Sname")+" ");              System.out.print(rs.getString("Ssex")+"    ");              System.out.print(rs.getInt("Sage")+"    ");              System.out.println(rs.getInt("Scno"));          }          //数据库中特定项查询，例如选课程2的同学的信息；          String selectone = "select * from students where Scno=2";          PreparedStatement stso = con.prepareStatement(selectone);          ResultSet reo = stso.executeQuery();          while(reo.next())          {              System.out.print(reo.getString("Sno")+" ");              System.out.print(reo.getString("Sname")+" ");              System.out.print(reo.getString("Ssex")+"    ");              System.out.print(reo.getInt("Sage")+"    ");              System.out.println(reo.getInt("Scno"));          }

0 0