建立same package,conn<bean>
package same;
import java.sql.*;
public class conn {
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String conurl = "jdbc:odbc:suer";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public conn() {
try {
Class.forName(driver);
}
catch (java.lang.ClassNotFoundException e) {
System.err.println(e.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
con = DriverManager.getConnection(conurl);
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println(ex.getMessage()); }
return rs;
} public int executeUpdate(String sql) {
int result = 0;
try {
con = DriverManager.getConnection(conurl);
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println(ex.getMessage()); }
return result;
}
//添加方法。
public void close(){
try{
if(rs != null){
rs.close();
}
if(stmt != null){
stmt.close();
}
if(conn != null){
conn.close();
}
}catch(Exception e){
//TO DO.
}
}
package same;
import java.sql.*;
public class conn {
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String conurl = "jdbc:odbc:suer";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public conn() {
try {
Class.forName(driver);
}
catch (java.lang.ClassNotFoundException e) {
System.err.println(e.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
con = DriverManager.getConnection(conurl);
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println(ex.getMessage()); }
return rs;
} public int executeUpdate(String sql) {
int result = 0;
try {
con = DriverManager.getConnection(conurl);
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println(ex.getMessage()); }
return result;
}
//添加方法。
public void close(){
try{
if(rs != null){
rs.close();
}
if(stmt != null){
stmt.close();
}
if(conn != null){
conn.close();
}
}catch(Exception e){
//TO DO.
}
}
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<jsp:useBean id="conn" scope="page" class="same.conn"/>
<%!
String sql = "";
int id = 1;
ResultSet rs = null;
ResultSet rsTmp = null;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新闻</title>
<link rel="stylesheet" type="text/css" href="news.css">
<script language="JavaScript">
function NewsWindow(id)
{
window.open('newswind.jsp?id='+id,'infoWin', 'height=400,width=600,scrollbars=yes,resizable=yes');
}
</script>
</head>
<body>
<%
if(request.getParameter("del")!=null) conn.executeQuery("delete * from news where id=" + request.getParameter("del"));
sql="SELECT * from news order by ID desc";
rs = conn.executeQuery(sql);
int rs_count = 0;
%>
<p><strong>全部新闻</strong><table width=100%>
<%
while(rs.next()) {
rs_count ++;
id = rs.getInt("ID");
%>
<tr><td><a href="javascript:NewsWindow(<%=id%>)"><u>
<%=rs.getString("title")%></u></a>--
<%=rs.getString("author")%>
【<%=rs.getDate("times").toString()%>】
</td><td align=right><img src=note.gif><a href=newsedit2.jsp?id=<%=id%>>编辑</a>
<img src=del.gif><a href=newsedit.jsp?del=<%=id%>>删除</a></td></tr>
<%
}
conn.close();
if(rs_count == 0){
out.println("<p>还 没 有 任 何 新 闻</p>");
}
%>
<p align=right><a href=newsadd.jsp>添加新闻</a> <a href="default.jsp">查看新闻</a>
重写一下,注意:con,stmt,rs是需要相互关联的,rs并非传值而是一个指针。
另外上面的错误可能是你表的列名写错了。</quot>我试了,关闭数据库连接,不行的,还是同样的错误。
另外我的列名没错 的,就是小写的id