register.java

好东西 利用J2EE开发的系统 能连接数据库

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class register extends HttpServlet
{
	public void doGet(HttpServletRequest req ,HttpServletResponse res)throws ServletException, IOException
	{
		res.setContentType("text/html");
		PrintWriter out = res.getWriter();
		String name = req.getParameter("username");
		String password = req.getParameter("password");


		try{

			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		  }
			catch(ClassNotFoundException ce)
			{
				out.println(ce);
			}

		try{
			Connection con = DriverManager.getConnection("jdbc:odbc:book");
			Statement st = con.createStatement();
			int r = st.executeUpdate("insert into check values('"+name+"', '"+password+"')");
		}catch(SQLException se)
			{
				out.println(se.toString());
			}
		res.sendRedirect("books");
	}

	public void doPost(HttpServletRequest req ,HttpServletResponse res)throws ServletException, IOException
	{
			doGet(req,res);
	}
}