这篇文章从第5大块开始看
java-web
新建工作空间
新建项目
java/src/main/ org.eclipse.che.examples
下HelloWorld.java文件package org.eclipse.che.examples;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
public class HelloWorld {
private Connection conn = null;
public void MySQLDatabaseConnection() throws Exception{
try {
String driverName = "org.gjt.mm.mysql.Driver"; //获取属性文件中的内容
String url = "jdbc:mysql://172.17.0.6:3306/test?useUnicode=true&characterEncoding=utf-8"; //这里请看下街
String uname = "root"; //不变
String upwd = "password"; //不变
Class.forName(driverName);
this.conn = DriverManager.getConnection(url,uname,upwd);
}catch (Exception e){
throw e;
}
}
public Connection getConnection() {
return this.conn;
}
public void close() throws Exception{
if(this.conn!=null){
try {
this.conn.close();
}catch (Exception e){
throw e;
}
}
}
public static void main(String... argvs) throws Exception{
HelloWorld hello = new HelloWorld();
hello.MySQLDatabaseConnection();
hello.getConnection();
String a = "Che";
System.out.println("Hello World " + a + "!");
}
}
image.png
然后继续输入如下命令新建数据库
mysql -u root -p //提示输入密码,密码为password
create database test; //新建数据库
通过show databases 查看刚刚创建的数据库
点击左侧commands栏分别运行jdbc:build 和jdbc:run命令,最后控制台打印helloworld说明测试成功
image.png
image.png