各种数据库JDBC 连接方式

来源：互联网发布：js文件上传原理编辑：程序博客网时间：2024/05/17 23:38

MySQL：

package sql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class ConMysql {    private static String driver="com.mysql.jdbc.Driver";    private static String url="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8";     /**     * @param 2005 sql server      * @return 需要mysql 驱动 数据服务要启动     */    public static void main(String[] args) {        try {//          Class.forName(driver);            Connection conn=DriverManager.getConnection(url,"root","mysql");            System.out.println("ok");        } catch (SQLException e) {            e.printStackTrace();        }    }}

ServerSQL

package sql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class ConSerSql {    private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";    private static String url="jdbc:sqlserver://localhost:1433; DatabaseName=xxdb";     /**     * @param 2005 sql server      * @return 需要jdbc 驱动 数据服务要启动，另外要配置SQLEXPRESS 的协议 开启 TCP/IP 1433 端口     */    public static void main(String[] args) {        try {            Class.forName(driver);            Connection conn=DriverManager.getConnection(url,"sa","");            System.out.println("ok");        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        }    }}

Sqlite

package sql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class ConSqlite {    private static String driver="org.sqlite.JDBC";    private static String db="jdbc:sqlite:test.db";    public static void main(String[] args)  {        //加载驱动        try {            Class.forName(driver);            Connection conn=DriverManager.getConnection(db);            System.out.println("ok");            String sql="select *from user";            Statement stmt=conn.createStatement();            ResultSet rs=stmt.executeQuery(sql);            String name=null;            while (rs.next()) {                System.out.println(rs.getString(1));                name=rs.getString("name");                System.out.println(name);            }        } catch (Exception e) {            // TODO Auto-generated catch block            e.printStackTrace();        }//       Connection c = null;//          try {//            Class.forName("org.sqlite.JDBC");//            c = DriverManager.getConnection("jdbc:sqlite:test.db");//          } catch ( Exception e ) {//            System.err.println( e.getClass().getName() + ": " + e.getMessage() );//            System.exit(0);//          }//          System.out.println("Opened database successfully");    }}

0 0