国产瀚高数据库简单实践 及 authentication method 13 not supported 错误解决方法

 1 php
 2    $host        = "host=192.168.2.114";
 3    $port        = "port=5866";
 4    $dbname      = "dbname=longware";
 5    $credentials = "user=sysdba password=Aa123!";
 6 
 7    $db = pg_connect("$host $port $dbname $credentials");
 8    if(!$db){
 9        echo "Error : Unable to open database 
";
10    } else {
11        echo "Opened database successfully 
";
12    }
13 
14    //创建数据表
15    $sql ="CREATE TABLE IF NOT EXISTS COMPANY (".
16           "ID INT PRIMARY KEY NOT NULL,".
17           "NAME TEXT NOT NULL,".
18           "AGE INT NOT NULL,".
19           "ADDRESS CHAR(50)," .
20           "SALARY REAL".
21         ");";
22 
23    $ret = pg_query($db, $sql);
24    if(!$ret){
25        echo pg_last_error($db);
26        exit;
27    } else {
28        echo "Table created successfully 
";
29    }
30 
31    //插入数据
32    $sql ="INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)".
33          "VALUES (1, 'Paul', 32, 'California', 20000.00 );".
34          "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)".
35          "VALUES (2, 'Allen', 25, 'Texas', 15000.00 );".
36          "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)".
37          "VALUES (3, 'Teddy', 23, 'Norway', 20000.00 );".
38          "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)".
39          "VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );";
40 
41     $ret = pg_query($db, $sql);
42     if(!$ret){
43         echo pg_last_error($db);
44         exit;
45     } else {
46         echo "Records created successfully 
";
47     }
48 
49     //查询数据
50     $sql ="SELECT * from COMPANY;";
51 
52     $ret = pg_query($db, $sql);
53     if(!$ret){
54         echo pg_last_error($db);
55         exit;
56     }
57     while($row = pg_fetch_row($ret)){
58       echo "ID = ". $row[0] . "n";
59       echo "NAME = ". $row[1] ."n";
60       echo "ADDRESS = ". $row[2] ."n";
61       echo "SALARY =  ".$row[4] ."
";
62     }
63    echo "Operation done successfully
";
64    pg_close($db);
65 ?>

php
header("content-type:text/html;charset=utf-8");

//连接属性
$dbms='pgsql';     //数据库类型
$host='192.168.2.114'; //数据库主机名
$dbName='longware';    //使用的数据库
$user='sysdba';      //数据库连接用户名
$pass='Aa123!';   //对应的密码
$port='5866';
$dsn="$dbms:host=$host;port=$port;dbname=$dbName";

try {
    //初始化一个PDO对象
    $pdo = new PDO($dsn, $user, $pass); //初始化一个PDO对象
    echo "成功连接到数据库服务器！
";

} catch (PDOException $e) {
    die ("Error!: " . $e->getMessage() . "
");
}

/*
CREATE SEQUENC Estudent_id_seq
INCREMENT 1
MINVALUE 1
NO MAXVALUE
START 1
CACHE 10;

CREATE TABLE student (
id INT PRIMARY KEY DEFAULT nextval('student_id_seq'),
name VARCHAR(255),
age int,
birthday date);
*/

// 预编译插入语句
$sql = 'INSERT INTO student(id, name, age, birthday) VALUES(DEFAULT, :name, :age, :birthday)';
服务器托管网$stmt = $pdo->prepare($sql);

// 绑定参数值
$name = 'tony';
$age=19;
$birthday = '2020-06-01 20:11:11';
$stmt->bindValue(':name', $name);
$stmt->bindValue(':age', $age);
$stmt->bindValue(':birthday', $birthday);
$stmt->execute();// 执行插入操作

// 返回id
$id = $pdo->lastInsertId('student_id_seq');
echo '插入数据成功，用户id：' . $id . '
';

// 绑定参数值
$name = 'david';
$age=23;
$stmt->bindValue(':name', $name);
$stmt->bindValue(':age', $age);
$stmt->bindValue(':birthday', date("Y-m-d H:i:s"));
$stmt->execute();// 执行插入操作

// 返回id
$id = $pdo->lastInsertId('student_id_seq');
echo '插入数据成功，用户id：' . $id . '
';

// 执行查询语句
$stmt = $pdo->query('SELECT * FROM student');
$students = [];
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $students[] = [
        'id' => $row['id'],
        'name' => $row['name'],
        'age' => $row['age'],
        'birthday' => $row['birthday']
    ];
}
?>



    
        table {
            font-family: arial, sans-serif;
            border-collapse: collapse;
            width: 100%;
        }

        td, th {
            border: 1px solid #dddddd;
            text-align: left;
            padding: 8px;
        }

        tr:nth-child(even) {
            background-color: #00bb00;
        }
    
    


学生列表

<?php endforeach; ?>

 1 package hgdb;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.ResultSet;
 6 import java.sql.Statement;
 7 
 8 public class testhighgo {
 9 
10     public static void main(String[] args) {
11         Connection ct = null;
12         Statement sm = null;
13         ResultSet rs = null;
14         try {
15             // 加载HighGo DB的驱动
16             Class.forName("com.highgo.jdbc.Driver");
17             ct = DriverManager.getConnection("jdbc:highgo://192.168.2.114:5866/longware", "sysdba", "Aa123!");
18             sm = ct.createStatement();
19             // 执行查询语句
20             String sql = "select * from t1 order by 1";
21             System.out.println("sql=====" + sql);
22             rs = sm.executeQuery(sql);
23             // 循环结果，并打印
24             while (rs.next()) {
25                 System.out.println("====" + rs.getString(2) + "====" + rs.getString(1));
26             }
27             // 抛出异常
28         } catch (Exception e) {
29             e.printStackTrace();
30         } finally {
31             // 关闭数据库连接
32             try {
33                 if (rs != null) {
34                     rs.close();
35                 }
36                 if (sm != null) {
37                     sm.close();
38                 }
39                 if (ct != null) {
40                     ct.close();
41                 }
42             } catch (Exception ex) {
43                 ex.printStackTrace();
44             }
45         }
46     }
47 
48 }