????1 ????????????
????2 ??????????????? Class.forName("??????");
????3 ????? url usename password url
????4 ?????DriverManager???Connection
??????????
????package jdbC;
????import java.sql.DriverManager;
????import java.sql.ResultSet;
????import java.sql.SQLException;
????import java.sql.Statement;
????import org.junit.Test;
????import java.sql.Connection;
????public class demo {
????@Test
????public void test() throws ClassNotFoundException?? SQLException{
????Class.forName("com.mysql.jdbc.Driver");//?????????? ?????????к??о??????飬?????????????????
????//jdbc4.0?????????д??仰???????????????????д??
????//???????DriverManager.deregisterDriver(new com.mysql.jdbc.Driver());
????String url="jdbc:mysql://localhost:3306/?????????????";//(????3306??????????)??jdbc??mysqlЭ?????
????String username="root";//(?????????ó??????)
????String password="????";
????Connection con= DriverManager.getConnection(url?? username?? password);
????//???????????
????//???Connection????Statement????
????//Statement?????????????sql????????????????в???
????//????????int executeUpdate??String sql????????ResultSet exectuQuery???????int???????????У?ResultSet?????????
????Statement steta=con.createStatement();
????String sql="SELECT *FROM ?????????";
????ResultSet rs=steta.executeQuery(sql);//????????????
????// System.out.println(rs);
????//?????н???
????//???й???????????? ???rs.next();
????//rs???????getXxx(????????1?????????д?е?????)????
????while(rs.next()){
????System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getString(7)+" "+rs.getString(8));
????}
????//?????????
????//?????????????
????rs.close();
????steta.close();
????con.close();
????}
??????Щ??????????????????????д????淶???????
????//???????mysq????????
????@Test
????public void standard(){
????Connection con=null;
????Statement statement=null;
????ResultSet rSet=null;
????try {
????String classname="com.mysql.jdbc.Driver";
????String url="jdbc:mysql://localhost:3306/??????????";
????String username="root";
????String password="????";
????String sql="SELECT *FROM ??????????";
????Class.forName(classname);
????con=DriverManager.getConnection(url?? username?? password);
????statement=con.createStatement();
????rSet=statement.executeQuery(sql);
????while(rSet.next()){
????System.out.println(rSet.getString(1)+" "+rSet.getString(2)+" "+rSet.getString(3)+" "+rSet.getString(4)+" "+rSet.getString(5)+" "+rSet.getString(6)+" "+rSet.getString(7)+" "+rSet.getString(8));
????}
????} catch (Exception e) {
????e.printStackTrace();
????}finally{
????if(rSet!=null)
????try {
????rSet.close();
????} catch (SQLException e) {
????e.printStackTrace();
????}
????if(statement!=null)
????try {
????statement.close();
????} catch (SQLException e) {
????e.printStackTrace();
????}
????if(con!=null)
????try {
????con.close();
????} catch (SQLException e) {
????e.printStackTrace();
????}
????}
????}