BaseDAO - 壹咪阳光

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 阅读(515) 评论(0) 编辑收藏所属分类: oracle/mysql/sql

常用链接

留言簿(4)

随笔分类

随笔档案

收藏夹

other

文章

搜索

最新评论

阅读排行榜

评论排行榜


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻知识库 C++博客博问管理
相关文章: oracle游标 oracle控制语句 oracle函数大全 oracle变量 sql 精典-oracle oracle存储过程,函数,包 sql思路配数据库的方式 BaseDAO sql配置文档