JDBC入门——mysql连接方法

来源：互联网发布：mac替身文件怎么恢复编辑：程序博客网时间：2024/05/19 03:44

程序代码：

import java.sql.*;/** * Created by matt on 2017/6/12. * JDBC入门案例：展示编码步骤 * 任务目标：把数据库中 */public class JdbcDemo1 {    public static void main(String[] args) throws SQLException {        // 1 注册驱动        DriverManager.registerDriver(new com.mysql.jdbc.Driver());        // 2 获取与数据库的连接        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/day12?useSSL=true", "root", "root");        System.out.println(conn.getClass().getName());        // 3 创建代表SQL语句的对象        Statement stmt = conn.createStatement();        // 4 执行SQL语句        ResultSet rs = stmt.executeQuery("select id,name,password,email,birthday from users");        // 5 如果是查询语句：返回结果集        while (rs.next()) {            System.out.println(rs.getObject("id"));            System.out.println(rs.getObject("name"));            System.out.println(rs.getObject("password"));            System.out.println(rs.getObject("email"));            System.out.println(rs.getObject("birthday"));            System.out.println("----------------------------");        }        // 6 释放资源        rs.close();        stmt.close();        conn.close();    }}

运行结果：

com.mysql.jdbc.JDBC4Connection1zs123456zs@sina.com1980-12-04----------------------------2lisi123456lisi@sina.com1981-12-04----------------------------3wangwu123456wangwu@sina.com1979-12-04----------------------------Process finished with exit code 0

附sql建表文件：

-- MySQL dump 10.13  Distrib 5.7.18, for macos10.12 (x86_64)---- Host: localhost    Database: day12-- -------------------------------------------------------- Server version   5.7.18/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `users`--DROP TABLE IF EXISTS `users`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `users` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(40) DEFAULT NULL,  `password` varchar(40) DEFAULT NULL,  `email` varchar(60) DEFAULT NULL,  `birthday` date DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `users`--LOCK TABLES `users` WRITE;/*!40000 ALTER TABLE `users` DISABLE KEYS */;INSERT INTO `users` VALUES (1,'zs','123456','zs@sina.com','1980-12-04'),(2,'lisi','123456','lisi@sina.com','1981-12-04'),(3,'wangwu','123456','wangwu@sina.com','1979-12-04');/*!40000 ALTER TABLE `users` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2017-06-12  9:34:29

阅读全文

0 0