📄 dosubmitjdbc.jsp

📁 JSP2.0实用教程实例源码

💻 JSP

字号:

<%@page contentType="text/html;charset=GBK" import="java.sql.*"%>
<html>
<title>用户注册：使用JDBC处理用户提交数据</title>
<body>
<%
Connection con = null;	
Statement stmt = null;	
ResultSet rs = null;

request.setCharacterEncoding("GB2312");
String regTelephone = request.getParameter("regTelephone");;	
String email = request.getParameter("email");	
String name = request.getParameter("name");     
String sex = request.getParameter("sex");     
String intro = request.getParameter("intro");     
%>
<h4>您提交的内容如下：</h4>
regTelephone:<%= regTelephone %><br/>
email：<%= email %><br/>
name：<%= name %><br/>
sex：<%= sex %><br/>
intro：<%= intro %><br/>
<h4>使用JDBC将用户注册信息保存到数据库中</h4>
<%		
try	{		
	Class.forName("com.mysql.jdbc.Driver").newInstance();		
	con = DriverManager.getConnection("jdbc:mysql://localhost:3306/helloBeijing?user=chen&password=admin");		
	stmt = con.createStatement();	
	String upd = "INSERT INTO volunteers(name,sex,regTelephone,email,intro) "+
				 "VALUES ('"+name+"','"+
				 sex+"','"+regTelephone+"','"+
				 email+"','"+intro+"')";
	//out.println(upd);
	stmt.executeUpdate(upd);     
	String query = "SELECT * FROM volunteers";	
	rs = stmt.executeQuery(query);
	
%>
<h4>从 volunteers 取出所有注册者的信息</h4>
<table border="1">
<tr>
	<th>姓名</th><th>性别</th><th>电话</th><th>Email</th><th>个人爱好</th>
</tr>
<%
    while ( rs.next() ) {
        out.println("<tr>");
        out.println("<td>" + rs.getString("name") + "</td>");
        out.println("<td>" + rs.getString("sex") + "</td>");
        out.println("<td>" + rs.getString("regTelephone") + "</td>");
        out.println("<td>" + rs.getString("email") + "</td>");
        out.println("<td>" + rs.getString("intro") + "</td>");
        out.println("</tr>");
    }
}catch(SQLException sqle){
	out.println("sqle="+sqle);	
}finally{
	try {
		rs.close();
        stmt.close();
		if(con != null) con.close();
	}catch(SQLException sqle){
		out.println("sqle="+sqle);	
	}
}
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -