首页 > 代码库 > java mysql纯驱动连接

java mysql纯驱动连接

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纯驱动连接