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>