java连接各种数据库

来源：互联网发布：单片机上拉电阻原理图编辑：程序博客网时间：2024/05/02 20:20

1，Java连接SqlServer

package test;

import java.sql.*;
public class Test
{
public static void main(String[] args)
{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
String dbURL = "jdbc:sqlserver://your ip:1433"; //连接服务器和数据库
String userName = "sa"; //默认用户名
String userPwd = "123456"; //密码

Connection dbConn;

try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("连接成功"); //如果连接成功控制台输出Connection Successful!
} catch (Exception e) {
e.printStackTrace();
}
}
}

2Java连接inforbright

package inforbright;

import java.sql.Connection;
import java.sql.DriverManager;
public class Bright
{
public static void main(String[] args)
{
String driverName = "com.mysql.jdbc.Driver"; //加载JDBC驱动
String dbURL = "jdbc:mysql://your ip:5029"; //连接服务器和数据库
String userName = "root"; //默认用户名
String userPwd = "123"; //密码

try {
Class.forName(driverName).newInstance();
Connection dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("连接成功"); //如果连接成功控制台输出Connection Successful!
} catch (Exception e) {
e.printStackTrace();
}
}
}

3.java连接mysql

import java.sql.Connection;
import java.sql.DriverManager;
public class Bright
{
public static void main(String[] args)
{
String driverName = "com.mysql.jdbc.Driver"; //加载JDBC驱动
String dbURL = "jdbc:mysql://your ip:3306"; //连接服务器和数据库
String userName = "root"; //默认用户名
String userPwd = "123"; //密码

try {
Class.forName(driverName).newInstance();
Connection dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("连接成功"); //如果连接成功控制台输出Connection Successful!
} catch (Exception e) {
e.printStackTrace();
}
}
}

0 0