建议老兄看看书啦,这是最基础的jsp问题啦,
你的bean就是java 类,
在jsp中使用时,<jsp:useBean id="yb" class="yourBean" scope="..." />
id就是实例名字,class指定你的bean的位置和名字,
scope就是存活范围,page,session,application
..................
如果你要初始化bean,
<jsp:useBean id="yb" class="yourBean" scope="page" >
...................
</jsp:useBean>
你的bean就是java 类,
在jsp中使用时,<jsp:useBean id="yb" class="yourBean" scope="..." />
id就是实例名字,class指定你的bean的位置和名字,
scope就是存活范围,page,session,application
..................
如果你要初始化bean,
<jsp:useBean id="yb" class="yourBean" scope="page" >
...................
</jsp:useBean>
import test.sqlBean;
import java.sql.*;
public class course {
private String id;
private String name;
private String dep;
private String prepare;
private int ;
public void setPrepare(String s){prepare=s;}
public String getPrepare(){return prepare;}
public void setMark(int s){=s;}
public int getMark(){return ;}
public void setDep(String s){dep=s;}
public String getDep(){return dep;}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
} public ResultSet getPrepares(){ //得到所能选择的预修课
String sql="select name,id from course ";
sqlBean db = new sqlBean();
ResultSet rs = db.executeQuery(sql);
return rs;
}
public String getPrepareDep(){ //察看预修课所在系
String s="no";
String sql="select dep from course where id='"+prepare+"' ";
sqlBean db = new sqlBean();
try{
ResultSet rs = db.executeQuery(sql);
if(rs.next()){
s=rs.getString("dep");
}
}catch(Exception e){ e.getMessage();}
return s;}
public ResultSet getCourse(){ //察看所有课程
String sql="select * from course ";
sqlBean db= new sqlBean();
ResultSet rs = db.executeQuery(sql);
return rs;
}
public int deleteCourse(String id){
int num=0;
String sql="delete from Course where id ='"+id+"' ";
sqlBean db= new sqlBean();
num=db.executeDelete(sql);
return num;
}
public String getPrepareDep(String id){
String dep="";
String sql="select dep from course where id='"+id+"'";
sqlBean db= new sqlBean();
try{
ResultSet rs = db.executeQuery(sql);
if(rs.next())
dep=rs.getString("dep");
}catch(SQLException e){System.out.print(e.toString());}
return dep;
}
public void updateCourse(String id){
String sql="update course "+
" set name='"+name+"',prepare='"+prepare+"',"+
"dep='"+dep+"',='"++"' "+
" where id='"+id+"' ";
sqlBean db= new sqlBean();
db.executeInsert(sql);
}
public void addCourse(){
String sql="insert into course(id,name,,prepare,dep) "+
"VALUES('"+id+"','"+name+"','"++"','"+prepare+"','"+dep+"') ";
sqlBean db = new sqlBean();
db.executeInsert(sql);
}
public boolean hasLogin( String id){
boolean f=true;
String sql="select id from course where id='"+id+"' ";
sqlBean db = new sqlBean();
try{
ResultSet rs =db.executeQuery(sql);
if(rs.next())
{f=false;}
}catch(Exception e){ e.getMessage();}
return f;
}
}-------------------------------------------------------------------------------
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>所有课程</title>
</head>
<jsp:useBean id="course" scope="page" class="test.course"/>
<body bgcolor="#998899" text="#FFFFFF" link="#00FF00">
<div align="center">
<p>
<%
String id="",name="",prepare="",dep="";
int =0;
%>
<font color="#00FF00" size="+3" face="方正舒体">所有课程</font> </p>
<p> </p>
<p align="left"><a href="Addcourse.jsp"><font size="+1" face="方正舒体"><strong>新增课程</strong></font></a></p>
</div>
<div align="center">
<table width="75%" border="1">
<tr>
<td>课程号</td>
<td>课程名</td>
<td>学分</td>
<td>预修课</td>
<td>所在系</td>
<td>删除</td>
<td>更新</td>
</tr>
<%
ResultSet rs=course.getCourse();
while(rs.next()) {
id=rs.getString("id");
name=rs.getString("name");
=rs.getInt("");
prepare=rs.getString("prepare");
dep=rs.getString("dep");%>
<tr><td><%=id%></td><td><%=name%></td><td><%=%></td><td><%=prepare%></td>
<td><%=dep%></td>
<td><a href="CourseSvlt?action=delete&id=<%=id%>">删除</a></td>
<td><a href="updatecour.jsp">更新</a></td>
</tr>
<%
}
%>
</table>
</div><p align="left"><a href="admin.jsp"><<BackTo Admin</a></p>
</body>
</html>