java数据更新_java 数据更新简单实例

package com;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class ConnectionManager {  private static final String DRIVER_CLASS="com.microsoft.sqlserver.jdbc.SQLServerDriver";  private static final String DATABASE_URL="jdbc:sqlserver://127.0.0.1:1433;databasename=news";  private static final String DATABASE_USER="sa";  private static final String DATABASE_PASSWORD="123456";  //连接数据库的方法

public static Connection getConnection(){

Connection dbConnection=null;

try{

Class.forName(DRIVER_CLASS);    dbConnection=DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);   catch(Exception e){

e.printStackTrace();   return dbConnection;  //关闭数据库连接的方法

public static void  closeConnection(Connection dbConnection){

try{

if(dbConnection!=null&&(!dbConnection.isClosed())){

dbConnection.close();   }

catch(SQLException sqlEx){

sqlEx.printStackTrace();    //关闭数据集

public static void closeResultSet(ResultSet res){

try{

if(res!=null){

res.close();

res=null;   }

catch(SQLException e){

e.printStackTrace();  }  public static void closeStatement(PreparedStatement pStatement){

try{

if(pStatement!=null){

pStatement.close();

pStatement=null;   }

catch(SQLException e){

e.printStackTrace();  }

}