![](https://iknow-base.cdn.bcebos.com/lxb/notice.png)
如何用Eclipse连接MySQL数据库
2016-01-26 · 百度知道合伙人官方认证企业
![](https://wyw-base.cdn.bcebos.com/pc-content/follow.gif)
一、在MySql中创建数据库,并创建表,向表中插入数据
1、创建数据库
create database select_test
2、创建表
create table teacher_table(
Id int,
Name Varchar(20),
Sex Varchar(2)
)
3、向表中插入数据(这里插入三条测试数据)
insert into teacher_table values(1,'zhangsan','ma');
insert into teacher_table values(2,'lisi','fe');
insert into teacher_table values(3,'wangwu','ma');
二、配置Eclipse。
配置之前请先下载mysql-connector-java-5.1.15-bin.jar文件。
右键单击包所在的工程包(project),Build Path ---> Configure Build Path,在弹出的窗口中选择 Add External JARs。把你下载并解压出来的mysql-connector-java-5.1.15-bin.jar选中。如图
数据库名:select_test
用户名:root
密码:123456
连接成功后显示teacher_table表中的数据。
import java.sql.*;
class ConnMySql {
/**
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/select_test",
"root","123456");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from teacher_table");
while (rs.next()) {
System.out.println(rs.getInt(1) + "\t"
+rs.getString(2) + "\t"
+rs.getString(3) );
}
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}
}
![](https://ecmc.bdimg.com/public03/b4cb859ca634443212c22993b0c87088.png)
2024-08-19 广告
2016-01-24
DWORD WINAPI FunProc2(LPVOID lpParameter);
static int ticket=100;