java加载mysql报错_JAVA连接mysql数据库报错，坐等高手指点

packagejuwaimai.con_data.ke;importjava.sql.DriverManager;importcom.mysql.jdbc.Connection;importcom.mysql.jdbc.ResultSet;importcom.mysql.jdbc.Statement;publicclassConnetDa...

package juwaimai.con_data.ke;

import java.sql.DriverManager;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.ResultSet;

import com.mysql.jdbc.Statement;

public class ConnetDatabase {

static{

String driverClass="com.mysql.jdbc.Driver";

try {

Class.forName(driverClass).newInstance();

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}

}

public Shop getShopInfo(String url,String user,String password,String sql){

/*

//这里的是参数的说明

String url="jdbc:mysql://42.121.82.92:3306/juwaimai";//之前数据库名simple

String user="这里是账号";//MySQ帐号

String password="这里是密码";//MYSQL密码

String sql="SELECT * FROM shop where id=1";//表名book

*/

Shop shop=new Shop(); //新建一个店铺对象

Connection conn=null;

try {

conn=(Connection) DriverManager.getConnection(url,user,password);

Statement stmt=(Statement) conn.createStatement();

ResultSet vrs=(ResultSet) stmt.executeQuery(sql);

int rowCount=0;

while(vrs.next()){

rowCount++;

shop.setId(vrs.getInt(1));

shop.setShopName(vrs.getString(2));

}

}catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

System.out.println("连接数据库出错");

}

return shop;

}

}

展开