Pastebin.vip
Create
Recent
Trending
About
Create connection
From , 4 Years ago, written in Java, viewed 54 times.
URL
https://pastebin.vip/view/3a20f62a
Embed
—
Expand Paste
to full width of browser
package
Util
;
import
java.io.IOException
;
import
java.sql.Connection
;
import
java.sql.SQLException
;
import
java.util.Properties
;
import
org.apache.commons.dbcp.BasicDataSource
;
public
class
DBUtil
{
private
static
BasicDataSource ds
;
static
{
Properties
p
=
new
Properties
(
)
;
try
{
//读取参数
p.
load
(
DBUtil.
class
.
getClassLoader
(
)
.
getResourceAsStream
(
"db.properties"
)
)
;
String
driver
=
p.
getProperty
(
"driver"
)
;
String
url
=
p.
getProperty
(
"url"
)
;
String
user
=
p.
getProperty
(
"user"
)
;
String
pwd
=
p.
getProperty
(
"pwd"
)
;
String
initsize
=
p.
getProperty
(
"initsize"
)
;
String
maxsize
=
p.
getProperty
(
"maxsize"
)
;
//创建连接池
ds
=
new
BasicDataSource
(
)
;
//设置参数
ds.
setDriverClassName
(
driver
)
;
ds.
setUrl
(
url
)
;
ds.
setUsername
(
user
)
;
ds.
setPassword
(
pwd
)
;
ds.
setInitialSize
(
new
Integer
(
initsize
)
)
;
ds.
setMaxActive
(
new
Integer
(
maxsize
)
)
;
}
catch
(
IOException
e
)
{
e.
printStackTrace
(
)
;
throw
new
RuntimeException
(
"加载配置文件失败."
, e
)
;
}
}
/**
* 本方法是采用BasicDataSource创建的连接,
* 则Connection接口是由DBCP实现的,而并非
* 由Oracle实现.当然DBCP的实现类中会调用
* Oracle的驱动类.
*/
public
static
Connection
getConnection
(
)
throws
SQLException
{
return
ds.
getConnection
(
)
;
}
/**
* 由DBCP所提供的连接对象的实现类,
* 其close方法的逻辑不是关闭连接,
* 而是归还连接,即它会将连接内包含的
* 数据清空,并且将连接的状态设置为空闲.
* */
public
static
void
close
(
Connection
conn
)
{
if
(
conn
!=
null
)
{
try
{
conn.
close
(
)
;
}
catch
(
SQLException
e
)
{
e.
printStackTrace
(
)
;
throw
new
RuntimeException
(
"关闭连接失败."
, e
)
;
}
}
}
public
static
void
rollback
(
Connection
conn
)
{
if
(
conn
!=
null
)
{
try
{
conn.
rollback
(
)
;
}
catch
(
SQLException
e
)
{
e.
printStackTrace
(
)
;
throw
new
RuntimeException
(
"事务回滚失败."
, e
)
;
}
}
}
public
static
void
main
(
String
[
]
args
)
throws
SQLException
{
Connection
conn
=
DBUtil.
getConnection
(
)
;
System
.
out
.
println
(
conn
)
;
DBUtil.
close
(
conn
)
;
}
}
Reply to "Create connection"
Here you can reply to the paste above
Author
What's your name?
Title
Give your paste a title.
Language
What language is your paste written in?
Plain Text
HTML5
CSS
JavaScript
PHP
Python
Ruby
Lua
Bash
Erlang
Go
C
C++
Diff-output
LaTeX
SQL
XML
-----------------
4CS
MOS 6502
MOS 6502 Kick Assembler
MOS 6502 TASM/64TASS
Motorola 68000 Devpac Assembler
ABAP
Actionscript
ActionScript3
Ada
AIMMS
ALGOL 68
Apache
AppleScript
Apt sources.list
ARM Assembler
x86 Assembler
asymptote
ASP
autoconf
Autohotkey
AutoIT
AviSynth
Awk
BASCOM AVR
Basic4GL
BBCode
Brainfuck
BibTeX
BlitzBasic
BNF (Backus-Naur form)
Boo
C (for LoadRunner)
C for Macs
C with WiAPI
CAD DCL (Dialog Control Language)
AutoCAD/IntelliCAD Lisp
CFDG
ColdFusion
ChaiScript
Chapel
CIL (Common Intermediate Language)
Clojure
CMake
COBOL
CoffeeScript
C++ with WinAPI
C#
Cuesheet
D
Dart
DCS
DCL
DCPU/16 Assembly
Delphi (Object Pascal)
DIV
DOS
dot
E
ECMAScript
Eiffel
Email (mbox/eml/RFC format)
Enerscript
Euphoria
EZT
Formula One
Falcon
fo
Fortran
FreeBasic
FreeSWITCH
F#
GAMBAS
GDB
Genero
Genie
GNU Gettext .po/.pot
glSlang
GML
Gnuplot script
Groovy
GwBasic
Haskell
Haxe
HicEst
HQ9+
HTML 4.01 strict
Icon
Unoidl
INI
Inno Script
INTERCAL
Io
ISPF Panel
J
Java
Java 5
Job Control Language
jQuery 1.3
KLone with C
KLone with C++
Kotlin
Liberty BASIC
LDIF
Generic Lisp
LLVM
Locomotive Basic (Amstrad CPC series)
Logcat
Logtalk
LOLcode
@Formula/@Command
LotusScript
Lightwave Script
Linden Scripting
Motorola 68000 Assembler
MagikSF
Make
MapBasic
Matlab M-file
mIRC Scripting
MMIX Assembler
Modula-2
Modula-3
Microchip Assembler
MXML
MySQL
Nagios
NetRexx
newLISP
nginx
Nimrod
Nullsoft Scriptable Install System
Oberon-2
Objective-C
Objeck Programming Language
OCaml (Objective Caml)
GNU Octave M-file
OpenOffice.org Basic
ooRexx
Oracle 11i
Oracle 8
Delphi Prism (Oxygene)
Oz
ParaSail
PARI/GP
Pascal
PCRE
Per (forms)
Perl
Perl 6
OpenBSD packet filter
PIC16 Assembler
Pike
Pixel Bender 1.0
PL/I
Oracle 9.2 PL/SQL
PostgreSQL
Postscript
Povray
PowerBuilder (PowerScript)
PowerShell
ProFTPd
Progress
Prolog
Property
ProvideX
PureBasic
Python for S60
q/kdb+
QBasic/QuickBASIC
QML
Racket
Ruby (with Ruby on Rails Framework)
RBS Script
Rebol
Microsoft Registry Editor
Rexx
robots.txt
RPM Spec
R
Rust
SAS
Scala
Scheme
SciLab
SCL
sdlBasic
Smalltalk
Smarty template
SPARK
SPARQL
StandardML
StoneScript
SystemVerilog IEEE 1800-2009(draft8)
TCL/iTCL
Tera Term Macro
thinBasic
T-SQL
TypoScript
Unicon
UnrealScript
UPC
Urbi
Vala
Visual Basic
VB.NET
VBScript
Vedit macro language
Verilog
VHDL
Vim scripting
Visual FoxPro
Visual Prolog
Whitespace
Whois response (RPSL format)
WinBatch
XBasic
xorg.conf
Axapta/Dynamics Ax X++
YAML
ZiLOG Z80 Assembler
ZXBasic
Your paste
Paste your paste here
package Util; import java.io.IOException; import java.sql.Connection; import java.sql.SQLException; import java.util.Properties; import org.apache.commons.dbcp.BasicDataSource; public class DBUtil { private static BasicDataSource ds; static { Properties p = new Properties(); try { //读取参数 p.load(DBUtil.class.getClassLoader() .getResourceAsStream("db.properties")); String driver = p.getProperty("driver"); String url = p.getProperty("url"); String user = p.getProperty("user"); String pwd = p.getProperty("pwd"); String initsize = p.getProperty("initsize"); String maxsize = p.getProperty("maxsize"); //创建连接池 ds = new BasicDataSource(); //设置参数 ds.setDriverClassName(driver); ds.setUrl(url); ds.setUsername(user); ds.setPassword(pwd); ds.setInitialSize(new Integer(initsize)); ds.setMaxActive(new Integer(maxsize)); } catch (IOException e) { e.printStackTrace(); throw new RuntimeException( "加载配置文件失败.", e); } } /** * 本方法是采用BasicDataSource创建的连接, * 则Connection接口是由DBCP实现的,而并非 * 由Oracle实现.当然DBCP的实现类中会调用 * Oracle的驱动类. */ public static Connection getConnection() throws SQLException { return ds.getConnection(); } /** * 由DBCP所提供的连接对象的实现类, * 其close方法的逻辑不是关闭连接, * 而是归还连接,即它会将连接内包含的 * 数据清空,并且将连接的状态设置为空闲. * */ public static void close(Connection conn) { if(conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); throw new RuntimeException( "关闭连接失败.", e); } } } public static void rollback(Connection conn) { if(conn != null) { try { conn.rollback(); } catch (SQLException e) { e.printStackTrace(); throw new RuntimeException( "事务回滚失败.", e); } } } public static void main(String[] args) throws SQLException { Connection conn = DBUtil.getConnection(); System.out.println(conn); DBUtil.close(conn); } }
Create Shorturl
Create a shorter url that redirects to your paste?
Private
Private paste aren't shown in recent listings.
Delete After
When should we delete your paste?
Burn on reading
5 Minutes
1 Hour
1 Day
1 Week
1 Month
1 Year
Keep Forever
Spam protection
Type in the letters
Create
https://burned.cc - Burn After Reading Website