jdbc 连接数据库

package com.rsms.servlet;

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

public class DBHandle {
 
    //创建数据库连接对象 。对象为空时 表示连接失败
 Connection conn=null;
 //执行SQl语句的对像
 Statement st = null;
 //存放查询结果的对象
 ResultSet rs= null;
 
 //连接数据库！
 public void getConnection(){

private final static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private final static String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=Test";

  
      String url="jdbc:mysql://localhost:3306/ygdisms";
   String  user="root";
   String password="root";
   try {
    Class.forName("com.mysql.jdbc.Driver");
   } catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    System.out.println("驱动加载失败！");
   }
    try {
     //创建连接
    conn= DriverManager.getConnection(url,user,password);
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    System.out.println("连接数据库失败！");
   }
 }
 //数据库查询
 public ResultSet executeQuery(String sql){
   if(conn==null){
    getConnection();
   }
   try {
   if (st == null) {
    st = conn.createStatement();
   }
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   try {
   rs=st.executeQuery(sql);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return rs;
 }
 public Connection getConn() {
  return conn;
 }
 public void setConn(Connection conn) {
  this.conn = conn;
 }
 public Statement getSt() {
  return st;
 }
 public void setSt(Statement st) {
  this.st = st;
 }
 public ResultSet getRs() {
  return rs;
 }
 public void setRs(ResultSet rs) {
  this.rs = rs;
 }
 //数据库增加、删除、修改！
 public int executeUpdate(String sql){
  int ret=0;
  if(conn==null){
   getConnection();
  }
  try {
   if(st==null){
    st=conn.createStatement();
   }
   ret=st.executeUpdate(sql);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  ret=-1;
  }
  return ret;
 }
 //关闭数据库
 public void close(){
  try {
   if (rs != null) {
    rs.close();
   }
   if (st != null) {
    st.close();
   }
   if (conn != null) {
    conn.close();
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
 }
}