壹咪陽光

隨筆-124 評論-49 文章-56 trackbacks-0

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");

}

posted on 2009-11-30 08:21 junly 閱讀(528) 評論(0) 編輯收藏所屬分類: oracle/mysql/sql

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: oracle游標 oracle控制語句 oracle函數大全 oracle變量 sql 精典-oracle oracle存儲過程,函數,包 sql思路配數據庫的方式 BaseDAO sql配置文檔