Home Database Mysql Tutorial MySQL和MyEclipse的数据库连接操作

MySQL和MyEclipse的数据库连接操作

Jun 07, 2016 pm 03:28 PM
myeclipse mysql operate database connect

一、已经正确安装MySQL数据库和MyEclipse软件。 二、本人在doc下建立数据库school(名)和表(StudentInfo) 进入doc后:相关代码参考 show databases; 展示所有数据库 exit; 推出doc create database School; 创建一个数据库 use School; 进入数据库 create

一、已经正确安装MySQL数据库和MyEclipse软件。
二、本人在doc下建立数据库school(名)和表(StudentInfo)
进入doc后:相关代码参考
show databases;
展示所有数据库
exit;
推出doc
create database School;
创建一个数据库
use School;
进入数据库
create table StudentInfo(
name char(10),
age char(3) );
建表
insert StudentInfo(name,age)
VALUES(‘大卫’,’18’);
插入数据
select *from StudentInfo;
查询
update StudentInfo set age=’12’ where name=’xidada’;
更新数据
insert into studentInfo (name,age)values(‘晶竹’,20);
插入数据
delete from StudentInfo where age=’20’;
删除数据
三、在MyEclipse中建立Javaproject(名为Show)
右键点击Show——〉BuildPath——〉AddExtrenalArchives…添加(提前下载好的JdbC压缩包中mysql-connector-java-5.0.8-bin.jar)
四、建立class类(名为Show)以及相关测试代码如下:
import java.sql.*;
public class Show
{
public static void main(String[] args)
{
try
{
String url=”jdbc:mysql://localhost:3306/school”;//school为要连接的数据库名
String user=”root”;
String pwd=”root”;

<code>//加载mysql的驱动,这一句也可写为:Class.forName("com.mysql.jdbc.Driver").newInstance();
  Class.forName("com.mysql.jdbc.Driver");

  //调用DriverManager对象的方法,获得一个Connection对象,表示打开的连接。与MySQL建立连接。
   Connection conn = DriverManager.getConnection(url,user, pwd);

  //使用Connection接口的方法,创建一个Statement语句对象,用于传递简单的不带参数的SQL语句给数据库管理系统来执行。
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery("select * from studentInfo");

   //处理结果集
  while (rs.next())
  {
    String name = rs.getString("name");
    System.out.print("name-----"+name);
    String age=rs.getString("age");
    System.out.println("age------"+age);
  }
//关闭连接
  rs.close();
  stmt.close();
  conn.close();
}
catch (Exception ex)
{
  System.out.println("Error : " + ex.toString());
}
</code>
Copy after login

}
}
五、运行结果。
name—–?ó??age——12
name—–?§??age——18
结果如下则连接数据库成功。
六、后续问题?
运行结果中的乱码问题如何解决?
name—–?ó?? age——12

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1670
14
PHP Tutorial
1274
29
C# Tutorial
1256
24
MySQL and phpMyAdmin: Core Features and Functions MySQL and phpMyAdmin: Core Features and Functions Apr 22, 2025 am 12:12 AM

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

Oracle's Role in the Business World Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

Explain the purpose of foreign keys in MySQL. Explain the purpose of foreign keys in MySQL. Apr 25, 2025 am 12:17 AM

In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

Compare and contrast MySQL and MariaDB. Compare and contrast MySQL and MariaDB. Apr 26, 2025 am 12:08 AM

The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.

SQL vs. MySQL: Clarifying the Relationship Between the Two SQL vs. MySQL: Clarifying the Relationship Between the Two Apr 24, 2025 am 12:02 AM

SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.

Redis: Understanding Its Architecture and Purpose Redis: Understanding Its Architecture and Purpose Apr 26, 2025 am 12:11 AM

Redis is a memory data structure storage system, mainly used as a database, cache and message broker. Its core features include single-threaded model, I/O multiplexing, persistence mechanism, replication and clustering functions. Redis is commonly used in practical applications for caching, session storage, and message queues. It can significantly improve its performance by selecting the right data structure, using pipelines and transactions, and monitoring and tuning.

MySQL: The Database, phpMyAdmin: The Management Interface MySQL: The Database, phpMyAdmin: The Management Interface Apr 29, 2025 am 12:44 AM

MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

How does MySQL differ from Oracle? How does MySQL differ from Oracle? Apr 22, 2025 pm 05:57 PM

MySQL is suitable for rapid development and small and medium-sized applications, while Oracle is suitable for large enterprises and high availability needs. 1) MySQL is open source and easy to use, suitable for web applications and small and medium-sized enterprises. 2) Oracle is powerful and suitable for large enterprises and government agencies. 3) MySQL supports a variety of storage engines, and Oracle provides rich enterprise-level functions.

See all articles