Android 通过JDBC连接Oracle Mysql Sqlserver

//通过JDBC连接Oracle

 private void conOracle(){

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

            String url ="jdbc:oracle:thin:@192.168.0.5:1522:purchasedb";//链接数据库语句

            java.sql.Connection conn= (java.sql.Connection) DriverManager.getConnection(url,"ty","123"); //链接数据库

            java.sql.Statement stmt=(java.sql.Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

            String sql="select * from s_dict_data";//查询user表语句

            ResultSet rs=stmt.executeQuery(sql);//执行查询

            StringBuilder str=new StringBuilder();

            while(rs.next()){

            str.append(rs.getString(1)+"\n");

            }

            mSetText(str.toString());

            rs.close();    

            stmt.close();

            conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

 

 

//通过JDBC连接MySql

 private void conMysql(){

try {

Class.forName("com.mysql.jdbc.Driver");

            String url ="jdbc:mysql://192.168.0.3:3306/schedule";//链接数据库语句

            com.mysql.jdbc.Connection conn= (com.mysql.jdbc.Connection) DriverManager.getConnection(url,"root","newland"); //链接数据库

            com.mysql.jdbc.Statement stmt=(com.mysql.jdbc.Statement) conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

            String sql="select * from project";//查询user表语句

            ResultSet rs=stmt.executeQuery(sql);//执行查询

            StringBuilder str=new StringBuilder();

            while(rs.next()){

            str.append(rs.getString(1)+"\n");

            }

            mSetText(str.toString());

            System.out.println(str.toString());

            rs.close();    

            stmt.close();

            conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

 

//通过JSBC连接SQLServer

private void conSqlserver(){

try {

Class.forName("net.sourceforge.jtds.jdbc.Driver");

            String url ="jdbc:jtds:sqlserver://192.168.36.131:1433/EIS";//链接数据库语句

            java.sql.Connection conn= (java.sql.Connection) DriverManager.getConnection(url,"sa","123"); //链接数据库

            java.sql.Statement stmt=(java.sql.Statement) conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

            String sql="select * from aa";//查询user表语句

            ResultSet rs=stmt.executeQuery(sql);//执行查询

            StringBuilder str=new StringBuilder();

            while(rs.next()){

            str.append(rs.getString(1)+"\n");

            str.append(rs.getString(2)+"\n");

            }

            System.out.println(str.toString());

            mSetText(str.toString());

            rs.close();    

            stmt.close();

            conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}