java连接Mysql数据库

来源：互联网发布：淘宝十年产品事pdf下载编辑：程序博客网时间：2024/06/03 20:03

import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import com.mysql.jdbc.Connection;import com.mysql.jdbc.Statement;public class ConnectionTest {public static void main(String[] args) {// 加载驱动try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}// 创建连接String url = "jdbc:mysql://localhost:3306/jdbcdb";String user = "root";String pwd = "root";Connection conn = null;Statement stmt = null;int result = 0;try {conn = (Connection) DriverManager.getConnection(url, user, pwd);stmt = (Statement) conn.createStatement();String sql = "create table productss(pbrand varchar(10),ptype varchar(10),color varchar(10),price varchar(10));";String sql2 = "insert into productss values('惠普','hp-11','heise','30')";result = stmt.executeUpdate(sql);result = stmt.executeUpdate(sql2);String sql3 = "select * from productss";ResultSet r = stmt.executeQuery(sql3);if(r.next()) {System.out.println(r.getString("pbrand"));System.out.println(r.getString("color"));}conn.close();stmt.close();} catch (SQLException e) {System.out.println("链接失败");e.printStackTrace();}if (result > 0) {System.out.println("插入成功");} elseSystem.out.println("插入失败");}}

基本数据库语句：

创建表： create table 表名称(列声明);

向表中插入数据： insert [into] 表名 [(列名1, 列名2, 列名3, ...)] values (值1, 值2, 值3, ...);

查询数据： select 列名称 from 表名称 [查询条件];

主要的连接代码：

import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import com.mysql.jdbc.Connection;import com.mysql.jdbc.Statement;public class ConnectionTest {public static void main(String[] args) {// 加载驱动try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}// 创建连接//"jdbc:mysql://localhost:3306/+{你自己的数据库名字}"String url = "jdbc:mysql://localhost:3306/jdbcdb";String user = "root";String pwd = "root";Connection conn = null;Statement stmt = null;int result = 0;try {conn = (Connection) DriverManager.getConnection(url, user, pwd);stmt = (Statement) conn.createStatement();conn.close();stmt.close();} catch (SQLException e) {System.out.println("链接失败");e.printStackTrace();}}}

阅读全文

0 0