JavaBean部分:
package bean;
import java.sql.*;
public class news
{
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ye";
String user="sa";
String password="";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public news()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("news():"+e.getMessage());
}
}
public void executeInsert(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("news.executeUpdate:"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("news.excuteQuery:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
}
public void executeDelete(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.execute(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("news.executeDelete:"+ex.getMessage());
}
}
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
jsp部分:
<%@page contentType="text/html" language="java"%>
<%@page pageEncoding="GB2312"%>
<%@page import="java.sql.*"%>
<%@page import="bean.news"%>
<%
news query=new news();
//String na=new String(request.getParameter("name"));
String sql="select* from student";
//pubs为你的数据库的
ResultSet rs=query.executeQuery(sql);
while(rs.next()) { %>
学生姓名是:<%=rs.getString(1)%><br>
学生学号:<%=rs.getString(2)%><br>
语文:<%=rs.getString(3)%><br>
数学:<%=rs.getString(4)%><br>
<%}%>
<%out.print("数据库操作成功,恭喜你");
query.closeStmt();
query.closeConn();
%>
<html>
<head>查询学生成绩</head>
<body>
</body>
</html>
package bean;
import java.sql.*;
public class news
{
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ye";
String user="sa";
String password="";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
public news()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("news():"+e.getMessage());
}
}
public void executeInsert(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("news.executeUpdate:"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("news.excuteQuery:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
}
public void executeDelete(String sql)
{
try
{
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
stmt.execute(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("news.executeDelete:"+ex.getMessage());
}
}
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
jsp部分:
<%@page contentType="text/html" language="java"%>
<%@page pageEncoding="GB2312"%>
<%@page import="java.sql.*"%>
<%@page import="bean.news"%>
<%
news query=new news();
//String na=new String(request.getParameter("name"));
String sql="select* from student";
//pubs为你的数据库的
ResultSet rs=query.executeQuery(sql);
while(rs.next()) { %>
学生姓名是:<%=rs.getString(1)%><br>
学生学号:<%=rs.getString(2)%><br>
语文:<%=rs.getString(3)%><br>
数学:<%=rs.getString(4)%><br>
<%}%>
<%out.print("数据库操作成功,恭喜你");
query.closeStmt();
query.closeConn();
%>
<html>
<head>查询学生成绩</head>
<body>
</body>
</html>
学生学号:<%=rs.getString(2)%><br>
语文:<%=rs.getString(3)%><br>
数学:<%=rs.getString(4)%><br>你看看你的数据类型是不是错了
String str = "select *from tablename";
ResultSet rs=null;
List list=null;
super.getConnection();
try {
stmt =conn.createStatement();
rs=stmt.execute(str);
while(rs.next()){
class cls=new class();
cls.getPropertyName(rs.getString("columnName"));
list.add(cls);
}
return list;
conn.close();
你提前关闭连接了