connectiondb.java

这是一个学校老师和学生的管理系统,程序比较简单,但是几乎所有功能都可以实现,如果想要用,只要再添加一些东西就可以了.

/**
 *******************************************************************************
 * ConnectionDB.java
 *
 * (c) Copyright 2008 Hewlett-Packard Development Company, L.P.
 *
 *<Program Content>
 *  System Name ： Students Management System
 *<Summarize>
 *  The file includes a class and the class main function is to connect the database.
 *<Update Record>
 *  2009-4-22    1.00    zhangliy
 *******************************************************************************
 */
package com.hp.eds.zhangliyuan.stuMan.util;

import java.sql.*;

/**
 * The class main function is to connect the database.
 * 
 * @author zhangliy
 * @version 1.0
 */
public class ConnectionDB {
	/**
	 * connect the database
	 * 
	 * 
	 * @return Connection
	 */
	public static Connection getConn() {
		Connection conn = null;
		String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=StuMan";
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			conn = DriverManager.getConnection(url, "sa", "123456");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
}