gonggao.jsp

jsp做的一个个人网站

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" errorPage=" "%>
<%
request.setCharacterEncoding("gb2312");
String s=request.getParameter("textarea");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
String sql="select id,name from gly";
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sql);
String ID="";
String name="";
//String publish=""
while (rs.next())
{
   ID=rs.getString(1);
   name=rs.getString(2);
   String subject=name;
   byte b[]=subject.getBytes("GB2312");
 name=new String(b,"ISO-8859-1");
 name=subject.trim();
 out.print(name+"已经在本站注册!"+"<br>");
}

con.close();
out.print(s);
response.sendRedirect("index.jsp");  

%>