如果您无法下载资料,请参考说明:
1、部分资料下载需要金币,请确保您的账户上有足够的金币
2、已购买过的文档,再次下载不重复扣费
3、资料包下载后请先用软件解压,在使用对应软件打开
packagecom.tarena.oa.utils;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassDBUtil{publicstaticConnectiongetConnection()throwsException{Connectionconn=null;try{Class.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnection("jdbc:mysql://localhost:3307/oa?userUnicode=true&characterEncoding=utf-8","root","admin");}catch(Exceptione){e.printStackTrace();throwe;}returnconn;////获取tomcat中JNDI容器//Contextcontext=newInitialContext();////获取DataSource对象//DataSourceds=(DataSource)context//.lookup("java:/comp/env/jdbc/mysqlconn");////System.out.println(ds.getClass().getName());////获取连接//Connectionconn=ds.getConnection();//returnconn;}publicstaticvoidclose(ResultSetrs,Statementstat,Connectionconn){if(rs!=null){try{rs.close();}catch(SQLExceptione){e.printStackTrace();}finally{if(stat!=null){try{stat.close();}catch(SQLExceptione){e.printStackTrace();}finally{if(conn!=null){try{conn.close();}catch(SQLExceptione){e.printStackTrace();}}}}}}}publicstaticvoidmain(String[]args){//TODOAuto-generatedmethodstubtry{System.out.println(getConnection());}catch(Exceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}}packageutil;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;publicclassDBUtil{//提供连接的获得jdbcpublicstaticConnectiongetConnection()throwsException{Connectionconn=null;try{Class.forName("com.mysql.jdbc.Driver");conn=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3307/jd1209db"+"?useUnicode=true&characterEncoding=utf-8","root","admin");}catch(Exceptione){e.printStackTrace();throwe;}returnconn;}publicstaticvoid