当前页面: JAVA 编程资料牛鼻论坛 → J2ee & 企业开发技术区→怎么用jsp做bbs? |
<-board->
<%@ page contentType="text/html; charset=euc-kr" import="java.sql.*" %>
<html>
<head>
<title> BBS </title>
</head>
<body><p align="center">
<input type="text" >
<input type="submit" value="查询">
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/db","root","1234");
stmt = conn.createStatement();
String query = "SELECT * FROM test";
rs = stmt.executeQuery(query);
out.println("<TABLE BORDER=1" );
out.println("<TR><TD>姓名</TD><TD>电话号码</TD></TR>");
while(rs.next()) {
String name = rs.getString("name");
String tel = rs.getString("tel");
out.println("<TR><TD>"+name+"</TD><TD>"+tel+"</TD></TR>");
}
out.println("</TABLE>");
%>
<input type="submit" value="添加" onClick= "window.open( 'add.jsp','new','left=300, top=200, width=500, height=400')">
<input type="submit" value="修改" onClick="window.open('update.jsp','new','left=300,top=200,width=500, height=400')">
<input type="submit" value="删除">
</form>
</body>
</html>
<-添加->
<%@ page contentType="text/html; charset=euc-kr" import="java.sql.*" %>
<html>
<script>
function test(){
//alert("test");
frm.submit();
}
</script>
<head>
<title> 添加 </title>
</head>
<%
String time=request.getParameter("aname");
out.print(time);
if(time!=null){
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/db","root","1234");
stmt = conn.createStatement();
String query = "SELECT * FROM test";
rs = stmt.executeQuery(query);
out.println("<TABLE BORDER=1" );
out.println("<TR><TD>姓名</TD><TD>电话号码</TD></TR>");
while(rs.next()) {
String name = rs.getString("name");
String tel = rs.getString("tel");
out.println("<TR><TD>"+name+"</TD><TD>"+tel+"</TD></TR>");
}
out.println("</TABLE>");
}
%>
<body><p align="center">
<form name="frm" method="post" action="add.jsp">
姓名: <input type="text" name="aname" >
<br>
电话号码: <input type="text" name="tel">
<br>
<input type="submit" value="确认" onclick="test()">
</form>
</body>
</html>