Java(54):Java 连接MySQL数据库进行操作
首先:Java 连接 MySQL 需要驱动包,最新版下载地址为:http://dev.mysql.com/downloads/connector/j/,解压后得到 jar 库文件,然后在对应的项目中导入该库文件。
1.1、IDEA的项目中导入数据库的jar包:
导入mysql-connector-java-5.1.48.jar
引用类import java.sql.*;
1.2、加载驱动与连接数据库方式如下:
Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://10.1.1.191:3306/demo?useUnicode=yes&characterEncoding=UTF-8&useSSL=false","root","123456"); |
创建表和插入数据
CREATE TABLE `score2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `useid` int(11) NULL DEFAULT NULL, `math` varchar(255) NULL DEFAULT NULL, `score` bigint(30) NULL DEFAULT NULL, PRIMARY KEY (`id`) ) |
插入数据:
INSERT INTO `score` VALUES (1, 10001, '数学', 78); INSERT INTO `score` VALUES (2, 10002, '语文', 90); |
1.3、连接数据库例子
import java.sql.*;
public class MysqlDemo {
static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
static final String DB_URL="jdbc:mysql://10.1.1.191:3306/demo?useUnicode=yes&characterEncoding=UTF-8&useSSL=false";
static final String USER = "root";
static final String PASSWORD = "123456";
public static void main(String[] args){
//System.out.println("Hello World!");
Connection conn = null;
Statement stmt = null;
try{
//注册 JDBC 驱动
Class.forName(JDBC_DRIVER);
//打开链接
System.out.println("Connect DB...");
conn=DriverManager.getConnection(DB_URL,USER,PASSWORD);
//执行查询
System.out.println("实例化Statement对象...");
stmt = conn.createStatement();
String sql;
sql = "SELECT id, useid, math FROM score";
ResultSet rs = stmt.executeQuery(sql);
//展开结果集数据库
System.out.println("编号"+"\t"+"用户id"+"\t"+"年龄");
while (rs.next()){
System.out.print(rs.getInt(1) + "\t");
System.out.print(rs.getInt(2) + "\t");
System.out.print(rs.getString(3) + "\t");
System.out.println();
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
1.4输出结果