package com.yangxiutian;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Test {
@org.junit.Test
public void testJDBC() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("加载驱动失败。。。");
}
//MySql连接对象名称
//?useUnicode=true&characterEncoding=utf8 指定编码,也可以不指定
//3306数据库开放的端口号
//192.168.1.101机器的ip地址(本机用localhost,对本机来说 只能用内网ip不能用外网ip)
String url="jdbc:mysql://192.168.1.101:3306/MySql?useUnicode=true&characterEncoding=utf8";
String user="root";
String password="root";
Connection conn=null;
try {
conn=DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("获取连接失败。。。");
}
System.out.println(conn);
}
}