jsp通过jdbc访问MySQL数据库
1,从网站上搜索jdbc驱动程序mysql-connector-java-3.1.9zip
2,解压从mysql-connector-java-3.1.9文件夹下复制mysql-connector-java-3.1.9-bin.jar到C:\Tomcat 4.1\common\lib
4,从数据库中建数据库及表
5,用jsp编码显示表中的内容.
6,通过create database命令从数据库中建数据库testmysql
7,从数据库testmysql中建数据表Users.
use testmysql.//使用testmysql数据库
create table Users(//在testmysql数据库中建users表
ID int not null auto_increment,
UserID char(40),
Name char(40),
Email char(40),
Address cahr(40),
primary key(ID)
);
insert into Users(UserID,Name,Email,Address)values('zhangzl','lunzi','zhangzenglun@163.com','hebei');
//向表中插入数据
jsp代码
//利用jdbc查看表中的内容
<%@ page contentType="text/html;charset=Gb2312"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/testmysql","root","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from Users");
while(rs.next())
{
%>
<%=rs.getString("ID")%>
<%=rs.getString("UserID")%>
<%=rs.getString("Name")%>
<%=rs.getString("Email")%>
<%=rs.getString("Address")%><br>
<%
}
rs.close();
stmt.close();
con.close();
%>
<%out.print("数据库操作成功，恭喜你");%>
2,解压从mysql-connector-java-3.1.9文件夹下复制mysql-connector-java-3.1.9-bin.jar到C:\Tomcat 4.1\common\lib
4,从数据库中建数据库及表
5,用jsp编码显示表中的内容.
6,通过create database命令从数据库中建数据库testmysql
7,从数据库testmysql中建数据表Users.
use testmysql.//使用testmysql数据库
create table Users(//在testmysql数据库中建users表
ID int not null auto_increment,
UserID char(40),
Name char(40),
Email char(40),
Address cahr(40),
primary key(ID)
);
insert into Users(UserID,Name,Email,Address)values('zhangzl','lunzi','zhangzenglun@163.com','hebei');
//向表中插入数据
jsp代码
//利用jdbc查看表中的内容
<%@ page contentType="text/html;charset=Gb2312"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/testmysql","root","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from Users");
while(rs.next())
{
%>
<%=rs.getString("ID")%>
<%=rs.getString("UserID")%>
<%=rs.getString("Name")%>
<%=rs.getString("Email")%>
<%=rs.getString("Address")%><br>
<%
}
rs.close();
stmt.close();
con.close();
%>
<%out.print("数据库操作成功，恭喜你");%>
lunzi
2005-07-17 04:20:46
评论:0
阅读:3170
引用:0