运用Statement技术实现jdbc的增删查该操作（很基础的一种）

首先让大家看一下我定义的Student这个类里面有啥方便大家理解后续代码package JDBC.Bigdata.Student; import java.io.File; public class Student { public int getSno() { return Sno; } public void setSno(int sno) { Sno sno; } public String getSname() { return Sname; } public void setSname(String sname) { Sname sname; } public String getSsex() { return Ssex; } public void setSsex(String ssex) { Ssex ssex; } public String getSc() { return sc; } public void setSc(String sc) { this.sc sc; } public int getSage() { return Sage; } public void setSage(int sage) { Sage sage; } Override public String toString() { return Student{ Sno Sno , Sname Sname \ , Ssex Ssex \ , sc sc \ , Sage Sage }; } public Student(int sno) { Sno sno; } private int Sno; private String Sname; public Student(int sno, int sage) { Sno sno; Sage sage; } private String Ssex; private String sc; private int Sage; public File getContext() { return context; } public void setContext(File context) { this.context context; } public Student(int sno, String sname, String ssex, String sc, int sage, File context) { Sno sno; Sname sname; Ssex ssex; this.sc sc; Sage sage; this.context context; } private File context; private File pic; public Student(int sno, String sname, String ssex, String sc, int sage, File context, File pic) { Sno sno; Sname sname; Ssex ssex; this.sc sc; Sage sage; this.context context; this.pic pic; } public File getPic() { return pic; } public void setPic(File pic) { this.pic pic; } public Student(int sno, String sname, String ssex, String sc, int sage) { Sno sno; Sname sname; Ssex ssex; this.sc sc; Sage sage; } }这里面Studnet里面都是些很基础的代码像什么构造了tostring了一键可以直接出来这就不过多叙述了。package JDBC.Bigdata.test; import JDBC.Bigdata.util.dbutil; import java.sql.Connection; import java.sql.Statement; public class insert { public static void main(String[] args) throws Exception{ dbutil dbUtilnew dbutil(); String sqlinsert into student values(50,小垃圾,男,cs,18); Connection condbUtil.getCon(); Statement stmtcon.createStatement(); int result stmt.executeUpdate(sql);//这个操作完是一个int类型的数据可以用一个int来接受这个数据看操作了几条 System.out.println(操作了result条数据); stmt.close(); con.close(); } }上面的这个代码就是所谓的增了。还是以前最基础的加上这个Statement来处理sql语句就行了不懂最基础的可以参考我的那篇文章https://blog.csdn.net/renhuoyishi99/article/details/95939160这个文章会对你有帮助的。接下来是删除操作了。package JDBC.Bigdata.test; import JDBC.Bigdata.Student.Student; import JDBC.Bigdata.util.dbutil; import java.sql.Connection; import java.sql.Statement; public class delete { public static int del(Student student)throws Exception { String sqldelete from student where Snostudent.getSno(); dbutil dbUtilnew dbutil(); Connection condbUtil.getCon(); Statement stmtcon.createStatement(); int resultstmt.executeUpdate(sql); return result; } public static void main(String[] args)throws Exception { Student studentnew Student(50); int resultdel(student); if(result1) { System.out.println(操作成功); } else { System.out.println(操作失败); } } }这其实和增差不多一样。不同的就是我造了一个Student这个类型的一个对象并传了值。到上面可以直接搞出来就是所谓的get函数吗。增删查改其实就是sql语句不同我就不过多的阐述了代码给大家大家随意看看理解下吧其实Statement这个还是有弊端的一般不建议大家使用我们用的一般是preparedStatement这个更好更方便有兴趣可以看我的下篇博客https://blog.csdn.net/renhuoyishi99/article/details/100181419。接下来是查和改的代码了。查的我没找到哈哈哈真尴尬你们自己打下吧就是sql语句不同自己钻研下加油package JDBC.Bigdata.test; import JDBC.Bigdata.Student.Student; import JDBC.Bigdata.util.dbutil; import java.sql.Connection; import java.sql.Statement; public class update { public static int up(Student student)throws Exception { String sqlupdate student set Sage0 where Snostudent.getSno(); dbutil dbUtilnew dbutil(); Connection condbUtil.getCon(); Statement stmtcon.createStatement(); int resultstmt.executeUpdate(sql); dbUtil.dbClose(con,stmt); return result; } public static void main(String[] args)throws Exception { Student studentnew Student(20); int resultup(student); if(result1) { System.out.println(操作成功); } else { System.out.println(操作失败); } } }