Question

java如何读取数据库中的路径在标签框中显示图片

数据库中保存的路径是图片文件，只是做一个小软件，代码应该怎么写

Answer 1

1、从DB得到图片路径
2、载入图片到 ImageIcon
3、显示在JLabel中，setIcon(ImageIcon)

Answer 2

try{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
String URL = "jdbc:sqlserver://localhost:1433; DatabaseName=MCNumber"; //连接服务器和数据库test
String userName = "sa"; //默认用户名
String userPwd = "sa"; //密码
Connection Conn;
Class.forName(driverName).newInstance();
Conn = DriverManager.getConnection(URL, userName, userPwd);
String Image ="select markLinkUrl from MCNumber M " +
"join StoreImage S on M.MCNumber = S.MCNumber where M.MCNumber="+ImageIng;
PreparedStatement ps=Conn.prepareStatement(Image);//执行sql语句的容器
ResultSet rs=ps.executeQuery();
while(rs.next())
{
String url = rs.getString("markLinkUrl"); //数据库中存储地址的列名
Icon icon = new ImageIcon(url);
ImageLabel = new JButton(icon);
PanelNeed.add(ImageLabel);

}