package com.hpli.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCDEMO {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
// 驱动程序
Class.forName("com.mysql.jdbc.Driver");
// 连接的URL,cloudportal为数据库名,注意修改编码类型
String URL = "jdbc:mysql://172.18.15.135/cloudportal?useUnicode=true&characterEncoding=UTF-8";
// 用户名
String userName = "root";
// 密码
String passWord = "root";
// 链接操作
Connection conn = DriverManager.getConnection(URL, userName, passWord);
// sql語句
String sql = "select * from activity";
PreparedStatement pres = conn.prepareStatement(sql);
ResultSet rs = pres.executeQuery();
while (rs.next()) {
// 获取activity表 id 字段值
int id = rs.getInt("id");
// 获取activity表 date 字段值
String date = rs.getString("date");
// 获取activity表 language 字段值
String language = rs.getString("language");
System.err.println(id + " " + date + " " + language + " ");
}
}
}