jsp连mysql存图片_JSP实现MYSQL5.1存入图片

pageEncoding="UTF-8"%>

Insert title here

图片Num

图片

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

request.setCharacterEncoding("utf-8");

String uri = "jdbc:mysql://localhost:3306/test";//使用的是test数据库

String sql = "select picNum from pic "; //我建图片表 pic

try{

Class.forName("com.mysql.jdbc.Driver");

}catch(Exception e){

out.print(e);

}

try{

conn = DriverManager.getConnection(uri,"root","root");//我的用户名是 root ,密码 是 soft 根据你的需要 更改

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

while(rs.next()){

%>

">

}

}catch(Exception e){

out.print(e);

}

%>

数据库的设计：

附录：sql脚本

use test;

create table pic(

id int primary key auto_increment,

picNum varchar(10) unique

);

然后插入数据：

insert into pic(picNum) values('1.jpg');

insert into pic(picNum) values('2.jpg');

insert into pic(picNum) values('3.jpg');

insert into pic(picNum) values('4.jpg');

insert into pic(picNum) values('5.jpg');

insert into pic(picNum) values('6.jpg');

insert into pic(picNum) values('7.jpg');

结果图：

分享到：

2010-10-31 14:31

浏览 1064

评论