connectdb.java

新闻管理系统实现对新闻添加修改删除外挂了一个用户的注册还有一个外挂的投票

package com.vsked.models;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.PreparedStatement;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class ConnectDB {
	private static Connection conn;
	private static DataSource ds;
	private static Context cont;	
	private static PreparedStatement pt;
	private static ResultSet rs;
	private static ResultSetMetaData rsmd;
	
	
	//连接数据库
	public static Connection getConnectionJNDI(){
		try {
			cont=new InitialContext();
			ds=(DataSource) cont.lookup("java:comp/env/news");
			System.out.println("ds----"+ds.toString());
			conn=ds.getConnection();
			System.out.println("conn"+conn);
			
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		
		return conn;
		
	}
	public static Connection getConnectionJDBC(){
		
			try {
				Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
				String url="jdbc:microsoft:sqlserver://localhost:1433;databasename=newsmanager";
				conn=DriverManager.getConnection(url, "sa", "sa");
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}	
		return conn;
		
	}
	
	public static void close(){
		try{
			if(rs!=null){
				rs.close();
			}
			if(pt!=null){
				pt.close();
			}
			if(conn!=null){
				conn.close();
			}
		}
		catch(SQLException e){
			
		}
		
	}
	
	
	
	
}