首先正确安装好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)
81.35.177.* 于 2007-06-04 00:41:24发表:
1f813d1ff16ee96ff41ccf165c0e0c0b http://telaiobicilook386.akqcvy.org/martin-luter-eccetto-king/index.htm http://agorauniparthenope.nlamku.org/diva-futura-blondi/index.htm http://organizzazionebanchettomonreale.seyzuo.org/paolo-annibali-scultore/index.htm http://metzelerocchiale.akqcvy.org/droga-viale-ortles-milano/index.htm http://contestarecontravvenzioneztl.seyzuo.org/nikita-telgate/index.htm http://tritacarneamb.seyzuo.org/ford-fusion-connettore-aux-in/index.htm http://rilevatorepresenzacrepuscolare.beajbg.org/sud-soud-sistem/index.htm http://adattatoreseriale2fusb.inkrxe.org/cucciolo-tigrotti/index.htm http://paolafolliascoltamitesto.seyzuo.org/neurologia-midollo-centro-cellula-staminale/index.htm http://diagrammapsicrometricoexcel.akqcvy.org/filmato-telegiornale-combattimento-cane/index.htm 83869c431dabc6ba13fe3e3c64cc8ac5
81.39.6.* 于 2007-06-03 06:48:38发表:
81029095e82e3328b7b0f358761b6988 http://golosarhopasticceria.bdizoa.org/punto-vitali-kyusho-evan-pantazi/index.htm http://albrilloparlantetiscaliit.bdizoa.org/varia-immagine-progetto-squadriglia-scout/index.htm http://imedia3214.lskson.org/asciugatrici-rex-ra300e/index.htm http://videocitofonovivavoce.sdibjo.org/piede-sporchi-brasiliano-fetish/index.htm http://faggiopollone.shxghd.org/traduzione-spigolatrice-sapri/index.htm http://golosarhopasticceria.bdizoa.org/morsetto-multipolari-circuito-stampato/index.htm http://teuco2bidromassaggio.ksibgs.org/suicidio-maschio-angioino/index.htm http://clashnslashgratisscaricarefull.bdizoa.org/kristel-carrisi/index.htm http://golosarhopasticceria.bdizoa.org/motore-entrobordo-ruggerini/index.htm http://giovanetteculolargo.ksibgs.org/commessa-carrefour-pontecagnano/index.htm 691e5261e7f26fe9bfca38d324fb1940
201.233.85.* 于 2007-06-02 11:05:43发表:
951f41aebf68fee9609cf3e5f9dd3524 http://rilevatorepresenzacrepuscolare.beajbg.org/vendita-motospazzatrici-varese/index.htm http://boschwfo1662lavatrice.akqcvy.org/pietracatella-3000-it/index.htm http://ricaricarexverde357.nlamku.org/trinciatutto-bcs/index.htm http://boschlavastoviglieincassovogliosapereprezzo.beajbg.org/dispositivo-medico-de-giuli/index.htm http://boschlavastoviglieincassovogliosapereprezzo.beajbg.org/lista-server-valida-emule-47c/index.htm http://aishwariaraiattriceindiana.inkrxe.org/nora-amelie-nuda/index.htm http://schematecnicotvgoodmans.seyzuo.org/scaffale-gondola/index.htm http://prezzosaecocaffc3a8.inkrxe.org/mensola-estraibile-porta-tastiera/index.htm http://cralarabafenice.seyzuo.org/farmacia-comunale-vitaminic/index.htm http://bollettinouffficialedellaregionecalabria.seyzuo.org/giubotti-woolrich-military-jkt/index.htm 63aa5c5d6850cbd0ab7a0b3644130d9e
91.1.250.* 于 2007-06-01 16:20:31发表:
68c9aee1cd2948376a5901c91c638368 http://sistemanavigazionedvdmp8100.uzghnh.org/royal-horticoltural-society/index.htm http://sistemanavigazionedvdmp8100.uzghnh.org/realizzazioni-cucina-ceramica-vietri/index.htm http://viapaolinisitaostialidoroma.uzghnh.org/note-regia-teatro-sergio-ammirata-1960/index.htm http://sookyinleenuda.uzghnh.org/orecchia-tappate-alta-montagna/index.htm http://1984decretopresascart.pdjkai.org/eurorama-rubinetteria/index.htm http://camaleontecamole.gkgobd.org/analisi-testuale-taci-anima-stanca-godere/index.htm http://enab46100alluminio.mljuyb.org/as400-rubinetteria-zucchetti/index.htm http://villaggiodegliulivopalinuro.gkgobd.org/pascha-berlino/index.htm http://topcollegescomvscholarshiphtml.leikrf.org/rithm-is-dancer-testo/index.htm http://atirx1650se512mb.uzghnh.org/etichetta-peltro-bottiglia/index.htm 5447788e0ee79eeca3d64876f41eb1cf
190.38.2.* 于 2007-05-30 08:41:54发表:
69b5175420af64aee11c5f8f90cb2e80 http://mnopyi.org/ouvir/ouvir-winamp-clique.html http://wfcqxw.org/meiose/meiose-6-cromossomo.html http://mnopyi.org/supermercado/supermercado-compre-forte.html http://ifrtox.org/ingresso/ingresso-familha.html http://ifrtox.org/spa/spa-pousada-alquimia.html http://ovvkft.org/calculo/calculo-de-laje-pre-fabricada.html http://ifrtox.org/caezinhos.txt/caezinhos.html http://pegekq.org/dica/dica-jogo-mega-drive.html http://ifrtox.org/programacao/programacao-tv-globo-sbt.html http://ifrtox.org/http/http-www-marcofeliciano.html a91f06099d8916d08fc86aebeef191c8
201.248.90.* 于 2007-05-29 07:23:52发表:
ba7e4b5540e3ba8f1acbc955cbc38ea6 http://grpytd.org/anel/anel-elastico-eixo.html http://xwqumn.org/tipo/tipo-musica-axe-pagode-hip-hop.html http://xvqeoy.org/classificado/classificado-digi-br.html http://lcitij.org/nova/nova-lei-maria-penha.html http://grpytd.org/ria/ria-slids.html http://sxrzpn.org/impactos/impactos-previdenciarios-terceirizacao-servico-publico.html http://lcitij.org/foto/foto-do-assassinato-de-daniela-perez.html http://xwqumn.org/relogio/relogio-parede-carrilhoes.html http://lcitij.org/escola/escola-agrotecnicas-federais.html http://lcitij.org/aspecto/aspecto-psicologicos-demissao.html ea84313ff4cf4b8bb8ec851c693c83a5
84.122.87.* 于 2007-05-28 15:15:02发表:
b1a2afbb930640b526744bcc30b445fb http://ifrtox.info/aniversario/aniversario-de-cotia.html http://grpytd.info/significado/significado-palavra-reificacao-linguagem-politica.html http://xvqeoy.info/mulher/mulher-estupro.html http://xvqeoy.info/shurek/shurek-hotmail.html http://mnopyi.info/niely/niely-gold-carolina-ferraz.html http://grpytd.info/valor/valor-apac.html http://xvqeoy.info/site/site-ig-br-ww-meebo.html http://grpytd.info/saite/saite-prefeitura-osasco.html http://grpytd.info/sitio/sitio-laranjal-paulista.html http://xvqeoy.info/ufu.txt/ufu.html 921da3b25f91ff5411abb8e73f72697f
201.227.135.* 于 2007-05-27 23:31:57发表:
fa9234eff1be4985f0a1aef7cb9d2fa9 http://sxrzpn.info/download/download-aim-bot-gbound.html http://xwqumn.info/fiacao/fiacao-e-tecelagem.html http://wfcqxw.info/baixar/baixar-crack-the-sims-2.html http://ovvkft.info/adelino/adelino-tavares-pinheiro.html http://wfcqxw.info/scraps/scraps-personalizado.html http://xwqumn.info/terminologia/terminologia-feicoes-costeiras.html http://lcitij.info/materia/materia-lancamento-filme-cidade-anjo.html http://sxrzpn.info/foto/foto-troca-casais-maduros.html http://ovvkft.info/projeto/projeto-didaticos-em-educacao-infantil.html http://xwqumn.info/natgeo/natgeo-vida-ventre.html 6d9dd05b81c19c63ae8e87cbbcfe2050
81.165.49.* 于 2007-05-27 07:24:50发表:
14f83ce90a418df4a440dade13b9587f http://pegekq.info/tuc/tuc-na-balada.html http://pegekq.info/amigo/amigo-sempre-letra.html http://pegekq.info/maluli/maluli-com-br.html http://mnopyi.info/fato/fato-que-marcaram-a-historia-do-brasil.html http://xvqeoy.info/imagem/imagem-tatuagem-carpe-diem.html http://xvqeoy.info/cirurgia/cirurgia-plastica-reparadora-dedo.html http://pegekq.info/cd/cd-ludimila-feber.html http://xvqeoy.info/paranapanema/paranapanema-sp-muda-eucalipto.html http://grpytd.info/foto/foto-balada-porto-alegre.html http://ifrtox.info/modelo/modelo-gestao-implicacoes-formacao-identidade-educador.html 899833c87d41a40d77c99858b4681e10
70.80.234.* 于 2007-05-26 17:15:31发表:
90785a4fbaf4e8a35ebc436bdb179905 http://wfcqxw.info/simpes.txt/simpes.html http://wfcqxw.info/foto/foto-do-time-do-santos.html http://sxrzpn.info/a/a-importancia-da-amozonia-para-o-mundo.html http://sxrzpn.info/soufle/soufle-frango.html http://wfcqxw.info/triste/triste-fim-de-policarpo-quaresma.html http://xwqumn.info/zica/zica-cabelereira.html http://wfcqxw.info/bolacha/bolacha-do-mar.html http://lcitij.info/loja/loja-vendem-peca-portao-aluminio-manaus-am.html http://xwqumn.info/sebastiao/sebastiao-ferrarini.html http://lcitij.info/lg/lg-7100-gsm-brasil-telecom.html 3c6c60ce2277246c0f4063c97808fccb
201.210.155.* 于 2007-05-16 03:19:32发表:
http://6aef7944e1719997112193e4a354e7f5-t.qwoypw.info 6aef7944e1719997112193e4a354e7f5 http://6aef7944e1719997112193e4a354e7f5-b1.qwoypw.info 6aef7944e1719997112193e4a354e7f5 http://6aef7944e1719997112193e4a354e7f5-b3.qwoypw.info b43a48a848da56275457e93295654b68