文件名称:servlet分页、删除、修改
文件大小:580KB
文件格式:RAR
更新时间:2015-05-08 12:14:10
分页
package com.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class BaseDao { private final static String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver"; private final static String URL="jdbc:sqlserver://localhost:1433;DatabaseName=personnelManage"; private final static String UNAME="sa"; private final static String UPWD="sasa"; public Connection getcon(){ Connection con = null; try { Class.forName(DRIVER); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { con=DriverManager.getConnection(URL,UNAME,UPWD); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return con; } public void closeAll(ResultSet rs,Statement st,Connection con){ try { if(rs!=null) rs.close(); if(st!=null) st.close(); if(con!=null) con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { BaseDao dao = new BaseDao(); dao.getcon(); } }
【文件预览】:
RestSys
----src()
--------com()
----.classpath(362B)
----RestSys()
--------src()
----.mymetadata(294B)
----.project(1KB)
----WebRoot()
--------META-INF()
--------doUpdate.jsp(805B)
--------index.jsp(3KB)
--------update.jsp(2KB)
--------doDelete.jsp(579B)
--------WEB-INF()
personnelManage.sql
test
----src()
--------com()
----.classpath(431B)
----.mymetadata(285B)
----.settings()
--------org.eclipse.wst.jsdt.ui.superType.container(49B)
--------org.eclipse.wst.jsdt.ui.superType.name(6B)
--------.jsdtscope(500B)
--------org.eclipse.jdt.core.prefs(334B)
----.myeclipse()
----.project(1KB)
----WebRoot()
--------META-INF()
--------index.jsp(3KB)
--------xianshi.jsp(3KB)
--------dodelete.jsp(973B)
--------doupdate.jsp(2KB)
--------WEB-INF()
----test()
--------userinfobizimpl.java(959B)
--------WebRoot()
sqljdbc.jar