dbconnection.java

一个简单的标签搜索.通过标签可以模糊查询数据.

package com.fxe.dcl1.util;

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

public class DBConnection {

	/**
	 * 创建数据库连接
	 * @return Connection
	 */
	public static Connection getCon()
	{
		Connection con=null;
		try {
			Class.forName("net.sourceforge.jtds.jdbc.Driver");
			con=DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433;DatabaseName=cang","sa","");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;
	}
}