Ubuntu下wxWidgets学生信息管理sqlite3
#include <sqlite3.h>
#include <cstdlib>
#include <iostream>
#include <iomanip>
using namespace std;
int main()
{
sqlite3* file;
int flag;
flag = sqlite3_open("./stu.db", &file);
if(SQLITE_OK != flag)
{
cout<<"Database connect failed!"<<endl;
exit(-1);
}
cout<<"Database connect successes!"<<endl;
char** r;
int row, col;
char* errmsg;
string sql = "select * from stu";
flag = sqlite3_get_table(file, sql.c_str(), &r, &row, &col, &errmsg);
if(SQLITE_OK == flag)
{
cout<<"Statement executes sucesses!"<<endl;
int i, j;
for(i = 0; i <= row; i++)
{
for(j = 0; j < col; j++)
{
cout<<r[i*col+j]<<' ';
}
cout<<endl;
}
}
sqlite3_close(file);
return 0;
}
makefile
all: main.o
g++ main.o -o t.exe -lsqlite3
main.o: main.cxx
g++ -c main.cxx -o main.o
.PHONY:clean
clean:
rm main.o t.exe
ubuntu@ubuntu-virtual-machine:~$ sudo apt-get install sqlite3
2.安装成功后测试会出现
ubuntu@ubuntu-virtual-machine:~$ sqlite3
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .exit
3.查找sqlite3的路径
ubuntu@ubuntu-virtual-machine:~$ which sqlite3
/usr/bin/sqlite3
ubuntu@ubuntu-virtual-machine:~$ ls
core OSlab1 Public Videos
Desktop OSlab2 Qt vmwaretools
Documents OSlab3 sqlite-amalgamation-3080403 wx
Downloads OSlab4 sqlite-amalgamation-3080403.zip wx3.0
examples.desktop OSlab5 StuMana wxlab
Music Pictures Templates
4.具体sqlite3操作的实例
ubuntu@ubuntu-virtual-machine:~$ mkdir mydb
ubuntu@ubuntu-virtual-machine:~$ cd mydb
ubuntu@ubuntu-virtual-machine:~/mydb$ ls
ubuntu@ubuntu-virtual-machine:~/mydb$ sqlite3 stu.db
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table stu(sno int primary key, sname text not null, sage int);
sqlite> insert into stu(1, 'Lisi', 20);
Error: near "1": syntax error
sqlite> insert into stu values(1, 'lisi', 20);
sqlite> insert into stu values(2, 'zhangsan', 18);
sqlite> select * from stu;
1|lisi|20
2|zhangsan|18
sqlite> .exit
ubuntu@ubuntu-virtual-machine:~/mydb$ ls
stu.db
6.记着在CodeBlocks的link 那里添加 libsqlite3.so和libsqlite3.so.0的路径(usr/local/lib)
5.具体sqlite3操作的实例
ubuntu@ubuntu-virtual-machine:~$ cd StuMana
ubuntu@ubuntu-virtual-machine:~/StuMana$ sqlite3 stuinfo.db
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table stuinfo (id char(10),name char(15) not null,dormitoryid char(20) not null,phone char(11),qq char(13));
sqlite> insert into stuinfo values('1115115247','LiYa','15#501','15530061772','614100932');
sqlite> insert into stuinfo values('1115115276','ZhangAihua','15#424','18330000036','627100056');
sqlite> select * from stuinfo;
1115115247|LiYa|15#501|15500761772|614100932
1115115276|ZhangAihua|15#424|18330000036|627100056
sqlite> .exit
ubuntu@ubuntu-virtual-machine:~/StuMana$ ls
bin stuinfo.db StuMana.depend WxWizFrame.fbp
GUIFrame.cpp StuManaApp.cpp StuMana.layout WxWizFrame.fbp.bak
GUIFrame.h StuManaApp.h StuManaMain.cpp
obj StuMana.cbp StuManaMain.h
ubuntu@ubuntu-virtual-machine:~/StuMana$
6.在CodeBlocks的link 那里添加 libsqlite3.so和libsqlite3.so.0的路径(usr/local/lib)
相关文章
- ubuntu外接显示器无信号_ubuntu笔记本外接显示器
- ubuntu强制修改密码_debian修改密码命令
- Ubuntu linux 为啥要开始选择ubuntu LINUX
- Ubuntu远程连接MySQL(connection refused)解决方法
- 在Ubuntu/Linux环境下MySQL如何开放修改3306端口和开放访问权限
- Ubuntu下安装mongodb 3.4的详细过程
- VMware安装虚拟机Ubuntu提示piix4_smbus 0000:00:007.3: Host SMBus controller not enabled错误解决办法详解程序员
- Ubuntu与Linux之间的区别(ubuntu和linux的区别)
- 出错Ubuntu安装Linux失败记录(ubuntu装linux)
- Ubuntu离线环境下MySQL安装指南(ubuntu离线安装mysql)
- Ubuntu 14.10 发布日程更新
- Ubuntu 软件中心将在 16.04 LTS 中被替换
- 那些乌央乌央的、普普通通的 Ubuntu 用户们
- 安装Ubuntu系统,轻松使用Oracle(ubuntu安装oracle)
- Ubuntu下搭建MSSQL服务器快速入门(ubuntu mssql)
- android开发教程之ubuntu使用adb连接小米2的步骤和adb调试方法