java底层数据库操作方法(外国英文资料).docVIP

java底层数据库操作方法 Dao layer: the operation of the database Public, class, BaseDao { / / database connection Connection conn=null; Private final static String DRIVER= com.microsoft.sqlserver.jdbc.SQLserverDriver; Private, final, static, String, URL=, jdbc:sqlserver://localhost:1433, DatabaseName=Students; Private final static String DUSER= SA; Private final static String DPASS= WW; / / get connected Public, Connection, getConn () { Try{ Class.forName (DRIVER); Conn=DriverManager.getConnection (URL, DUSER, DPASS); }catch (Exception, e) { E.printStackTrace (); } Return conn; } / / data update Public, int, updateSQL (String, SQL, ArrayList, list) { Connection, conn=this.getConn (); PreparedStatement pstmt=null; Int flag=0; Try{ Pstmt=conn.prepareStatement (SQL); If (list, =null) { For (int i=0; ilist.size (); i++) { Pstmt.setObject (1+i, list.get (I)); } } Flag=pstmt.executeUpdate (); }catch (Exception, e) { E.printStackTrace (); }finally{ } Return flag; } / / data query Public, Map[], querySQL (String, SQL, ArrayList, list) { Map[] maps=null; PreparedStatement pstmt=null; ResultSet resultset=null; Connection, conn=this.getConn (); Try{ Pstmt=conn.prepareStatement (SQL); If (list, =null) { For (int i=0; ilist.size (); i++) { Pstmt.setObject (i+1, list.get (I)); } } Resultset=pstmt.executeQuery (); Result result=ResultSupport.toResult (resultset); Maps=result.getRows (); }catch (Exception, e) { E.printStackTrace (); }finally{ Try{ Pstmt.close (); Resultset.close (); Conn.close (); }catch (Exception, e) { E.printStackTrace (); } } Return maps; } } Using the Dao layer in Hibernate Import java.io.Serializable; Import java.util.ArrayList; Import java.util.Iterator; Import java.util.List; Import org.hibernate.Query; Import org.hibernate.Session; Import org.hibernate.SessionFactory; Import org.hibernate.Transaction; Import org.hibernate.cfg.Configuration; 进口dao.daoinface； 导入实体，用户； 公共课daoinfaceimpl实现daoinface { 配置新的configuration() configure() CFG =； SessionFactory SF = CFG。buildses