代码如下
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*,java.util.*"%>
<jsp:useBean id="dbconn" scope="page" class="TestBean.DBconn"/>
<html>
<head>
<title>TestBeanSql</title>
<style type="text/css"> <!--
.style1{
font-size:12px;
color:#000000;
}
.style2{
font-size:12px;
color:#0033FF;
}
body{
background-color:#FFFFCC;
}
-->
</style>
</head>
<body bgcolor="#ffffff">
<%
//TestBean.DBconn dbconn = new TestBean.DBconn();
dbconn.getConnect();
String sql = "SELECT * FROM student";
ResultSet rs = dbconn.select(sql);
%><p class="style1" align="center">学生信息一览</p>
<hr>
<table border=0 width="800" align="center">
<tr class="style2" bgcolor="#CCFF22" align="center">
<td>学号</td>
<td>姓名</td>
<td>性别</td>
<td>年龄</td>
<td>籍贯</td>
<td>系别</td>
<td>年份</td>
</tr>
<%
while(rs.next())
{
%>
<tr class="style1" align="left">
<td><%=rs.getString("id")%> </td>
<td><%=rs.getString("name")%> </td>
<td><%=rs.getString("sex")%> </td>
<td><%=rs.getString("age")%> </td>
<td><%=rs.getString("home")%> </td>
<td><%=rs.getString("department")%> </td>
<td><%=rs.getString("year")%> </td>
</tr>
<%
}
dbconn.close();
%>
</table>
</body>
</html>javabean的package TestBean;
import java.sql.*;public class DBconn{ public DBconn()
{
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public void getConnect()
{
try
{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\\Java\\Tomcat 5.5\\webapps\\ROOT\\test\\management.mdb";
conn=DriverManager.getConnection(url);
System.out.println("连接数据库成功.");
}
catch(Exception e)
{
System.out.println("连接数据库失败.");
e.printStackTrace();
}
}
public ResultSet select(String sql)
{
try
{
stmt=conn.createStatement() ;
rs=stmt.executeQuery(sql) ;
}
catch(Exception e)
{
e.printStackTrace();
}
return rs;
}
public int insert(String sql)
{
int num=0;
try
{
stmt=conn.createStatement() ;
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int update(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int delete(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int count(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next() )
{
num=rs.getInt(1);
}
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public void close()
{
try
{
if(rs!=null)
rs.close();
rs=null;
if(stmt!=null)
stmt.close();
stmt=null;
if(conn!=null)
conn.close();
conn=null;
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
conn=null;
}
}
}
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*,java.util.*"%>
<jsp:useBean id="dbconn" scope="page" class="TestBean.DBconn"/>
<html>
<head>
<title>TestBeanSql</title>
<style type="text/css"> <!--
.style1{
font-size:12px;
color:#000000;
}
.style2{
font-size:12px;
color:#0033FF;
}
body{
background-color:#FFFFCC;
}
-->
</style>
</head>
<body bgcolor="#ffffff">
<%
//TestBean.DBconn dbconn = new TestBean.DBconn();
dbconn.getConnect();
String sql = "SELECT * FROM student";
ResultSet rs = dbconn.select(sql);
%><p class="style1" align="center">学生信息一览</p>
<hr>
<table border=0 width="800" align="center">
<tr class="style2" bgcolor="#CCFF22" align="center">
<td>学号</td>
<td>姓名</td>
<td>性别</td>
<td>年龄</td>
<td>籍贯</td>
<td>系别</td>
<td>年份</td>
</tr>
<%
while(rs.next())
{
%>
<tr class="style1" align="left">
<td><%=rs.getString("id")%> </td>
<td><%=rs.getString("name")%> </td>
<td><%=rs.getString("sex")%> </td>
<td><%=rs.getString("age")%> </td>
<td><%=rs.getString("home")%> </td>
<td><%=rs.getString("department")%> </td>
<td><%=rs.getString("year")%> </td>
</tr>
<%
}
dbconn.close();
%>
</table>
</body>
</html>javabean的package TestBean;
import java.sql.*;public class DBconn{ public DBconn()
{
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public void getConnect()
{
try
{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\\Java\\Tomcat 5.5\\webapps\\ROOT\\test\\management.mdb";
conn=DriverManager.getConnection(url);
System.out.println("连接数据库成功.");
}
catch(Exception e)
{
System.out.println("连接数据库失败.");
e.printStackTrace();
}
}
public ResultSet select(String sql)
{
try
{
stmt=conn.createStatement() ;
rs=stmt.executeQuery(sql) ;
}
catch(Exception e)
{
e.printStackTrace();
}
return rs;
}
public int insert(String sql)
{
int num=0;
try
{
stmt=conn.createStatement() ;
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int update(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int delete(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int count(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next() )
{
num=rs.getInt(1);
}
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public void close()
{
try
{
if(rs!=null)
rs.close();
rs=null;
if(stmt!=null)
stmt.close();
stmt=null;
if(conn!=null)
conn.close();
conn=null;
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
conn=null;
}
}
}
解决方案 »
- eclipse中怎么安装maven插件
- 在html中下拉框初值如何设空啊??急~~谢谢
- 今天的面试题目,求解?
- 初学JSP者
- 哪位用java开发过socket?
- 调试jsp程序出错?
- 请教:JSP上有一表格 如何导入到WORD中去?
- 升级成WIN2003后,连接池不能创建了!!!!
- String sql="select * from table1 where bb="+bb+"";后面的那个 +"" 的作用是什么??
- JQuery 如何在页面加载的时候弹窗? (Bootstrap 的 modal)
- 请教个问题做一个新闻发布系统 生成的静态HTML怎么实现分页
- 大虾们帮个小忙啊 ,关于JSP和HTML的问题
JSP和JAVABEAN的。
这个student你从哪里来的嘛?
数据源建了 student就是名字 编个java程序能读 同样代码放到jsp里就不行...
把它改成("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\\Java\\Tomcat 5.5\\webapps\\ROOT\\test\\management.mdb");
jsp认,但是javabean还是不认直接运行tomcat\bin下的tomcat5.exe 启动tomcat javabean也认,一切都正常了
但是其他方法,启动tomcat服务之类 eclipse里用tomcat插件启动都不行....
抓狂了...
{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //重复了
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\\Java\\Tomcat 5.5\\webapps\\ROOT\\test\\management.mdb";
conn=DriverManager.getConnection(url);
System.out.println("连接数据库成功."); }
代码我做点了修改:
package TestBean;
import java.sql.*; public class DBconn{ public DBconn()
{
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public void getConnect()
{
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:news";
String user="";
String pwd="";
conn=DriverManager.getConnection(url,user,pwd);
System.out.println("连接数据库成功.");
}
catch(Exception e)
{
System.out.println("连接数据库失败.");
e.printStackTrace();
}
}
public ResultSet select(String sql)
{
try
{
stmt=conn.createStatement() ;
rs=stmt.executeQuery(sql) ;
}
catch(Exception e)
{
e.printStackTrace();
}
return rs;
}
public int insert(String sql)
{
int num=0;
try
{
stmt=conn.createStatement() ;
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int update(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int delete(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public int count(String sql)
{
int num=0;
try
{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next() )
{
num=rs.getInt(1);
}
}
catch(Exception e)
{
e.printStackTrace();
}
return num;
}
public void close()
{
try
{
if(rs!=null)
rs.close();
rs=null;
if(stmt!=null)
stmt.close();
stmt=null;
if(conn!=null)
conn.close();
conn=null;
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
conn=null;
}
}
}
运行成功了~~
ResultSet.CONCUR_UPDATABLE
Access 支持这个吗?