我是通过新建函数来访问数据库的
public void getData(String medname){
String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433;DatabaseName=account";
String user="sa";
String password="sa";
try{
Class.forName(driver);
Connection conn=DriverManager.getConnection(url, user, password);
Statement stm=conn.createStatement();
ResultSet rst=stm.executeQuery("select med_name,chinese_name,add_pic from medicine where med_name ='"+medname+"'");
while(rst.next()){
jLabel1.setText(rst.getString("chinese_name"));
Pic_address=rst.getString("add_pic");
System.out.println(Pic_address);
Icon icon = new ImageIcon(Pic_address);//Pic_address="/images/drugs/mahuang.jpg";
jLabel2 = new JLabel (icon);
jContentPane.add(jLabel2, null);
}
stm.close();
conn.close();
}catch(ClassNotFoundException e){
System.err.println(e);
}catch(SQLException e){
System.err.println(e);
}
}
java读取数据库中图片的地址,然后再显示在jLabel框中,但是运行后没有加载图片
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-