各种数据库JDBC 连接方式

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");

    }
}