重点：java后端直接连接数据库实现查询获取结果 jdbc

   String url = "jdbc:mysql://192.168.26.44:3306/weibo?user=weibo&password=1qaz2wsx&useUnicode=true&characterEncoding=GBK";
   
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   Connection conn = (Connection) DriverManager.getConnection(url);
   
   Statement stmt = (Statement) conn.createStatement();      
   String strSQL = "INSERT INTO portal_carcontact VALUE (NULL,'" + customerMobile + "', '" + conname + "', '" + conmobile + "','" + dateStr + "',"+ uidStr +",0)";
   
   logger.info("strSQL：" + strSQL);   
   stmt.execute(strSQL);

   if(null != stmt)
   {
    stmt.close();
   }
   if(null != conn)
   {
    conn.close();
   }

转载于:https://my.oschina.net/u/817550/blog/314195