JDBC链接操作Demo

来源：互联网发布：fzqkbysjw gb1 0mac 编辑：程序博客网时间：2024/04/28 09:56

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 + " ");
}
}
}