java mysql純驅動串連

標籤：style   blog   color   io   os   ar   java   for   資料   

package SQL;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBCTest {        public static String Driver="com.mysql.jdbc.Driver";    public static String url="jdbc:mysql://127.0.0.1:3306/test";    public static String user="root";    public static String password="333";        public static void main(String[] args) {                Connection con;        Statement statement;        ResultSet rs;        try {            //載入驅動            Class.forName(Driver);            //串連資料庫            con=DriverManager.getConnection(url, user, password);                        if(!con.isClosed())                System.out.println("connect successed");                        statement=con.createStatement();            String sql="select * from tmp";                        rs=statement.executeQuery(sql);                        while(rs.next())            {                String rq=rs.getString("rq");                System.out.println("rq="+rq);            }                        rs.close();            con.close();                    } catch (ClassNotFoundException e) {            System.out.println("驅動載入失敗");            e.printStackTrace();        }catch(SQLException e){            System.out.println("sql執行失敗");            e.printStackTrace();        }catch(Exception e){                    }finally{                    }    }}

 

java mysql純驅動串連