public static void main(String[] args) throws SQLException, ClassNotFoundException {
// TODO Auto-generated method stub
// 1、动态加载驱动包
Class.forName("org.sqlite.JDBC");
// 2、获取数据库连接对象
// Connection connection = DriverManager.getConnection("jdbc:sqlite:test.db");
Connection connection = DriverManager.getConnection("jdbc:sqlite:msg.db");
// 3、获取操作SQL语句的对象
Statement statement = connection.createStatement();
// 4、执行sql语句
statement.executeUpdate("create table if not exists record(id INTEGER primary key,user varchar(10),time varchar(20),msg varchar(100))");
statement.executeUpdate("insert into record(user,time,msg) values('11111','2018-7-5 10:07:00','今天是个好天气……')");
statement.executeUpdate("insert into record(user,time,msg) values('22222','2018-7-5 10:07:16','今天是个坏天气……')");
statement.executeUpdate("insert into record(user,time,msg) values('11111','2018-7-5 10:07:35','今天是个好日子……')");
// 5、获取查询结果
ResultSet resultSet = statement.executeQuery("select * from record where msg not null");
// 循环获取查询的数据行
while (resultSet.next()) {
// 切记:ResultSet的列索引从1开始
System.out.println("序号:" + resultSet.getInt(1) + ",用户:" + resultSet.getString("user")
+ ",时间:" + resultSet.getString("time")+ ",内容:" + resultSet.getString("msg"));
}
// 6、关闭
statement.close();
connection.close();
char c = 'A';
char c1 = 65;// ASCII美国标准交换码
char c2 = '\u0065';// Unicode全球统一编码
System.out.println(c);
System.out.println(c1);
System.out.println(c2);
}