嘿嘿 ,太粗心了,忘记把连接代码贴出来了,这一块内容我也是参考了很多资料的;
总结一下:
首先有一个DBDRIVER:String DBDriver = "org.gjt.mm.mysql.Driver";
还有一个DBURL:String DBUrl =
"jdbc:mysql://localhost/sandy";当然sandy是我的数据库,我是在mysql命令行下建立了数据库。>mysql
create database dandy;
接下来就连接数据库,Class.forName(DBDriver);
Connection conn =
DriverManager.getConnection(DBUrl,DBUser,DBPassword);
哈哈,又忘记定义DBUser和DBPassword了,
String DBUser = "root";
String DBPassword = "root";
啰嗦了大半天,还是举个例子测试一下吧:
先在mysql命令行中建立一个数据库:>mysql create database
dandy;
紧接着创建一个表格:create table sandy(
username varchar(20) not null,
userpassword varchar(20) not null,
role varchar(20) not null
);
并向表中插入两行数据:
insert into sandy values("zhou","123","会员");
insert into sandy values("wang","456","非会员");
接下来,写代码,我用的工具是JCreator:
check1.jsp
contentType="text/html;charset=gb2312"%>
String DBDriver =
"org.gjt.mm.mysql.Driver";
String DBUrl =
"jdbc:mysql://localhost/sandy";
String DBUser = "root";
String DBPassword = "root";
Class.forName(DBDriver);
Connection conn =
DriverManager.getConnection(DBUrl,DBUser,DBPassword);
Statement sqlStatement =
conn.createStatement();
String sql = "select * from sandy";
ResultSet rs =
sqlStatement.executeQuery(sql);
while(rs.next()) {
%>
你是 !
}
%>
rs.close();
sqlStatement.close();
conn.close();
%>
以上两个文件都保存在C:\tomcat5.5.27\webapps\jsp(自己新建的文件夹),启动tomcat服务器,然后在浏览器中输入:http://localhost/jsp/check1.jsp
自己 试一下吧。