#Ubuntu14.04 Java连接MySql数据库
注:需要配置好MySql环境。
1)下载JDBC(驱动):mysql-connector-java-5.1.41.tar.gz
2)解压,得到mysql-connector-java-5.1.41文件夹
3)将文件夹中的mysql-connector-java-5.1.41-bin.jar 包复制到jdk的jre/lib/ext目录下:sudo cp mysql-connector-java-5.1.41-bin.jar /opt/java/jdk1.8.0_121/jre/lib/ext
4)完成配置
5)连接MySql数据库测试
mysql.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class mysql {
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
try(
// MySql数据库URl写法:jdbc:mysql://hostname:port/databasename, user, password
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/yang", "root", "123456");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from bbb_article");
)
{
while(rs.next()){
System.out.println(rs.getString(1) + "\t"
+ rs.getString(2) + "\t"
+ rs.getString(3) + "\t"
+ rs.getString(4));
}
}
}
}
输出:
1 love 2016 i love you.
证明连接数据库成功。