facepage_1.jsp

图书管理系统

<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<%

   Connection conn=null;
   Statement stmt=null;
   ResultSet rs=null;
try
{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
     out.println(ce.getMessage());
}
request.setCharacterEncoding("GBK");
String m1=request.getParameter("mno");
String m2=request.getParameter("textfield");
try
{    
   conn=DriverManager.getConnection("jdbc:odbc:xgx");
   stmt=conn.createStatement();

 stmt.executeUpdate("INSERT INTO message values('"+m1+"','"+m2+"')");
   rs=stmt.executeQuery("SELECT* FROM message");
   while(rs.next())
  {    
        out.println("<BR>会员："+rs.getString("mcNo")+"");
        out.println("<BR>内容:"+rs.getString("info")+"");
        out.println("<BR>---------------------------------");
  }
}
catch(SQLException e)
{out.println(e.getMessage());
}
finally
{
stmt.close();
conn.close();
}
%>