JDBC三种方式加载数据库驱动(源码)

    技术2022-05-12  7

    JDBC三种方式加载数据库驱动(源码)下面以Mysql为例:

    1.

     

    import java.sql.DriverManager;import java.sql.Connection;import java.sql.Statement;import java.sql.ResultSet;import java.sql.SQLException;

    public class JDBCExample{    public static void main(String orgs[]){    try{       Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动       String url="jdbc:mysql://localhost:3306/databasename";//数据库连接子协议       Connection conn=DriverManager.getConnection(url,"username","password");       Statement stmt=conn.createStatement();       ResultSet rs=stmt.executeQuery("select * from tablename");       while(rs.next()){//不断指向下一条记录            System.out.println("DeptNo:"+rs.getInt(1));            System.out.println("/tDeptName:"+rs.getString(2));            System.out.println("/tLOC:"+rs.getString(3));}             rs.close();    stmt.close();    conn.close();}catch(ClassNotFoundException e){   System.out.println("找不到指定的驱动程序类!");}catch(SQLException e){    e.printStackTrace();}}} 

    2. import java.sql.DriverManager;import java.sql.Connection;import java.sql.Statement;import java.sql.ResultSet;import java.sql.SQLException;

    public class JDBCExample2{    public static void main(String orgs[]){    try{       System.setProperty("jdbc.driver","com.mysql.jdbc.Driver");//系统属性指定数据库驱动       String url="jdbc:mysql://localhost:3306/databasename";//数据库连接子协议       Connection conn=DriverManager.getConnection(url,"username","password");       Statement stmt=conn.createStatement();       ResultSet rs=stmt.executeQuery("select * from tablename");       while(rs.next()){//不断指向下一条记录            System.out.println("DeptNo:"+rs.getInt(1));            System.out.println("/tDeptName:"+rs.getString(2));            System.out.println("/tLOC:"+rs.getString(3));}             rs.close();    stmt.close();    conn.close();}catch(SQLException e){    e.printStackTrace();}}} 

    3.

    import java.sql.DriverManager;import java.sql.Connection;import java.sql.Statement;import java.sql.ResultSet;import java.sql.SQLException;

    public class JDBCExample3{    public static void main(String orgs[]){    try{       new com.mysql.jdbc.Driver();//创建driver对象,加载数据库驱动       String url="jdbc:mysql://localhost:3306/databasename";//数据库连接子协议       Connection conn=DriverManager.getConnection(url,"username","password");       Statement stmt=conn.createStatement();       ResultSet rs=stmt.executeQuery("select * from tablename");       while(rs.next()){//不断指向下一条记录            System.out.println("DeptNo:"+rs.getInt(1));            System.out.println("/tDeptName:"+rs.getString(2));            System.out.println("/tLOC:"+rs.getString(3));}             rs.close();    stmt.close();    conn.close();}catch(SQLException e){    e.printStackTrace();}}} 


    最新回复(0)