java增删改查,包括存储过程插入

1、importimportimportimportimportimportimportimportimportclass Student implements Serializable private static final long serialVersionUIDint no;String name;String sex;int age;public Student( super(;public Student(int no, String name, String sex, int age super(;this.no = no; = name;this.sex = s

2、ex;this.age = age;public int getNo( return no;public void setNo(int no this.no = no;public String getName( return name;public void setName(String name = name;public String getSex( return sex;public void setSex(String sex this.sex = sex;public int getAge( return age;public void setAge(int a

3、ge this.age = age;public static long getSerialVersionUID( return serialVersionUID;interface StudentDao public int insert(Student stu;public void insert_proc(Student stu; /调用存储过程public ArrayList queryAll(; abstract class StudentDaoImpl implements StudentDao public int insert1(Student stuConnection co

4、nn=DBUtil.getNewConnection(;PreparedStatement pstmt=null;int count=-1;try pstmt=conn.prepareStatement(insert into Student valeus(?,?,?,?;pstmt.setInt(1, stu.getNo(;pstmt.setString(2, stu.getName(;pstmt.setString(3, stu.getSex(;pstmt.setInt(4, stu.getAge(;count=pstmt.executeUpdate(; catch (SQLExcepti

5、on e e.printStackTrace(; finallyDBUtil.close(pstmt;DBUtil.close(conn;return count;public void insert_proc(Student stu Connection conn=DBUtil.getNewConnection(;CallableStatement call=null;try call=conn.prepareCall(call proc_insert(?,?,?,?;call.setInt(1, stu.getNo(;call.setString(2, stu.getName(;call.

6、setString(3, stu.getSex(;call.setInt(4, stu.getAge(;call.executeUpdate(; catch (SQLException e e.printStackTrace(;finallyDBUtil.close(call;DBUtil.close(conn;public ArrayList queryAll( Connection conn=DBUtil.getNewConnection(;PreparedStatement pstmt=null;ResultSet rs=null;ArrayList stus= new ArrayLis

7、t (; try pstmt=conn.prepareStatement(select * from student where 1=1;rs=pstmt.executeQuery(;Student stu=null;while(rs!=null&rs.next(stu=new Student(;stu.setNo(rs.getInt(sno;stu.setName(rs.getString(sname;stu.setSex(rs.getString(sex;stu.setAge(rs.getInt(age;stus.add(stu; catch (SQLException e e.print

8、StackTrace(;finallyDBUtil.close(rs;DBUtil.close(pstmt;DBUtil.close(conn;return null;public int insert(Student stu / TODO Auto-generated method stubreturn 0;class DBUtil public static Connection getNewConnection(Connection conn=null;try Class.forName(;conn=DriverManager.getConnection(jdbc:sqlserver:/

9、localhost:1433;databaseName=StudentDB, sa, sasa; catch (ClassNotFoundException e e.printStackTrace(; catch (SQLException e e.printStackTrace(;return conn;public static void close(PreparedStatement pstmtif(pstmt!=nulltry pstmt.close(; catch (SQLException e e.printStackTrace(;public static void close(

10、ResultSet rsif(rs!=nulltry rs.close(; catch (SQLException e e.printStackTrace(;public static void close(Connection connif(conn!=nulltry conn.close(; catch (SQLException e e.printStackTrace(;public void close(Statement stmtif(stmt!=nulltry stmt.close(; catch (SQLException e e.printStackTrace(;public

11、class TestStudentDaoImpl static StudentDao sdi= new StudentDaoImpl(;public static void main(String args public static void insert(Student stu=new Student(;stu.setNo(5;stu.setName(刘巴;stu.setSex(女;stu.setAge(18;sdi.insert(stu;public static void queryAll(ArrayList stus= sdi.queryAll(;if(stus!=nullfor(Student