b.jsp

连接数据库的小程序 连接数据库的小程序

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<%! 
String name="";
String pass="";
String pass2="";
%>
<% 
name=request.getParameter("t1");
pass=request.getParameter("t2");
pass2=request.getParameter("t3");
if(pass.equals(pass2))
{
try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:zhao");
			Statement stmt=con.createStatement();
			String sql="insert into student (e_name,e_pass) values('"+name+"','"+pass+"')";
			stmt.executeUpdate(sql);
			con.close();
			stmt.close();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
		
}




else
{response.sendRedirect("a.jsp");}
%>