
正文
jdbc连接sqlserver,mysql,oracle
提示:扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
class xxx{
private static String port = "1433";
private static String ip = "192.168.2.163";
//mysql : jdbc:mysql://
//sqlserver : jdbc:sqlserver// 或者 jdbc:microsoft:sqlserver://
private static String driverType = "jdbc:sqlserver://";
private static String DatabaseName = "test";
private static String username = "sa";
private static String password = "123456";
//sqlerver数据库 com.microsoft.sqlserver.jdbc.SQLServerDriver驱动
//mysql 数据库 com.mysql.jdbc.Driver 驱动
private static String Drivermanager = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//取得本地保存的自定义标识
private static Map<String,String> localMap = new HashMap<>();
//接收到数据库返回的自定义标识
private static Map<String,Member> databaseMap = new HashMap<>();
//本地保存拼接标识文件
private static String FileSavePath = "E:/check/ckeckMemberInfoforJZ/member001.data";
private static String catchMemberSql = "select * from memberUpdate";
private static String catchCardNotSql = "";//获取数据库连接,执行目的语句
private static ResultSet getJdbcConnet(String directSql){
Connection connection;
Statement statement;
ResultSet resultSet = null;
//拼接成稳定的URL
try {
String basicUrl = driverType+ip+":"+port+";DatabaseName="+DatabaseName;
Class.forName(Drivermanager).newInstance();
connection = DriverManager.getConnection( basicUrl,
username, password);
System.out.println("jdbc connect success");
statement = connection.createStatement();
resultSet = statement.excute(directSql);
}catch (ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e){
e.printStackTrace();
}catch (IllegalAccessException e){
e.printStackTrace();
}catch (InstantiationException e){
e.printStackTrace();
}
return resultSet;
}
特别说明url:
1:sqlserver
jdbc:sqlserver://192.168.2.163:1433;DatabaseName=test
2:mysql
jdbc:mysql://localhost:3306/databasename?useUnicode=true&characterEncoding=utf8
拼接url时需注意。







