BaseDAO

sql

package org.epet.dao.impl;

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

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

import com.sun.java_cup.internal.internal_error;

public abstract class BaseDAO {
    private static final String DRIVER_CLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private static final String DATABASE_URL = "jdbc:sqlserver://localhost:1433;DatabaseName=epet";
    private static final String DATABASE_USER = "sa";
    private static final String DATABASE_PASSWORD = "accp";
    
    /** *//**
     * 返回连接
     * @return
     */
    public static Connection getConnection() {
        Connection connection=null;
        try {
            Class.forName(DRIVER_CLASS);
            connection = DriverManager.getConnection(DATABASE_URL,
                    DATABASE_USER, DATABASE_PASSWORD);
//                Context tx=new InitialContext();
//                DataSource ds=(DataSource)tx.lookup("java:comp/env/food");
//                connection=ds.getConnection();

        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return connection;
    }
    /** *//**
     * 查询
     * @param sql
     * @return
     */
    public static ResultSet getDate(String sql){
        Connection connection=getConnection();
        ResultSet resultSet=null;
        try {
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            resultSet=preparedStatement.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return resultSet;
    }
    
    public static int dele(String sql,int id){
        int result=0;
        Connection connection=getConnection();
        try {
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setInt(1, id);
            result=preparedStatement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return result;
    }
}

mysql:

/**//*show databases;
create database aa;
use aa;
show tables;
select * from userinfo limit 1,2;
-----------------------------------------*/
public connection getConnection () throws SQLException{
  Class.forName("com.mysql.jdbc.Driver");
  String url="jdbc:mysql://127.0.1:3306/somken(数据库名)";
  return DriverManager.getConnection(url,"root","root");
}