sqlite安装与学习
来源:互联网 发布:开淘宝店货源从哪来 编辑:程序博客网 时间:2024/03/29 22:09
图形化管理工具:sqlite developer
创建数据库:sqlite3 test.db
创建表格:
create table employee(
id integer primary key autoincrement,
name varchar(20),
pwd varchar(20),
age integer
);
插入数据:
insert into employee(name,pwd,age) values('zhaodeng','1234','25');
insert into employee(name,pwd,age) values('Tom','1234','30');
查询显示数据
select * from employee;
cmd操作展示:
Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\ZhaoD>d:
D:\>cd D:\Jdk-eclipsejee-tomcat-ant\sqlite
D:\Jdk-eclipsejee-tomcat-ant\sqlite>sqlite3 test.db
SQLite version 3.11.1 2016-03-03 16:17:53
Enter ".help" for usage hints.
sqlite> create table employee(
...> id integer primary key autoincrement,
...> name varchar(20),
...> pwd varchar(20),
...> age integer
...> );
sqlite> insert into employee(name,pwd,age) values('zhaodeng','1234','25');
sqlite> insert into employee(name,pwd,age) values('Tom','1234','30');
sqlite> select * from employee;
1|zhaodeng|1234|25
2|Tom|1234|30
sqlite>
------------------------------------------------------------------------------------
JDBC连接sqlite数据库程序
package bo;import java.sql.Statement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;public class DbTEst {public static void main(String[] args) {// TODO Auto-generated method stubList<Employee> employees = fetchData();for (Employee e : employees) {System.out.println(e.toString());}Employee employee = login("Tom", "1234");if(employee!=null){System.out.println("登录成功,欢迎"+employee.getName());System.out.println(employee.toString());}else{System.out.println("登录失败");}}private static Employee login(String name, String pwd) {Employee employee = null;Connection connection = null;try {Class.forName("org.sqlite.JDBC");connection = DriverManager.getConnection("jdbc:sqlite:D:/Jdk-eclipsejee-tomcat-ant/sqlite/test.db");String string = "select * from employee where name =? and pwd =?";PreparedStatement statement = (PreparedStatement) connection.prepareStatement(string);statement.setString(1, name);statement.setString(2, pwd);ResultSet resultSet = statement.executeQuery();if (resultSet.next()) {employee = new Employee(resultSet.getInt(1), resultSet.getString(2), resultSet.getString(3),resultSet.getInt(4));}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if (connection != null) {try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}return employee;}private static List<Employee> fetchData() {List<Employee> employees = new ArrayList<Employee>();Employee employee = null;Connection connection = null;try {Class.forName("org.sqlite.JDBC");connection = DriverManager.getConnection("jdbc:sqlite:D:/Jdk-eclipsejee-tomcat-ant/sqlite/test.db");Statement statement = (Statement) connection.createStatement();String string = "select * from employee";ResultSet rSet = statement.executeQuery(string);while (rSet.next()) {employee = new Employee(rSet.getInt(1), rSet.getString(2), rSet.getString(3), rSet.getInt(4));employees.add(employee);}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {// TODO: handle exceptione.printStackTrace();} finally {if (connection != null) {try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}return employees;}}
0 0
- sqlite安装与学习
- SQLite下载与安装
- SQLite下载与安装
- SQLite下载与安装
- sqlite 的移植与安装
- SQLite学习2_Centos7.1 安装Sqlite3
- SQLite 数据库的安装与使用
- QT与sqlite使用和安装
- sqlite数据库的安装与使用
- Ubuntu下安装SQLite、与简单介绍
- SQLite 数据库安装与创建数据库
- SQLite在C#中的安装与操作
- Android学习--SQLite与简单调试方法
- Android学习之 SQLite 与 ListView
- SQLite学习手册 - 自增与主键
- 学习笔记(五)SQLite与ContentProvider
- Python基础学习-标签与sqlite
- 关于数据库SQLite的学习与理解
- 文本框输入内容回车事件
- 安装Glass Box代理程序
- iOS开发:创建真机调试证书
- Java dom4j操作
- [BZOJ1503][NOI2004]郁闷的出纳员(平衡树splay)
- sqlite安装与学习
- Makefile 使用总结(个人觉得不错)
- 【追求进步】和为S的两个数字
- 第一个博客
- think python学习心得-(3)条件和递归
- Android事件传递
- Nova Mitaka 版本热迁移变化浅析
- DrawText参数介绍
- Linux学习--rsync+inotify实现数据实时同步