微信数据库消息解读

解密参考：

//http://blog.csdn.net/njweiyukun/article/details/54024442//imei号：手机按*#06#,CompatibleInfo.cfg 354169060462426 c4cc03c　//sqlite jdbc:https://bitbucket.org/xerial/sqlite-jdbc/downloads/import java.io.UnsupportedEncodingException;import java.text.SimpleDateFormat;import java.util.Date;import java.security.MessageDigest;class Ex02_3_3 { //md5 加密3public static String md5(String content) {  MessageDigest md5 = null;  try {  md5 = MessageDigest.getInstance("MD5");  md5.update(content.getBytes("UTF-8"));  byte[] encryption = md5.digest();//加密  StringBuffer sb = new StringBuffer();  for (int i = 0; i < encryption.length; i++) {  if (Integer.toHexString(0xff & encryption[i]).length() == 1) {  sb.append("0").append(Integer.toHexString(0xff & encryption[i]));  } else {  sb.append(Integer.toHexString(0xff & encryption[i]));  }  }  return sb.toString();  } catch (Exception e) {  e.printStackTrace();  return null;  }  }//日期打印到毫秒public static void display() {System.out.println(new SimpleDateFormat("yyyy/MM/dd KK:mm:ss:SSS").format(new Date()));}//注册数据库public Connection getConnection() throws ClassNotFoundException,IOException, SQLException {      Class.forName("org.sqlite.JDBC");      return  DriverManager.getConnection("jdbc:sqlite:enmicromsg.db");    }public static void main(String args[]) {      // String imei="354169060462426";Connection conn = null;String imei=args[0]; //String uin="1297173361";String uin=args[1];             Mynumber a= new Mynumber();            //   a.number= 5;             System.out.println(imei+uin);String md5 = md5(imei + uin);  String password = md5.substring(0, 7).toLowerCase(); String sql="select count(*) from message';display();Statement stmt = conn.createStatement;ResultSet rs = stmt.executeQuery(sql);System.out.println(password);      }}

运行

D:\javasource>java Ex02_3_3 354169060462426  129717336135416906046242612971733612017/08/13 08:02:02:640c4cc03c

message查询：

select datetime(createTime/1000 ,'unixepoch','localtime'), createtime,content from message where talker='ha**ong00'