静态提交页面：addteamforjsp.html
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>增加小组</title>
</head>
<body>
<h1 align="center">增加小组</h1>
<form action="addTeamforbusiness.jsp" method="post">
<p>组名：<input type="text" name="name">
<p>口号：<input type="text" name="slogan">
<p>组长：<input type="text" name="leader">
<p><input type="submit" value="确定">
<input type="reset" value="重填">
</form>
<a href="index.html">返回首页</a>
</body>
</html>
到达动态处理的jsp页面：此页面将其存入到javabean标签中并调用一个java类来存入数据库。
<?xml version="1.0" encoding="GBK" ?>
<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@page import="business.TeamBusiness;"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK" />
<title>增加小组</title>
</head>
<body>
<%request.setCharacterEncoding("GBK");%>
<jsp:useBean id="team" class="bean.Team"/>
<jsp:setProperty name="team" property="*"/>
<%
try{
TeamBusiness.addTeam(team);
%>
<h1>增加小组成功</h1>
<%
}catch(Exception e){
e.printStackTrace();
%>
<h1>增加小组失败</h1>
<%
}
%>
<p><a href="addteamforjsp.html">继续增加</a>
<p><a href="index.html">返回首页</a>
</body>
</html>
javabean的类：bean.Team,用来存储临时的标签值
package bean;
public class Team {
private int id;
private String name;
private String slogan;
private String leader;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSlogan() {
return slogan;
}
public void setSlogan(String slogan) {
this.slogan = slogan;
}
public String getLeader() {
return leader;
}
public void setLeader(String leader) {
this.leader = leader;
}
}
调用的用来存储数据至数据库中的处理类：business.TeamBusiness
package business;
import java.sql.*;
import database.DataSource;
import bean.Team;
public class TeamBusiness{
public static void addTeam(Team team)throws Exception{
Connection cn=null;
PreparedStatement pst=null;
try{
cn=DataSource.getConnection();
pst=cn.prepareStatement("insert into team(name,slogan,leader) value(?,?,?)");
pst.setString(1, team.getName());
pst.setString(2, team.getSlogan());
pst.setString(3, team.getLeader());
pst.executeUpdate();
}catch(Exception e){
throw e;
}finally{
try{
cn.close();
pst.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
}
存入数据的时候，调用了连接数据库的类：database.DataSource
package database;
import java.sql.*;
public class DataSource{
public static Connection getConnection()throws Exception{
Connection cn=null;
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306://training";
String user="root";
String password="jakeyouxiang";
cn=DriverManager.getConnection(url,user,password);
return cn;
}
}
莫非这就是传说中的架构？哈哈。。。
366
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
