dbconnection.java

利用MVC在WEB页面中实现参数的增加,删除,查询,更新.

package com.hwadee.datasource;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {

	public static Connection getConnection() {
		String jdbcDriver = "net.sourceforge.jtds.jdbc.Driver"; 
		String connectionString = "jdbc:jtds:sqlserver://localhost/test";// 数据库连接字符串
		String username = "sa"; // 数据库用户名
		String password = ""; // 数据库密码 
		
		Connection con = null;

		try {
			Class.forName(jdbcDriver);
		} catch (ClassNotFoundException e) {
			System.err.println(e.toString());
		}
		try {
			con = DriverManager.getConnection(connectionString, username, password);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
	}
	
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Connection con = DBConnection.getConnection();
		System.out.println(con);
	}

}