package basic; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class OracleConnection { private static final String url = "jdbc:oracle:thin:@127.0.0.1:1521:XE"; private static final String password = "fanhongjie"; private static final String username = "fanhongjie"; public static void main(String[] args) {; Connection con = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); con = DriverManager.getConnection(url, username, password); PreparedStatement ps = null; ResultSet rs = null; if (con != null) { ps = con.prepareStatement("SELECT SYSDATE FROM DUAL"); rs = ps.executeQuery(); if (rs.next()) { System.out.println(rs.getString(1)); } } rs.close(); ps.close(); con.close(); } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } } } package basic; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; /** * for connecting to the MySQL DataBase * @author fanhongjie * */ public class MySQLConnection { /** * @param args */ public static void main(String[] args) { String userName = "root"; String password = "mysql"; String url = "jdbc:mysql://localhost:3306/mysql"; String sql = "select version(), current_date()"; try { Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection(url, userName, password); String s = con.nativeSQL(sql); System.out.println(s); Statement st = con.createStatement(); ResultSet rs = st.executeQuery(sql); while (rs.next()) { System.out.println(rs.getString(1) + "/t" + rs.getString(2)); } rs.close(); st.close(); con.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } }