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 {
/*****填写数据库相关信息(请查找数据库详情页)*****/
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;
/******接着连接并选择数据库名为databaseName的服务器******/
Class.forName(driverName);
connection = DriverManager.getConnection(Url, username,password);
} catch (Exception e) {
e.printStackTrace();
}
return connection;
}
/******获取结果集******/
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);
/******将结果集转为String******/
ResultSetMetaData md=rs.getMetaData(); //获得结果集的所以字段名
StringBuffer s=new StringBuffer();
if(rs.next()){ //如果有结果
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();
}
上面的代码有什么问题吗?? 为什么从微信客户端那发送总是提示没有提供服务。
jar包引入了吗