package com.imooc.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

public class jdbcUtil {
?
??? public static Connection getConnection(){
??? ?
??? ?Connection connection = null;
??????? try {
??????????? /*****填寫數(shù)據(jù)庫(kù)相關(guān)信息(請(qǐng)查找數(shù)據(jù)庫(kù)詳情頁(yè))*****/
??????????? String username = "73b793a696514ffb9de7d35f9438334e"; //用戶AK
??????????? String password = "096967973a244ad9bbb06e6944165d2c"; //用戶SK
??????????? String driverName = "com.mysql.jdbc.Driver";
??????????? String databaseName = "vTSLArActuSoNbfolcjf";
??????????? String host = "sqld.duapp.com";
??????????? String port = "4050";
??????????? String dbUrl = "jdbc:mysql://";
//??????????? String serverName = host + ":" + port + "/";
??????????? String Url = dbUrl + host + ":" + port + "/" + databaseName;

??????????? /******接著連接并選擇數(shù)據(jù)庫(kù)名為databaseName的服務(wù)器******/
??????????? Class.forName(driverName);
??????????? connection = DriverManager.getConnection(Url, username,password);
??????? } catch (Exception e) {
??????????? e.printStackTrace();
??????? }
??????? return connection;
??? }
???
??? /******獲取結(jié)果集******/
??? public static ResultSet getResultSet(String content,String? sql) throws Exception{
??? ?
??? ?PreparedStatement p=getConnection().prepareStatement(sql);
//??? ?p.setString(1, content);
??? ?ResultSet rs=p.executeQuery();
??? ?return rs;
??? }
???
??? /******獲取一條記錄******/
??? public static String getResult_a(String content) throws Exception{
??? ?
??? ?String sql="select * from? wendu? where time= '"+content+"'";
??? ?PreparedStatement p=getConnection().prepareStatement(sql);
??? ?ResultSet rs=p.executeQuery();
??? ?
//??? ?ResultSet rs=getResultSet(content,sql);
??? ?
??? ?/******將結(jié)果集轉(zhuǎn)為String******/
??? ?ResultSetMetaData md=rs.getMetaData();?? //獲得結(jié)果集的所以字段名
??? ?StringBuffer s=new StringBuffer();
??? ?
??? ?if(rs.next()){?? //如果有結(jié)果
??? ??for(int i=1;i<=md.getColumnCount();i++){
??????? ??String label=md.getColumnLabel(i);? //獲取字段名
??????? ??String value=rs.getString(i);
??????? ??s.append(label+"="+value+"\t");
??????? ?}
??? ?}
??? ?return s.toString();
??? }

上面的代碼有什么問題嗎？？ 為什么從微信客戶端那發(fā)送總是提示沒有提供服務(wù)。