基于国产arm64 cpu+海之舟大数据操作系统建立大数据库

海之舟大数据操作系统，是个商业操作系统，预置了大量软件,便于用户快速建立大数据库。随操作系统的服务器高效，便宜。基于debian9改良，大数据库基于postgresql-xl改良。

<% response.setcontenttype request.setcharacterencoding %> <% class.forname connection conn='DriverManager.getConnection("jdbc:postgresql://coordinator1:30001/"+"postgres","zs","1234");' statement stmt="conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE," resultset.concur_updatable>String id=request.getParameter(“id”);
String sql=“select * from t1 order by tjsj”;
ResultSet rs=stmt.executeQuery(sql);
String ss=””;
int c=0;
out.print(“
sql:”+sql);
out.print(“
bid—–id—–xm—–zh——–tjsj”);
while(rs.next())
{
out.print(“
  “+rs.getInt(1));
out.print(”    “+rs.getString(2));
out.print(”    “+rs.getString(3));
out.print(”    “+rs.getString(4));
out.print(”    “+rs.getString(6));
}
//c=Integer.parseInt(ss);
rs.close();
stmt.close();
conn.close();
%>

以下是python连接大数据库的接口范例，源码
zs@bigdataA:~/h-soft/py$ ./c.py
Opened database successfully
bid= 1
id= 6
xm= zhangsan
zh= zhangh

Operation done successfully
SELECT * from t1 where bid=1
以下是python的接口源码
zs@bigdataA:~/h-soft/py$nano ./c.py
#!/usr/bin/python
import psycopg2
sql=“SELECT * from t1 where bid=1”
conn=psycopg2.connect(database=“postgres”,user=“zs”,password=“1234”,host=“coordinator1”,port=“30002”)
print “Opened database successfully”
cur = conn.cursor()
cur.execute(sql)
rows = cur.fetchall()
for row in rows:
print “bid=”,row[0]
print “id=”,row[1]
print “xm=”,row[2]
print “zh=”,row[3], “n”
print “Operation done successfully”;
print sql;
conn.close()

java的接口范例
zs@bigdataA:~/h-soft$ cd java
zs@bigdataA:~/h-soft/java$ ls
hello.class jdbc1.class jdbc2.class jdbc3.class jdbc4.java MyXMLReader.java
hello.java jdbc1.java jdbc2.java jdbc3.java MyXMLReader.class webconfig.xml
zs@bigdataA:~/h-soft/java$ java jdbc2
INSERT INTO t1(id,xm,zh) VALUES (4, ‘Mark’, ‘Rich’)
zs@bigdataA:~/h-soft/java$ java jdbc3
Opened database successfully
UPDATE t1 set xm=‘ZhangSan’ where id=6;

bid id xm zh tjsj
1 6 ZhangSan zhangh 2019-09-25 21:39:31.701731
2 6 ZhangSan zhangh 2019-09-25 21:39:43.474549
3 6 ZhangSan zhangh 2019-09-25 21:40:05.117095
4 4 Mark Rich 2019-09-25 21:52:38.727645
SELECT * FROM t1 order by tjsj;
Operation done successfully
java 接口源码，jdbc。
zs@bigdataA:~/h-soft/java$$ nano jdbc3.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class jdbc3 {
public static void main( String args[] )
{
Connection c = null;
Statement stmt = null;
try {
Class.forName(“org.postgresql.Driver”);
c = DriverManager.getConnection(“jdbc:postgresql://coordinator1:30002/postgres”,“zs”, “1234”);
c.setAutoCommit(false);
System.out.println(“Opened database successfully”);

文章知识点与官方知识档案匹配，可进一步学习相关知识Java技能树使用JDBC操作数据库JDBC概述93881 人正在系统学习中