dbutils.java

JSP+Mysql的网上订餐,用户有增删改除等功能,订单模块

package com.yy.dao;

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

import javax.sql.DataSource;

import com.microsoft.sqlserver.jdbc.SQLServerDataSource;

public class DButils {
	Connection con=null;
	PreparedStatement ps=null;
	ResultSet rs=null;
	public DataSource getDataSource(){
		SQLServerDataSource source=new SQLServerDataSource();
		source.setServerName("localhost");
		source.setPortNumber(1433);
		source.setUser("sa");
		source.setPassword("123");
		source.setDatabaseName("restrant");
		return source;
	}
	public void closeCon()
	{
		if(con!=null)
		{
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	public void closePs()
	{
		if(ps!=null)
		{
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	public void closeRs()
	{
		if(rs!=null)
		{
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	

}