Servlet&JSP&Tomcat&oracle12c 跳转，表单获取提交等

环境：
Eclipse2018-09
JDK1.8
Tomcat 8
oracle 12c

主要实现：
Tomcat 和Eclipse 连接
Eclipse 中JSP 和Servlet的跳转，表单数据交互
Servlet 和 Oracle链接

Tomcat 和Eclipse 连接
window- preference-Server-Runtime …
Add，

JSP——》Servlet
方法一：链接，Get方式

<a href="Login">next step</a>

方法二：表单

	<form action="LoginCheck" method="POST">
		name:<input type="text" name="name"></br>
	
		<label>sex:</label>
		<select name="sex">
			<option value="man" name="man">man</option>
			<option value="woman" name="woman">woman</option>
		</select>
		</br>
		<input type="submit" value="submit">
	</form>

注意点：创建新的Servlet后，必须重启服务器，更新下xml
根据xml里的url-pattern写跳转到哪里

Servlet ——》 JSP

request.getRequestDispatcher("/time.jsp").forward(request, response);

Servlet ——》 Oracle
第一步：在安装oracle的目录下找到ojdbc
复制到工程下

注意点：如果直接从Java程序启动（不通过Tomcat服务器的话，是可以成功的）
如果通过服务器了，即启动oracle里，就需要在Tomcat下载文件中添加Oracle启动程序。
从Oracle里找下，复制进去

然后开始写代码

	// 连接DB
	public static Connection dbconnect() {
		// TODO Auto-generated method stub
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			// pdborcl:数据库名，Oracle12c下的数据库用PDB才行。
			// luffy:用户名
			// 123：密码
			Connection connection = (Connection) DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/pdborcl", "luffy", "123");
			return connection;
		} catch (Exception e) {
			// TODO: handle exception
			
			JOptionPane.showMessageDialog(null, e);
			return null;
		}
	}	

增删改查

// 查
	public static void query() {
		Connection connection = dbconnect();
		String sql = "select * from student";
		
		try {
			preparedStatement = connection.prepareStatement(sql);
			ResultSet resultSet = preparedStatement.executeQuery();
			while (resultSet.next()) {
				String name = resultSet.getString("stu_name");
				System.out.println(name);
			}
			resultSet.close();
			preparedStatement.close();
			connection.close();
			System.out.println(sql);
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}

// 删
	public static void delete() {
		Connection connection = dbconnect();
		String sql = "delete from student where stu_name='chen'";
		System.out.println(sql);
		try {
			preparedStatement = connection.prepareStatement(sql);
			preparedStatement.executeUpdate();
			} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		
	}

// 增
	public static void insert(String name, String sex) {
		Connection connection = dbconnect();
		String sql = "insert into client values(?,?)";
		System.out.println("insert begin");
		try {
			preparedStatement = connection.prepareStatement(sql);
			preparedStatement.setString(1, name); // 前面的1表示参数的Index
			preparedStatement.setString(2, sex);
			preparedStatement.executeQuery();
			
			preparedStatement.close();
			connection.close();
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}

// 改
	private static void update() {
		// TODO Auto-generated method stub
		Connection connection = dbconnect();
		String sql = "update student set stu_name = '2222' where stu_name='li'";
		try {
			preparedStatement = connection.prepareStatement(sql);
			preparedStatement.executeUpdate();
			} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		
	}