sqlheadinformation.java

简单的学生管理系统,使用的是SQL2005数据库

package sql;

import java.lang.reflect.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import sun.misc.Request;

import javabean.JavaBean;

public class SQLHeadInformation {
	
	public JavaBean methodhead (String id){
		
		//HttpSession session = request.getSession();
		
		//String name = null;
		JavaBean info = new JavaBean();
		try{
			try 
			{
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			} catch (ClassNotFoundException e)
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=stu","sa","123");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from users where id='"+id+"'");
			if(rs.next())
			{
				
				info.setId(rs.getString("id"));
				info.setName(rs.getString("name"));
				info.setProperty(rs.getString("property"));
				info.setAge(rs.getString("age"));
				info.setGender(rs.getString("gender"));
				info.setClasss(rs.getString("classs"));
				info.setCoursenumber(rs.getString("coursenumber"));
				info.setProperty1(rs.getString("property"));
			}
			con.close();
			rs.close();
			
		}catch(SQLException ex){
			ex.printStackTrace();
			
		}
		return info;
		
		
	}

}