Lianjie.jsp <%@ page contentType="text/html; charset=GB2312" %> <%@ page import="java.sql.*" %>
通讯录
<% Connection con; Statement sql; ResultSet rs; try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(Exception e) { } try{ con=DriverManager.getConnection("jdbc:odbc:phone",".",""); sql=con.createStatement(); rs=sql.executeQuery("select * from addressbook order by ID"); out.print("
"); out.print(""); out.print(""+"编号"+" | "); out.print(""+""+" | "); out.print(""+"电话"+" | "); out.print(""+"住址"+" | "); out.print(""+"QQ"+" | "); out.print("
"); while(rs.next()) { out.print(""); out.print(""+rs.getByte(1)+" | "); out.print(""+rs.getString(2)+" | "); out.print(""+rs.getString(3)+" | "); out.print(""+rs.getString(4)+" | "); out.print(""+rs.getString(5)+" | "); out.print("
"); } out.print("
"); con.close();
}
catch(Exception e) { } %> Add.jsp <%@ page contentType="text/html; charset=GB2312" %> <%@ page import="java.sql.*" %>
请输入您要添加的各个字段的值
带*项不能为空