java链接数据库分析和总结.docx

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;

publicclassMydemo{

publicstaticfinalStringMyjdbc=jdbc:mysql://localhost:3306/student;publicstaticfinalStringUSER=root;

publicstaticfinalStringPWD=admin;

publicstaticfinalStringURL=com.mysql.jdbc.Driver;publicstaticvoidmain(String[]args){

try{

Class.forName(URL);try{

rs.getString(3));

Connectionconn=DriverManager.getConnection(Myjdbc,USER,PWD);Statementstmt=conn.createStatement();

ResultSetrs=stmt.executeQuery(select*fromscore);while(rs.next()){

System.out.println(rs.getInt(1) + - + rs.getInt(2) + - +

}

if(conn!=null){conn.close();

}

if(stmt!=null){stmt.close();

}

if(rs!=null){

rs.close();

}

}catch(SQLExceptione){e.printStackTrace();

}

}catch(ClassNotFoundExceptione){e.printStackTrace();

}

}

}

IAJaJ1lBC/5r..I.yde.o

IAJa

了Eclip5eEnl..rpri5e1orkben心 立区l

·恺｀心1.已山tom·ce瓦hc!_orI!..VlgateSe江ch[rojoctMyl!clip,o un 心1do !l?lp

·

恺｀

，i亨 邑］尽．，J＠l庄．旦．l, 昂·0]

］虔今勺千令 l:纠了图罚l袒千01宁亡 令-

el窗厅亨] ·]炒．O·Q二．q . ］也仕e.

隘i历Edtp??

＿ ＝

出Fackag汉 Q)Mydeo.java汉

—口1r李Outline筷 ［

|宝阳

llC

巳仇-

l.ostatio:final.Str:ingP勍＝＂；＂

lostatio:final.St工ingURL=com.mvsql.jdbc.Drive亡“;

lostatiovoidmain(St工ing[]a工gs)(

二 !a11决芯0\L

丑·』三importdeclarations...

E·l·-0,.My扣mo

cry{

Class.foi:NeIUR工）；try {

CDnnectiancann=DriverMa.na.ger.getConnect工0叭Myjdbc,USER,Statementstmt=conn.createStatement();

_41

沪阮dbc:Stn珀

[...JFUSER·String

·····JFPWD:String

·····,J,＿F,sURL.

·····,J

,

R己sultS己tr:s=stmt.el(ecutQu己r:y(“selectfromt);while(rs.nel(七(l)｛

System.out.println(rs.getlnt(l)+