java jdbc and servlet

1.  代码有错误

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.java.util.GetConnection;
import java.util.Scanner;
import com.java.util.GetConnection;


public class Test3 {

	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
		Connection conn=null;
		Statement stmt=null;
		
//		conn=GetConnection.getConn();
//		String sql="select * from stu";
//		stmt=conn.createStatement();
//		ResultSet rs=stmt.executeQuery(sql);
		

		conn=GetConnection.getConn();//获取公共的连接对象
		Scanner s=new Scanner(System.in); 
		System.out.println("请输入id:");
		int id=s.nextInt();
		System.out.println("请输入姓名:");
		String name=s.next();
		System.out.println("请输入年龄:");
		int age=s.nextInt();
		System.out.println("请输入性别:");
		String sex=s.next();
		//编写sql
		String sql="insert into stu(id,name,age,sex)"
				+ "values("+id+",'"+name+"',"+age+",'"+sex+"');";
		//Statement对象用来执行sql
		stmt=conn.createStatement();
		//执行sql
		 stmt.execute(sql);
	//	 ResultSet rs=stmt.executeQuery(sql);
//		while(rs.next()) {
//			System.out.print("id:"+rs.getInt("id")+"-");
//			System.out.print("姓名:"+rs.getString("name")+"-");
//			System.out.print("年龄:"+rs.getInt("age")+"-");
//			System.out.print("性别:"+rs.getString("sex")+"\n");
//		}			
		conn.close();
		stmt.close();		
	}
}

2. 

package com.java.testservlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class TestServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String s="***********this is servlet web**********";
		response.setCharacterEncoding("utf-8");
		PrintWriter pw=response.getWriter();
		pw.print(s);
		
		
	}

	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		doGet(request, response);
	}

}

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>TestServlet</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <servlet>  
  	<servlet-name>TestServlet</servlet-name>
  	<servlet-class>com.java.testservlet.TestServlet</servlet-class>
  </servlet>
  
  <servlet-mapping>
  	<servlet-name>TestServlet</servlet-name>
  	<url-pattern>/TestServlet</url-pattern>
  </servlet-mapping>
  
</web-app>