码如下:
package com.lanp.ajax.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 连接数据库的工具类,被定义成不可继承且是私有访问
*/
public final class DBUtils {
private static String url = "jdbc:mysql://localhost:3306/mydb";
private static String user = "root";
private static String psw = "root";
private static Connection conn;
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
private DBUtils() {
}
/**
* 获取数据库的连接
* @return conn
*/
public static Connection getConnection() {
if(null == conn) {
try {
conn = DriverManager.getConnection(url, user, psw);
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
return conn;
}
/**
* 释放资源
* @param conn
* @param pstmt
* @param rs
*/
public static void closeResources(Connection conn,PreparedStatement pstmt,ResultSet rs) {
if(null != rs) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
} finally {
if(null != pstmt) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
} finally {
if(null != conn) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
}
}
}
}
}
}
下面为大家找到一个使用JDBC驱动链接Mysql数据库的简单示例，可以和上面的工具一起参考使用
利用JDBC驱动链接Mysql数据其实很简单的，第一要下载一个名为 “mysql-connector-java-5.1.20-bin.jar” 驱动包。并解压到相应的目录!5.1.20是版 本号到目前为止这个是最新的版本!
第一、如果你是在命令行方式下开发，需要把mysql-connector-java-5.1.2.0-bin.jar 添加到系统的CLASSPATH中。怎么加到CLASSPATH中我想不要讲了大家也应懂的吧。
第二、如果你是用Eclipse开发工具的话，还要配置一下 "Java Build Path"、具体的操作“点击Eclipse的Project->Properties->Java Build Path->Libraries” 现在在看以的窗口中点击右边的Add External JARs 然后选择mysql-connector-java-5.1.2.0-bin.jar驱动 点击打开就完成了配置。
下面就是Java利用JDBC连接Mysql数据的实例代码：
复制代码 代码如下:
import java.sql.*;
public class ConnectMysql {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://192.168.1.112:3306/linksystem";
String user = "root";
beijingdaikaifapiao.ddtky.com;
tianjindaikaifapiao.ddtky.com;
shanghaidaikaifapiao.ddtky.com;
zhongqingdaikaifapiao.ddtky.com;
shijiazhuangdaikaifapiao.ddtky.com;
huhehaotedaikaifapiao.ddtky.com;
shenyangdaikaifapiao.ddtky.com;
changchundaikaifapiao.ddtky.com;
haerbindaikaifapiao.ddtky.com;
nanjingdaikaifapiao.ddtky.com;
hangzhoudaikaifapiao.ddtky.com;
hefeidaikaifapiao.ddtky.com;
fuzhoudaikaifapiao.ddtky.com;
nanchangdaikaifapiao.ddtky.com;
jinandaikaifapiao.ddtky.com;
zhengzhoudaikaifapiao.ddtky.com;
wuhandaikaifapiao.ddtky.com;
changshadaikaifapiao.ddtky.com;
guangzhoudaikaifapiao.ddtky.com;
nanningdaikaifapiao.ddtky.com;
chengdudaikaifapiao.ddtky.com;
guiyangdaikaifapiao.ddtky.com;
kunmingdaikaifapiao.ddtky.com;
lasadaikaifapiao.ddtky.com;
xiandaikaifapiao.ddtky.com;
lanzhoudaikaifapiao.ddtky.com;
xiningdaikaifapiao.ddtky.com;
yinchuandaikaifapiao.ddtky.com;
wulumuqidaikaifapiao.ddtky.com;
daliandaikaifapiao.ddtky.com;
wuxidaikaifapiao.ddtky.com;
ningbodaikaifapiao.ddtky.com;
wenzhoudaikaifapiao.ddtky.com;
xiamendaikaifapiao.ddtky.com;
qingdaodaikaifapiao.ddtky.com;
shenzhendaikaifapiao.ddtky.com;
yantaidaikaifapiao.ddtky.com;
tangshandaikaifapiao.ddtky.com;
qinhuangdaodaikaifapiao.ddtky.com;
handandaikaifapiao.ddtky.com;
baodingdaikaifapiao.ddtky.com;
zhangjiakoudaikaifapiao.ddtky.com;
chengdedaikaifapiao.ddtky.com;
cangzhoudaikaifapiao.ddtky.com;
langfangdaikaifapiao.ddtky.com;
hengshuidaikaifapiao.ddtky.com;
baotoudaikaifapiao.ddtky.com;
wuhaidaikaifapiao.ddtky.com;
chifengdaikaifapiao.ddtky.com;
tongliaodaikaifapiao.ddtky.com;
eerduosidaikaifapiao.ddtky.com;
hulunbeierdaikaifapiao.ddtky.com;
bayannaoerdaikaifapiao.ddtky.com;
wulanchabudaikaifapiao.ddtky.com;
anshandaikaifapiao.ddtky.com;
fushundaikaifapiao.ddtky.com;
benxidaikaifapiao.ddtky.com;
dandongdaikaifapiao.ddtky.com;
jinzhoudaikaifapiao.ddtky.com;
yingkoudaikaifapiao.ddtky.com;
fuxindaikaifapiao.ddtky.com;
liaoyangdaikaifapiao.ddtky.com;
panjindaikaifapiao.ddtky.com;
tielingdaikaifapiao.ddtky.com;
chaoyangdaikaifapiao.ddtky.com;
huludaodaikaifapiao.ddtky.com;
jilindaikaifapiao.ddtky.com;
sipingdaikaifapiao.ddtky.com;
liaoyuandaikaifapiao.ddtky.com;
tonghuadaikaifapiao.ddtky.com;
baishandaikaifapiao.ddtky.com;
songyuandaikaifapiao.ddtky.com;
baichengdaikaifapiao.ddtky.com;
qiqihaerdaikaifapiao.ddtky.com;
hegangdaikaifapiao.ddtky.com;
shuangyashandaikaifapiao.ddtky.com;
jixidaikaifapiao.ddtky.com;
daqingdaikaifapiao.ddtky.com;
yichundaikaifapiao.ddtky.com;
mudanjiangdaikaifapiao.ddtky.com;
jiamusidaikaifapiao.ddtky.com;
qitaihedaikaifapiao.ddtky.com;
heihedaikaifapiao.ddtky.com;
suihuadaikaifapiao.ddtky.com;
xuzhoudaikaifapiao.ddtky.com;
changzhoudaikaifapiao.ddtky.com;
suzhoudaikaifapiao.ddtky.com;
nantongdaikaifapiao.ddtky.com;
lianyungangdaikaifapiao.ddtky.com;
huaiandaikaifapiao.ddtky.com;
yanchengdaikaifapiao.ddtky.com;
yangzhoudaikaifapiao.ddtky.com;
zhenjiangdaikaifapiao.ddtky.com;
taizhoudaikaifapiao.ddtky.com;
suqiandaikaifapiao.ddtky.com;
jiaxingdaikaifapiao.ddtky.com;
huzhoudaikaifapiao.ddtky.com;
shaoxingdaikaifapiao.ddtky.com;
jinhuadaikaifapiao.ddtky.com;
quzhoudaikaifapiao.ddtky.com;
zhoushandaikaifapiao.ddtky.com;
taizhoudaikaifapiao.ddtky.com;
lishuidaikaifapiao.ddtky.com;
wuhudaikaifapiao.ddtky.com;
bangbudaikaifapiao.ddtky.com;
huainandaikaifapiao.ddtky.com;
maanshandaikaifapiao.ddtky.com;
huaibeidaikaifapiao.ddtky.com;
tonglingdaikaifapiao.ddtky.com;
anqingdaikaifapiao.ddtky.com;
huangshandaikaifapiao.ddtky.com;
chuzhoudaikaifapiao.ddtky.com;
fuyangdaikaifapiao.ddtky.com;
suzhoudaikaifapiao.ddtky.com;
chaohudaikaifapiao.ddtky.com;
chizhoudaikaifapiao.ddtky.com;
xuanchengdaikaifapiao.ddtky.com;
putiandaikaifapiao.ddtky.com;
sanmingdaikaifapiao.ddtky.com;
quanzhoudaikaifapiao.ddtky.com;
zhangzhoudaikaifapiao.ddtky.com;
nanpingdaikaifapiao.ddtky.com;
ningdedaikaifapiao.ddtky.com;
lepingdaikaifapiao.ddtky.com;
ruichangdaikaifapiao.ddtky.com;
guixidaikaifapiao.ddtky.com;
ruijindaikaifapiao.ddtky.com;
nankangdaikaifapiao.ddtky.com;
jinggangshandaikaifapiao.ddtky.com;
fengchengdaikaifapiao.ddtky.com;
zhangshudaikaifapiao.ddtky.com;
gaoandaikaifapiao.ddtky.com;
dexingdaikaifapiao.ddtky.com;
zibodaikaifapiao.ddtky.com;
zaozhuangdaikaifapiao.ddtky.com;
dongyingdaikaifapiao.ddtky.com;
weifangdaikaifapiao.ddtky.com;
jiningdaikaifapiao.ddtky.com;
taiandaikaifapiao.ddtky.com;
weihaidaikaifapiao.ddtky.com;
rizhaodaikaifapiao.ddtky.com;
laiwudaikaifapiao.ddtky.com;
linyidaikaifapiao.ddtky.com;
dezhoudaikaifapiao.ddtky.com;
liaochengdaikaifapiao.ddtky.com;
xuzhoudaikaifapiao.ddtky.com;
binzhoudaikaifapiao.ddtky.com;
hezedaikaifapiao.ddtky.com;
luoyangdaikaifapiao.ddtky.com;
kaifengdaikaifapiao.ddtky.com;
luoyangdaikaifapiao.ddtky.com;
pingdingshandaikaifapiao.ddtky.com;
anyangdaikaifapiao.ddtky.com;
hebidaikaifapiao.ddtky.com;
xinxiangdaikaifapiao.ddtky.com;
jiaozuodaikaifapiao.ddtky.com;
濮yangdaikaifapiao.ddtky.com;
xuchangdaikaifapiao.ddtky.com;
漯hedaikaifapiao.ddtky.com;
sanmenxiadaikaifapiao.ddtky.com;
nanyangdaikaifapiao.ddtky.com;
shangqiudaikaifapiao.ddtky.com;
xinyangdaikaifapiao.ddtky.com;
zhoukoudaikaifapiao.ddtky.com;
zhumadiandaikaifapiao.ddtky.com;
huangshidaikaifapiao.ddtky.com;
shiyandaikaifapiao.ddtky.com;
jingzhoudaikaifapiao.ddtky.com;
yichangdaikaifapiao.ddtky.com;
ezhoudaikaifapiao.ddtky.com;
jingmendaikaifapiao.ddtky.com;
xiaogandaikaifapiao.ddtky.com;
huanggangdaikaifapiao.ddtky.com;
xianningdaikaifapiao.ddtky.com;
suizhoudaikaifapiao.ddtky.com;
zhuzhoudaikaifapiao.ddtky.com;
xiangtandaikaifapiao.ddtky.com;
hengyangdaikaifapiao.ddtky.com;
shaoyangdaikaifapiao.ddtky.com;
yueyangdaikaifapiao.ddtky.com;
changdedaikaifapiao.ddtky.com;
yiyangdaikaifapiao.ddtky.com;
chenzhoudaikaifapiao.ddtky.com;
yongzhoudaikaifapiao.ddtky.com;
huaihuadaikaifapiao.ddtky.com;
loudidaikaifapiao.ddtky.com;
zhuhaidaikaifapiao.ddtky.com;
shantoudaikaifapiao.ddtky.com;
shaoguandaikaifapiao.ddtky.com;
foshandaikaifapiao.ddtky.com;
jiangmendaikaifapiao.ddtky.com;
zhanjiangdaikaifapiao.ddtky.com;
maomingdaikaifapiao.ddtky.com;
zhaoqingdaikaifapiao.ddtky.com;
huizhoudaikaifapiao.ddtky.com;
meizhoudaikaifapiao.ddtky.com;
shanweidaikaifapiao.ddtky.com;
heyuandaikaifapiao.ddtky.com;
yangjiangdaikaifapiao.ddtky.com;
qingyuandaikaifapiao.ddtky.com;
dong莞daikaifapiao.ddtky.com;
zhongshandaikaifapiao.ddtky.com;
yunfudaikaifapiao.ddtky.com;
liuzhoudaikaifapiao.ddtky.com;
guilindaikaifapiao.ddtky.com;
wuzhoudaikaifapiao.ddtky.com;
beihaidaikaifapiao.ddtky.com;
qinzhoudaikaifapiao.ddtky.com;
guigangdaikaifapiao.ddtky.com;
yulindaikaifapiao.ddtky.com;
baisedaikaifapiao.ddtky.com;
hezhoudaikaifapiao.ddtky.com;
hechidaikaifapiao.ddtky.com;
laibindaikaifapiao.ddtky.com;
chongzuodaikaifapiao.ddtky.com;
泸zhoudaikaifapiao.ddtky.com;
deyangdaikaifapiao.ddtky.com;
mianyangdaikaifapiao.ddtky.com;
guangyuandaikaifapiao.ddtky.com;
suiningdaikaifapiao.ddtky.com;
neijiangdaikaifapiao.ddtky.com;
leshandaikaifapiao.ddtky.com;
nanchongdaikaifapiao.ddtky.com;
meishandaikaifapiao.ddtky.com;
yibindaikaifapiao.ddtky.com;
guangandaikaifapiao.ddtky.com;
dazhoudaikaifapiao.ddtky.com;
yaandaikaifapiao.ddtky.com;
bazhongdaikaifapiao.ddtky.com;
ziyangdaikaifapiao.ddtky.com;
liupanshuidaikaifapiao.ddtky.com;
zunyidaikaifapiao.ddtky.com;
anshundaikaifapiao.ddtky.com;
qujingdaikaifapiao.ddtky.com;
yuxidaikaifapiao.ddtky.com;
baoshandaikaifapiao.ddtky.com;
zhaotongdaikaifapiao.ddtky.com;
lijiangdaikaifapiao.ddtky.com;
puerdaikaifapiao.ddtky.com;
lincangdaikaifapiao.ddtky.com;
tongchuandaikaifapiao.ddtky.com;
baojidaikaifapiao.ddtky.com;
xianyangdaikaifapiao.ddtky.com;
weinandaikaifapiao.ddtky.com;
yanandaikaifapiao.ddtky.com;
hanzhongdaikaifapiao.ddtky.com;
yulindaikaifapiao.ddtky.com;
ankangdaikaifapiao.ddtky.com;
shangluodaikaifapiao.ddtky.com;
jinchangdaikaifapiao.ddtky.com;
baiyindaikaifapiao.ddtky.com;
tianshuidaikaifapiao.ddtky.com;
wuweidaikaifapiao.ddtky.com;
zhangyedaikaifapiao.ddtky.com;
pingliangdaikaifapiao.ddtky.com;
jiuquandaikaifapiao.ddtky.com;
qingyangdaikaifapiao.ddtky.com;
wulumuqidaikaifapiao.ddtky.com;
jinzhoudaikaifapiao.ddtky.com;
qianandaikaifapiao.ddtky.com;
gaobeidiandaikaifapiao.ddtky.com;
xilinhaotedaikaifapiao.ddtky.com;
erlianhaotedaikaifapiao.ddtky.com;
wulanhaotedaikaifapiao.ddtky.com;
aershandaikaifapiao.ddtky.com;
xinmindaikaifapiao.ddtky.com;
wafangdiandaikaifapiao.ddtky.com;
pulandiandaikaifapiao.ddtky.com;
zhuanghedaikaifapiao.ddtky.com;
haichengdaikaifapiao.ddtky.com;
donggangdaikaifapiao.ddtky.com;
fengchengdaikaifapiao.ddtky.com;
linghaidaikaifapiao.ddtky.com;
beizhendaikaifapiao.ddtky.com;
dashiqiaodaikaifapiao.ddtky.com;
gaizhoudaikaifapiao.ddtky.com;
dengtadaikaifapiao.ddtky.com;
diaobingshandaikaifapiao.ddtky.com;
kaiyuandaikaifapiao.ddtky.com;
lingyuandaikaifapiao.ddtky.com;
beipiaodaikaifapiao.ddtky.com;
xingchengdaikaifapiao.ddtky.com;
jiutaidaikaifapiao.ddtky.com;
yushudaikaifapiao.ddtky.com;
dehuidaikaifapiao.ddtky.com;
shulandaikaifapiao.ddtky.com;
桦diandaikaifapiao.ddtky.com;
蛟hedaikaifapiao.ddtky.com;
panshidaikaifapiao.ddtky.com;
gongzhulingdaikaifapiao.ddtky.com;
shuangliaodaikaifapiao.ddtky.com;
meihekoudaikaifapiao.ddtky.com;
jiandaikaifapiao.ddtky.com;
linjiangdaikaifapiao.ddtky.com;
daandaikaifapiao.ddtky.com;
洮nandaikaifapiao.ddtky.com;
yanjidaikaifapiao.ddtky.com;
tumendaikaifapiao.ddtky.com;
dunhuadaikaifapiao.ddtky.com;
longjingdaikaifapiao.ddtky.com;
珲chundaikaifapiao.ddtky.com;
helongdaikaifapiao.ddtky.com;
shangzhidaikaifapiao.ddtky.com;
shuangchengdaikaifapiao.ddtky.com;
wuchangdaikaifapiao.ddtky.com;
讷hedaikaifapiao.ddtky.com;
mishandaikaifapiao.ddtky.com;
hulindaikaifapiao.ddtky.com;
tielidaikaifapiao.ddtky.com;
suifenhedaikaifapiao.ddtky.com;
ningandaikaifapiao.ddtky.com;
hailindaikaifapiao.ddtky.com;
mulengdaikaifapiao.ddtky.com;
tongjiangdaikaifapiao.ddtky.com;
fujindaikaifapiao.ddtky.com;
beiandaikaifapiao.ddtky.com;
wudalianchidaikaifapiao.ddtky.com;
andadaikaifapiao.ddtky.com;
zhaodongdaikaifapiao.ddtky.com;
hailundaikaifapiao.ddtky.com;
jiangyindaikaifapiao.ddtky.com;
yixingdaikaifapiao.ddtky.com;
邳zhoudaikaifapiao.ddtky.com;
xinyidaikaifapiao.ddtky.com;
jintandaikaifapiao.ddtky.com;
溧yangdaikaifapiao.ddtky.com;
changshudaikaifapiao.ddtky.com;
zhangjiagangdaikaifapiao.ddtky.com;
taicangdaikaifapiao.ddtky.com;
kunshandaikaifapiao.ddtky.com;
wujiangdaikaifapiao.ddtky.com;
rugaodaikaifapiao.ddtky.com;
tongzhoudaikaifapiao.ddtky.com;
haimendaikaifapiao.ddtky.com;
qidongdaikaifapiao.ddtky.com;
dongtaidaikaifapiao.ddtky.com;
dafengdaikaifapiao.ddtky.com;
gaoyoudaikaifapiao.ddtky.com;
jiangdudaikaifapiao.ddtky.com;
yizhengdaikaifapiao.ddtky.com;
danyangdaikaifapiao.ddtky.com;
yangzhongdaikaifapiao.ddtky.com;
jurongdaikaifapiao.ddtky.com;
taixingdaikaifapiao.ddtky.com;
jiangyandaikaifapiao.ddtky.com;
jingjiangdaikaifapiao.ddtky.com;
xinghuadaikaifapiao.ddtky.com;
jiandedaikaifapiao.ddtky.com;
fuyangdaikaifapiao.ddtky.com;
linandaikaifapiao.ddtky.com;
yuyaodaikaifapiao.ddtky.com;
cixidaikaifapiao.ddtky.com;
fenghuadaikaifapiao.ddtky.com;
ruiandaikaifapiao.ddtky.com;
leqingdaikaifapiao.ddtky.com;
hainingdaikaifapiao.ddtky.com;
pinghudaikaifapiao.ddtky.com;
tongxiangdaikaifapiao.ddtky.com;
zhu暨daikaifapiao.ddtky.com;
shangyudaikaifapiao.ddtky.com;
嵊zhoudaikaifapiao.ddtky.com;
lanxidaikaifapiao.ddtky.com;
yiwudaikaifapiao.ddtky.com;
dongyangdaikaifapiao.ddtky.com;
yongkangdaikaifapiao.ddtky.com;
jiangshandaikaifapiao.ddtky.com;
linhaidaikaifapiao.ddtky.com;
wenlingdaikaifapiao.ddtky.com;
longquandaikaifapiao.ddtky.com;
tongchengdaikaifapiao.ddtky.com;
tianchangdaikaifapiao.ddtky.com;
mingguangdaikaifapiao.ddtky.com;
jieshoudaikaifapiao.ddtky.com;
ningguodaikaifapiao.ddtky.com;
fuqingdaikaifapiao.ddtky.com;
changledaikaifapiao.ddtky.com;
yongandaikaifapiao.ddtky.com;
shishidaikaifapiao.ddtky.com;
jinjiangdaikaifapiao.ddtky.com;
nanandaikaifapiao.ddtky.com;
longhaidaikaifapiao.ddtky.com;
shaowudaikaifapiao.ddtky.com;
jian瓯daikaifapiao.ddtky.com;
zhangpingdaikaifapiao.ddtky.com;
jianyangdaikaifapiao.ddtky.com;
fuandaikaifapiao.ddtky.com;
fudingdaikaifapiao.ddtky.com;
dayedaikaifapiao.ddtky.com;
danjiangkoudaikaifapiao.ddtky.com;
honghudaikaifapiao.ddtky.com;
shishoudaikaifapiao.ddtky.com;
songzidaikaifapiao.ddtky.com;
yidudaikaifapiao.ddtky.com;
dangyangdaikaifapiao.ddtky.com;
zhijiangdaikaifapiao.ddtky.com;
laohekoudaikaifapiao.ddtky.com;
zaoyangdaikaifapiao.ddtky.com;
yichengdaikaifapiao.ddtky.com;
zhongxiangdaikaifapiao.ddtky.com;
yingchengdaikaifapiao.ddtky.com;
anludaikaifapiao.ddtky.com;
hanchuandaikaifapiao.ddtky.com;
machengdaikaifapiao.ddtky.com;
wuxuedaikaifapiao.ddtky.com;
chibidaikaifapiao.ddtky.com;
guangshuidaikaifapiao.ddtky.com;
xiantaodaikaifapiao.ddtky.com;
tianmendaikaifapiao.ddtky.com;
qianjiangdaikaifapiao.ddtky.com;
enshidaikaifapiao.ddtky.com;
lichuandaikaifapiao.ddtky.com;
zhangqiudaikaifapiao.ddtky.com;
jiaonandaikaifapiao.ddtky.com;
jiaozhoudaikaifapiao.ddtky.com;
pingdudaikaifapiao.ddtky.com;
laixidaikaifapiao.ddtky.com;
jimodaikaifapiao.ddtky.com;
滕zhoudaikaifapiao.ddtky.com;
longkoudaikaifapiao.ddtky.com;
laiyangdaikaifapiao.ddtky.com;
laizhoudaikaifapiao.ddtky.com;
zhaoyuandaikaifapiao.ddtky.com;
penglaidaikaifapiao.ddtky.com;
qixiadaikaifapiao.ddtky.com;
haiyangdaikaifapiao.ddtky.com;
qingzhoudaikaifapiao.ddtky.com;
zhuchengdaikaifapiao.ddtky.com;
shouguangdaikaifapiao.ddtky.com;
anqiudaikaifapiao.ddtky.com;
gaomidaikaifapiao.ddtky.com;
changyidaikaifapiao.ddtky.com;
qufudaikaifapiao.ddtky.com;
兖zhoudaikaifapiao.ddtky.com;
zouchengdaikaifapiao.ddtky.com;
xintaidaikaifapiao.ddtky.com;
feichengdaikaifapiao.ddtky.com;
rushandaikaifapiao.ddtky.com;
wendengdaikaifapiao.ddtky.com;
rongchengdaikaifapiao.ddtky.com;
lelingdaikaifapiao.ddtky.com;
yuchengdaikaifapiao.ddtky.com;
linqingdaikaifapiao.ddtky.com;
gongyidaikaifapiao.ddtky.com;
xinzhengdaikaifapiao.ddtky.com;
xinmidaikaifapiao.ddtky.com;
dengfengdaikaifapiao.ddtky.com;
荥yangdaikaifapiao.ddtky.com;
偃shidaikaifapiao.ddtky.com;
ruzhoudaikaifapiao.ddtky.com;
wugangdaikaifapiao.ddtky.com;
linzhoudaikaifapiao.ddtky.com;
weihuidaikaifapiao.ddtky.com;
huixiandaikaifapiao.ddtky.com;
qinyangdaikaifapiao.ddtky.com;
mengzhoudaikaifapiao.ddtky.com;
yuzhoudaikaifapiao.ddtky.com;
changgedaikaifapiao.ddtky.com;
yimadaikaifapiao.ddtky.com;
lingbaodaikaifapiao.ddtky.com;
dengzhoudaikaifapiao.ddtky.com;
yongchengdaikaifapiao.ddtky.com;
xiangchengdaikaifapiao.ddtky.com;
jiyuandaikaifapiao.ddtky.com;
dayedaikaifapiao.ddtky.com;
danjiangkoudaikaifapiao.ddtky.com;
honghudaikaifapiao.ddtky.com;
shishoudaikaifapiao.ddtky.com;
songzidaikaifapiao.ddtky.com;
yidudaikaifapiao.ddtky.com;
dangyangdaikaifapiao.ddtky.com;
zhijiangdaikaifapiao.ddtky.com;
laohekoudaikaifapiao.ddtky.com;
zaoyangdaikaifapiao.ddtky.com;
yichengdaikaifapiao.ddtky.com;
zhongxiangdaikaifapiao.ddtky.com;
yingchengdaikaifapiao.ddtky.com;
anludaikaifapiao.ddtky.com;
hanchuandaikaifapiao.ddtky.com;
machengdaikaifapiao.ddtky.com;
wuxuedaikaifapiao.ddtky.com;
chibidaikaifapiao.ddtky.com;
guangshuidaikaifapiao.ddtky.com;
xiantaodaikaifapiao.ddtky.com;
tianmendaikaifapiao.ddtky.com;
qianjiangdaikaifapiao.ddtky.com;
enshidaikaifapiao.ddtky.com;
lichuandaikaifapiao.ddtky.com;
浏yangdaikaifapiao.ddtky.com;
xiangxiangdaikaifapiao.ddtky.com;
shaoshandaikaifapiao.ddtky.com;
耒yangdaikaifapiao.ddtky.com;
changningdaikaifapiao.ddtky.com;
wugangdaikaifapiao.ddtky.com;
linxiangdaikaifapiao.ddtky.com;
汨luodaikaifapiao.ddtky.com;
沅jiangdaikaifapiao.ddtky.com;
zixingdaikaifapiao.ddtky.com;
hongjiangdaikaifapiao.ddtky.com;
lianyuandaikaifapiao.ddtky.com;
jishoudaikaifapiao.ddtky.com;
conghuadaikaifapiao.ddtky.com;
zengchengdaikaifapiao.ddtky.com;
lechangdaikaifapiao.ddtky.com;
nanxiongdaikaifapiao.ddtky.com;
taishandaikaifapiao.ddtky.com;
kaipingdaikaifapiao.ddtky.com;
heshandaikaifapiao.ddtky.com;
enpingdaikaifapiao.ddtky.com;
lianjiangdaikaifapiao.ddtky.com;
leizhoudaikaifapiao.ddtky.com;
wuchuandaikaifapiao.ddtky.com;
gaozhoudaikaifapiao.ddtky.com;
huazhoudaikaifapiao.ddtky.com;
xinyidaikaifapiao.ddtky.com;
gaoyaodaikaifapiao.ddtky.com;
sihuidaikaifapiao.ddtky.com;
xingningdaikaifapiao.ddtky.com;
lufengdaikaifapiao.ddtky.com;
yangchundaikaifapiao.ddtky.com;
yingdedaikaifapiao.ddtky.com;
lianzhoudaikaifapiao.ddtky.com;
puningdaikaifapiao.ddtky.com;
luodingdaikaifapiao.ddtky.com;
岑xidaikaifapiao.ddtky.com;
dongxingdaikaifapiao.ddtky.com;
guipingdaikaifapiao.ddtky.com;
beiliudaikaifapiao.ddtky.com;
yizhoudaikaifapiao.ddtky.com;
heshandaikaifapiao.ddtky.com;
邛崃daikaifapiao.ddtky.com;
chongzhoudaikaifapiao.ddtky.com;
guanghandaikaifapiao.ddtky.com;
shi邡daikaifapiao.ddtky.com;
mianzhudaikaifapiao.ddtky.com;
jiangyoudaikaifapiao.ddtky.com;
阆zhongdaikaifapiao.ddtky.com;
hua蓥daikaifapiao.ddtky.com;
wanyuandaikaifapiao.ddtky.com;
jianyangdaikaifapiao.ddtky.com;
xichangdaikaifapiao.ddtky.com;
qingzhendaikaifapiao.ddtky.com;
chishuidaikaifapiao.ddtky.com;
renhuaidaikaifapiao.ddtky.com;
tongrendaikaifapiao.ddtky.com;
bijiedaikaifapiao.ddtky.com;
xingyidaikaifapiao.ddtky.com;
kailidaikaifapiao.ddtky.com;
duyundaikaifapiao.ddtky.com;
fuquandaikaifapiao.ddtky.com;
anningdaikaifapiao.ddtky.com;
xuanweidaikaifapiao.ddtky.com;
gejiudaikaifapiao.ddtky.com;
kaiyuandaikaifapiao.ddtky.com;
jinghongdaikaifapiao.ddtky.com;
chuxiongdaikaifapiao.ddtky.com;
dalidaikaifapiao.ddtky.com;
luxidaikaifapiao.ddtky.com;
ruilidaikaifapiao.ddtky.com;
xingpingdaikaifapiao.ddtky.com;
hanchengdaikaifapiao.ddtky.com;
huayindaikaifapiao.ddtky.com;
yumendaikaifapiao.ddtky.com;
dunhuangdaikaifapiao.ddtky.com;
linxiadaikaifapiao.ddtky.com;
hezuodaikaifapiao.ddtky.com;
lingwudaikaifapiao.ddtky.com;
qingtongxiadaikaifapiao.ddtky.com;
shihezidaikaifapiao.ddtky.com;
alaerdaikaifapiao.ddtky.com;
tumushukedaikaifapiao.ddtky.com;
wujiaqudaikaifapiao.ddtky.com;
tulufandaikaifapiao.ddtky.com;
hamidaikaifapiao.ddtky.com;
hetiandaikaifapiao.ddtky.com;
akesudaikaifapiao.ddtky.com;
kashidaikaifapiao.ddtky.com;
atushidaikaifapiao.ddtky.com;
kuerledaikaifapiao.ddtky.com;
changjidaikaifapiao.ddtky.com;
fukangdaikaifapiao.ddtky.com;
miquandaikaifapiao.ddtky.com;
boledaikaifapiao.ddtky.com;
yiningdaikaifapiao.ddtky.com;
kuitundaikaifapiao.ddtky.com;
tachengdaikaifapiao.ddtky.com;
wusudaikaifapiao.ddtky.com;
aletaidaikaifapiao.ddtky.com;
String password = "blog.micxp.com";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
if (!conn.isClosed()) {
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select * from flink_list";
ResultSet rs = statement.executeQuery(sql);
String name;
while (rs.next()) {
name = rs.getString("link_name");
System.out.println(name);
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}