testjdbc.jsp

一些常用的java案例

<%@ page language="java" contentType="text/html" ; pageEncoding="utf-8"%>
<%@include file="inc.jsp"%>
<%
	String username = request.getParameter("username");
	String password = request.getParameter("password");
	if (username == null || password == null) {
		response.sendRedirect("login.jsp");
	}
	boolean isValid = false;
	String sql = "select * from user where username='" + username
			+ "'and password='" + password + "'";
	try {
		Class.forName(drv).newInstance();
		Connection conn = DriverManager.getConnection(url, usr, pwd);
		Statement stm = conn.createStatement();
		ResultSet rs = stm.executeQuery(sql);
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
		while (rs.next()) {
			for (int i = 1; i <= cols; i++) {
				String field = (String) (rsmd.getColumnName(i));
				String value = (String) (rs.getString(i));
				out.print(field + "=" + value + ";");
			}
		}
		rs.close();
		stm.close();
		conn.close();
	} catch (Exception e) {
		e.printStackTrace();
		out.println(e);
	}
%>