SQLite

访问MySQL数据库

package com.Robyn;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class MySQLConnect {

      public static void main(String[] args ) {

          Connection conn = null ;

          String sql ;

          // jdbc:mysql://+地址:端口号+ /lingchat?+ user=账号+ &password=密码+ &useUnicode=true&characterEncoding=编码格式

          String url = "jdbc:mysql://weapp.f3322.net:3306/lingchat?"

                   + "user=hali&password=hali2016&useUnicode=true&characterEncoding=utf8" ;

          

           try {

              Class.forName( "com.mysql.jdbc.Driver" );

              System. out .println( "成功加载MySQL驱动" );

              

               conn = DriverManager.getConnection( url );

              Statement stmt = conn .createStatement();

               sql = "select * from lingchat" ;

              ResultSet rs = stmt .executeQuery( sql );

              System. out .println( "问题\t答案" );

              

               while ( rs .next()) {

                   System. out .println( rs .getString(1) + "\t" + rs .getLong(2));                

              }

              

          } catch (Exception e ) {

               e .printStackTrace();

          } finally {

               try {

                    conn .close();

              } catch (SQLException e ) {

                    // TODO Auto-generated catch block

                    e .printStackTrace();

              }

          }

     }

}

一一一一一一一一一一一一一一一一我是一条分割线一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一

不能拿时间戳做数据库的主键   SQL Server 的 datetime 类型的精度其实不是1毫秒，而是3.33毫秒

一一一一一一一一一一一一一一一一我是一条分割线一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一

查询出某个时间段的数据

select * from tb where cast(字段 as datetime) between 时间1 and 时间2

sql sc " + EnDbPath + " " + wadp + " \"" + selecr message from  + "\" " + tablename

一一一一一一一一一一一一一一一一我是一条分割线一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一