首先正确安装好MySQL，建立好数据库studentinfo
[code]mysql>create database studentinfo;[/code]
然后编写java代码，ConnectToMySQL.java
[code]import java.sql.*;
public class ConnectToMySQL {
public static Connection getConnection() throws SQLException ,
java.lang.ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/studentinfo";
Class.forName("com.mysql.jdbc.Driver");
String userName = "root";
String password = "";
Connection con = DriverManager.getConnection(url,userName,password);
return con;
}
public static void main(String[] args) {
try{
Connection con = getConnection();
Statement sql = con.createStatement();
sql.execute("drop table if exists student");
sql.execute("create table student(id int not null auto_increment,name varchar(20) not
null default 'name',math int not null default 60,primary key(id));");
sql.execute("insert student values(1,'AAA','99')");
sql.execute("insert student values(2,'BBB','77')");
sql.execute("insert student values(3,'CCC','65')");
String query = "select * from student";
ResultSet result = sql.executeQuery(query);
System.out.println("Student表数据如下：");
System.out.println("---------------------------------");
System.out.println("学号"+" "+"姓名"+" "+"数学成绩");
System.out.println("---------------------------------");
int number;
String name;
String math;
while(result.next()){
number = result.getInt("id");
name = result.getString("name");
math = result.getString("math");
System.out.println(number + " " + name + " " + math);
}
sql.close();
con.close();
}catch(java.lang.ClassNotFoundException e){
System.err.println("ClassNotFoundException:" + e.getMessage());
}catch(SQLException ex){
System.err.println("SQLException:" + ex.getMessage());
}
}
}[/code]
轻松搞定，一下为输出结果：
[align=center]
[/align]
要注意的是使用MySQL数据库，需要用到对应的JDBC驱动程序mysql-connector-java-5.0.3，可以到zySQL的官方网站上下载(http://www.mysql.org)
190.72.252.* 于 2007-09-07 06:03:45发表:
f293c7ae45ab689890ec39003d9decf6 http://decreto-milleproroghe.hhidlx.org/ http://cfppaullo.ukcvbo.org/l-amore-conta-lyrics/ http://telefilm-jag.oxibnl.org/ http://fondo-pagina.vozlau.org/ http://controlli-spa-genova.yojewt.org/ http://ristorantijesolo.npxbkv.org/gay-con-cazzi-enormi/ http://centro-smart-usata-milano.oxibnl.org/ http://bomboniere-beneficienza.oxibnl.org/ http://comunicazioneonlinepropriomedico.yufywt.org/viaggiare-metafora/ http://leccapiede2005gratis.dlqpew.org/pump-it-canzone/ ef5da0821261872f3a177fbd4ce2e9fc
208.120.35.* 于 2007-09-06 12:44:47发表:
f9c82bcfdf9d8105dd4ccda2142c7df5 http://www.international.ucf.edu/myphp/community/viewtopic.php?t=124 http://www.international.ucf.edu/myphp/community/viewtopic.php?t=124 http://www.rstm.edu/phpBB/viewtopic.php?t=1450 http://payson.tulane.edu/techeval/forums/viewtopic.php?t=74 http://iris.lib.virginia.edu/phpBB2/viewtopic.php?t=7689 http://transatlantic.ipo.asu.edu/forum/viewtopic.php?t=208 http://www.international.ucf.edu/myphp/community/viewtopic.php?t=124 http://www.cide.au.edu/audasaforum/viewtopic.php?t=458 http://transatlantic.ipo.asu.edu/forum/viewtopic.php?t=208 http://www.cide.au.edu/audasaforum/viewtopic.php?t=458 d950163e2bc04fe30175aa17834ab13d
24.3.73.* 于 2007-09-05 23:29:10发表:
53208819e33b3388e43b033ec73014af http://myweb.msoe.edu/~chaversa/phpBB2/viewtopic.php?t=2012 https://www.cslu.ogi.edu/forum/viewtopic.php?t=2657 http://www.grahi.upc.edu/ERAD2006/phpBB2/viewtopic.php?t=6839 http://www.mat.ucsb.edu/CUI/viewtopic.php?t=1142 http://www.mat.ucsb.edu/CUI/viewtopic.php?t=1142 https://www.cslu.ogi.edu/forum/viewtopic.php?t=2657 https://www.cslu.ogi.edu/forum/viewtopic.php?t=2656 http://www.grahi.upc.edu/ERAD2006/phpBB2/viewtopic.php?t=6839 https://www.cslu.ogi.edu/forum/viewtopic.php?t=2656 http://myweb.msoe.edu/~chaversa/phpBB2/viewtopic.php?t=2012 db62d9d137e7999ef0c8bbd27991ea41
206.222.110.* 于 2007-09-05 16:36:39发表:
http://emeraldring.fora.pl/
http://emeraldring.fora.pl/
http://emeraldring.fora.pl/ - emerald cut wedding ring
222.197.173.* 于 2007-09-05 13:39:02发表:
http://emeraldring.fora.pl/
http://emeraldring.fora.pl/
http://emeraldring.fora.pl/ - emerald cut wedding ring
70.178.86.* 于 2007-09-05 09:26:17发表:
cb4318cc02ba53d74142d568c638ce84 http://lettore-portatile-mp3-2gb.dfmviz.info/ http://utilizzare-cartongesso.dfmviz.info/ http://quota-successione-fratello-coniugato-prole.dfmviz.info/ http://alberghi-di-lusso.dfmviz.info/ http://ugo-foscolo-sepolcro-parafrasi.dfmviz.info/ http://milano-piazza-affari.dfmviz.info/ http://evitare-si-scaricano-foto.dfmviz.info/ http://dolore-ad-fianco.dfmviz.info/ http://istituti-parificati.dfmviz.info/ http://palestra-virgin-firenze.dfmviz.info/ 21817dd0dbd87cb119a7471ab31fd121
0.0.0.* 于 2007-09-04 11:42:23发表:
child defense fund
child defense fund
child defense fund - http://fund.freewebpages.org/child-defense-fund/index.html
free fund raising idea
free fund raising idea
free fund raising idea - http://fund.freewebpages.org/free-fund-raising-idea/index.html
fund raising company
fund raising company
fund raising company - http://fund.freewebpages.org/fund-raising-company/index.html
201.249.75.* 于 2007-09-04 07:58:45发表:
child defense fund
child defense fund
child defense fund - http://fund.freewebpages.org/child-defense-fund/index.html
free fund raising idea
free fund raising idea
free fund raising idea - http://fund.freewebpages.org/free-fund-raising-idea/index.html
fund raising company
fund raising company
fund raising company - http://fund.freewebpages.org/fund-raising-company/index.html
207.44.238.* 于 2007-09-02 09:42:03发表:
Hi, nice very nice page..!
unique fund raising
memorial scholarship fund
unique fund raising
memorial scholarship fund
fund raising cook book - http://fund.freewebpages.org/alaska-permanent-fund-dividend/index.html
Good luck !
PS: do you listen Linkin Park ?
0.0.0.* 于 2007-09-01 01:38:23发表:
Hi, nice very nice page..!
alaska permanent fund dividend
abb fund - http://fund.freewebpages.org/fund-raising-cook-book/index.html
fund
fund raising cook book
abb fund - http://fund.freewebpages.org/alaska-permanent-fund-dividend/index.html
Good luck !
PS: do you listen Linkin Park ?
217.13.117.* 于 2007-08-31 22:03:36发表:
Hi, nice very nice page..!
memorial scholarship fund
state insurance fund
fund raising counselor organization
cookie dough fund raiser - http://fund.freewebpages.org/alaska-permanent-fund-dividend/index.html
unique fund raising
Good luck !
PS: do you listen Linkin Park ?
80.70.18.* 于 2007-08-30 17:55:31发表:
Hi, nice very nice page..!
candy fund raising
mutual fund research
fund novel raising - http://fund.freewebpages.org/free-fund-raising-idea/index.html
fund raising event - http://fund.freewebpages.org/hedge-funds/index.html
fund raising event
Good luck !
PS: do you listen Linkin Park ?
68.180.195.* 于 2007-08-30 14:31:32发表:
Hi, nice very nice page..!
hedge funds - http://fund.freewebpages.org/child-defense-fund/index.html
fund novel raising
growth fund of america
sample fund raising letter
free fund raising idea - http://fund.freewebpages.org/sample-fund-raising-letter/index.html
Good luck !
PS: do you listen Linkin Park ?
200.195.95.* 于 2007-08-29 13:16:52发表:
Hi, nice very nice page..!
ford money market account -
best money market rate
best money market account
money market
vanguard money market funds
Good luck !
PS: do you listen Linkin Park ?
218.140.110.* 于 2007-08-27 23:57:31发表:
Hi, nice very nice page..!
best money market account - http://volny.cz/capitalmoney/high-yield-money-market-account/
money market savings account - http://www.volny.cz/moneyrate/money-market-rate/
ford money market account
ford money market account
money market account
Good luck !
PS: do you listen Linkin Park ?
65.44.66.* 于 2007-08-27 19:44:53发表:
Hi, nice very nice page..!
money market savings account
cnn money market stock - http://www.volny.cz/bestmoney/make-money-in-stock-market/
best rate on money market account
best rate on money market account
money market mutual funds
Good luck !
PS: do you listen Linkin Park ?
213.61.84.* 于 2007-08-26 02:55:30发表:
Hi, nice very nice page..!
money market interest rate - http://www.volny.cz/moneymarket/money-market-interest-rate
money banking and financial market
best rate on money market account
ford money market
make money in stock market
Good luck !
PS: do you listen Linkin Park ?
202.242.55.* 于 2007-08-25 22:58:00发表:
Hi, nice very nice page..!
best money market rate
capital money market
ford money market account
ford money market - http://www.volny.cz/moneymarket1/money-market/
money market account rate
Good luck !
PS: do you listen Linkin Park ?
82.94.203.* 于 2007-08-24 11:44:19发表:
Hi, nice very nice page..!
best rate on money market account
money market fund
best rate on money market account
ford money market account
money market - http://www.volny.cz/bestmoney/make-money-in-stock-market/
Good luck !
PS: do you listen Linkin Park ?
61.90.248.* 于 2007-08-24 08:02:47发表:
Hi, nice very nice page..!
money market mutual funds - http://www.volny.cz/marketaccount/vanguard-money-market-funds/
money banking and financial market
money market interest rate
vanguard money market funds
best money market account - http://volny.cz/capitalmoney/money-market-mutual-funds/
Good luck !
PS: do you listen Linkin Park ?
219.150.167.* 于 2007-08-18 15:40:49发表:
可惜已经不再开源了
218.22.112.* 于 2007-08-14 15:31:12发表:
good work !
chandelier lamp shades
chandelier lamp shades
chandelier lamp shades - www.desklamp1.fora.pl
buy viagra online
buy viagra online
buy viagra online - www.buyviagraonlinex.fora.pl
.
norwegian pearl
norwegian pearl
norwegian pearl - http://volny.cz/norwegianpearl
blackberry pearl white
blackberry pearl white
blackberry pearl white - http://volny.cz/blackberrypearlwhite
pink pearls
pink pearls
pink pearls - http://volny.cz/pinkpearls
blackberry pearl review
blackberry pearl review
blackberry pearl review - http://volny.cz/blackberrypearlrev
pearl white
pearl white
pearl white - http://volny.cz/pearlwhite
good luck
61.156.42.* 于 2007-08-14 13:34:10发表:
good work !
chandelier lamp shades
chandelier lamp shades
chandelier lamp shades - www.desklamp1.fora.pl
buy viagra online
buy viagra online
buy viagra online - www.buyviagraonlinex.fora.pl
.
norwegian pearl
norwegian pearl
norwegian pearl - http://volny.cz/norwegianpearl
blackberry pearl white
blackberry pearl white
blackberry pearl white - http://volny.cz/blackberrypearlwhite
pink pearls
pink pearls
pink pearls - http://volny.cz/pinkpearls
blackberry pearl review
blackberry pearl review
blackberry pearl review - http://volny.cz/blackberrypearlrev
pearl white
pearl white
pearl white - http://volny.cz/pearlwhite
good luck
221.232.159.* 于 2007-08-09 17:26:46发表:
Hi, nice very nice page..!
ford dealer clearanceford dealer clearanceford dealer clearance - www.volny.cz/forddealer
944 porsche 944 porsche 944 porsche - www.volny.cz/porsche944
gmc los angelesgmc los angeles gmc los angeles - www.volny.cz/gmclosangeles
pearl bridal jewelrypearl bridal jewelry pearl bridal jewelry - http://volny.cz/pearlbridaljewelry
gmc los angelesgmc los angeles gmc los angeles - www.volny.cz/gmclosangeles
Good luck !
PS: do you listen Linkin Park ?
60.190.223.* 于 2007-08-07 23:16:07发表:
desk lamp
desk lamp - www.halogendesklamp.freehostia.com/desk-lamp/
lamp shades
lamp shades - www.halogendesklamp.freehostia.com/lamp-shades/
office desk lamp
office desk lamp - www.halogendesklamp.freehostia.com/office-desk-lamp/
218.15.210.* 于 2007-08-07 18:45:55发表:
desk lamp
desk lamp - www.halogendesklamp.freehostia.com/desk-lamp/
lamp shades
lamp shades - www.halogendesklamp.freehostia.com/lamp-shades/
office desk lamp
office desk lamp - www.halogendesklamp.freehostia.com/office-desk-lamp/
0.0.0.* 于 2007-08-07 12:14:10发表:
gxhlajsq gqstcd bkqoepcud caukl fyaepbc efyxs psxvlykh
82.120.229.* 于 2007-08-05 21:19:51发表:
nice site... look on my site
http://www.desklamp.fora.pl - desk lamp
http://www.lampshades.fora.pl - lamp shades
59.93.204.* 于 2007-08-05 21:19:45发表:
nice site... look on my site
http://www.desklamp.fora.pl - desk lamp
http://www.lampshades.fora.pl - lamp shades
217.141.105.* 于 2007-08-05 17:15:50发表:
nice site... look on my site
http://www.desklamp.fora.pl - desk lamp
http://www.lampshades.fora.pl - lamp shades
81.169.173.* 于 2007-08-04 05:45:41发表:
thnx... nice site
and i wan't see my:
http://www.tablelamp.fora.pl/
http://www.tablelamp.fora.pl/
http://www.tablelamp.fora.pl/ - table lamp
217.141.251.* 于 2007-08-02 16:27:54发表:
diesel ford truck used
diesel ford truck used
diesel ford truck used - http://www.bcars.fora.pl/
car insurance quote
car insurance quote
car insurance quote - http://www.carinsurancequote.fora.pl/
62.231.243.* 于 2007-08-02 12:32:29发表:
diesel ford truck used
diesel ford truck used
diesel ford truck used - http://www.bcars.fora.pl/
car insurance quote
car insurance quote
car insurance quote - http://www.carinsurancequote.fora.pl/
213.239.218.* 于 2007-08-02 09:09:07发表:
extreme adult sextoons art drawings http://cartoonfox.150m.com/extreme_adult_sextoons_art_drawings.html extreme adult sextoons art drawings extreme adult sextoons art drawings
comix bondage http://cartoonfox.150m.com/comix_bondage.html comix bondage comix bondage
extreme toon sex http://cartoonfox.150m.com/extreme_toon_sex.html extreme toon sex extreme toon sex
d bondage toons http://cartoonfox.150m.com/d_bondage_toons.html d bondage toons d bondage toons
cartoon extreme cock http://cartoonfox.150m.com/cartoon_extreme_cock.html cartoon extreme cock cartoon extreme cock
220.167.25.* 于 2007-08-01 00:16:31发表:
gmc trucks here www.gmctruck.fora.pl
gmc from america www.gmctruck.fora.pl
real gmc www.gmctruck.fora.pl
and www.emeraldring.fora.pl rings
0.0.0.* 于 2007-07-31 19:30:30发表:
gmc trucks here www.gmctruck.fora.pl
gmc from america www.gmctruck.fora.pl
real gmc www.gmctruck.fora.pl
and www.emeraldring.fora.pl rings
201.74.130.* 于 2007-07-24 22:01:22发表:
6bcffc522daee3a0e11a59af922d55f7 http://cucina-bavarese-piatto-tipico.ppdpwx.biz/ http://mondo-oro-sport-frosinone.ppdpwx.biz/ http://aquisizione-audio.ygvhik.biz/ http://bozza-contratto-fornitura.iuatju.biz/ http://africa-capo-verde-capodanno.tzlnou.biz/ http://lago-di-caccamo.tzlnou.biz/ http://augurio-amore-lettera.enadzh.biz/ http://taekwondo-mattei.ygvhik.biz/ http://congressi-verona.iuatju.biz/ http://rinnovo-porto-di-pistola.tzlnou.biz/ 69fae163d26a9b1682339a4eb6fc4ad9
211.210.36.* 于 2007-07-23 12:27:34发表:
54e070aedb90f0fd85f0de86094c6103 http://gazzetta-lazio.hdpwsk.org/ http://vendita-boxer.gbdrme.org/ http://bed-and-breakfast-san-vittore-olona.pvaeyo.org/ http://consorzio-trasporto-publici-napoli.gbdrme.org/ http://scola-bruno.pvaeyo.org/ http://calcio-flash.mnkcbe.org/ http://elmo-spartano.mnkcbe.org/ http://scienze-per-bambini.cqhnnx.org/ http://custodia-stecca-biliardo.hdpwsk.org/ http://torino-ss-trinita.jnbwct.org/ eb89aa2351bfb8dd061b0dc25061dcdb
190.72.195.* 于 2007-07-20 20:15:25发表:
fb1ac3d6482ee5fbf5058e947aff6661 http://adattatoresipata.pykkxx.org/baia-imperiale-gabicce-mare/ federazione gioco calcio comitato regionale forum suoneria http://impegnoprofessionale.kcqdnd.org/cartolina-brindare-al-nuovo-anno/ http://localiafirenze.kcqdnd.org/eroina-principio-attivo-medio/ computer scuola http://venditabiciclettapontedera.pykkxx.org/cosa-contiene-modello-intra/ http://marcheascolipiceno.ghoouy.org/vino-rosso-conero/ http://cosafarecapodannomilano.nfnzro.org/nuovo-sacher-cinema/ dermatologia consulto online b8fb7d84153cc5c69600cbe1497734b2
72.51.162.* 于 2007-07-19 22:03:34发表:
free disney cartoon porn http://adultcomics19jul.tripod.com/free_disney_cartoon_porn.html free disney cartoon porn free disney cartoon porn
best cartoon porn http://adultcomics19jul.tripod.com/best_cartoon_porn.html best cartoon porn best cartoon porn
cartoon porn gallery http://adultcomics19jul.tripod.com/cartoon_porn_gallery.html cartoon porn gallery cartoon porn gallery
cartoon porn game http://adultcomics19jul.tripod.com/cartoon_porn_game.html cartoon porn game cartoon porn game
famous cartoon porn http://adultcomics19jul.tripod.com/famous_cartoon_porn.html famous cartoon porn famous cartoon porn