Question

MyEclipse连接mysql 高手帮我看看错哪里了

报错内容是

SQLException: Column 'article' not found.
SQLState: S0022
VendorError: 0

这个是什么意思？？
找控制台下我已经把数据库创建好了
mysql> show databases;
--------------------Database

--------------------information_schema
bbs
mysql
test

--------------------
4 rows in set (0.00 sec)

mysql> show tables;
---------------Tables_in_bbs

---------------article

---------------
1 row in set (0.00 sec)

代码如下

import java.sql.*;

public class JDBCmysql {

/**
* @param args
*/
public static void main(String[] args) {
try {

Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
ex.printStackTrace();
}

try {
Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost/bbs?user=root&password=root");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from article");
while (rs.next())
{
System.out.println(rs.getString("article"));
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}

}
}
那我想把整个table打印出来该怎么弄？

Answer 1

你的article表里有article的字段吗
while (rs.next())
{
System.out.println(rs.getString("article"));//打印article字段
}

Answer 2

楼上的是对的
jdbc:mysql://localhost:3306/pubs ,user=r
oot, password=root
这连接字符串不是要给端口号的？

Answer 3

Column 'article' not found.
没有这一列
应该
System.out.println(rs.getString("article"));
出错了吧

Answer 4

我也认为他的那个表的名字可能是article
而他要打印的可能是pid或者cname吧

Answer 5

dfg