Java 我安装了SQL2000和MyEclipse要实现程序与数据库的连接需要做什么

你要有JAVA 里MSSQL的JAR包。有3个。 mssqlserver.jar msbase.jar msutil.jar

然后写一个数据库连接类

package Menu.menu;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import Menu.menu.toString;

public class Resutbbs {

private static final String hrmname = null;

String sDBDriver;

String sConnStr;

String user;

String pass;

Connection conn;

ResultSet rs;

String DriverClasses;

String dburl;

String users;

String password;

// static String urlpath=tongcan.root;

public Resutbbs() throws IOException {
File directory = new File(".");
//String paths=directory.getCanonicalPath()+"/WebRoot/WEB-INF/Myproj.properties";
//File file = new File(paths);
File file = new File("/WEB-INF/prop/jdbc.properties");
FileInputStream fin = new FileInputStream(file);
Properties pro = new Properties();
pro.load(fin);
DriverClasses = pro.getProperty("DriverClasses");
dburl = pro.getProperty("ecology.url");
users = pro.getProperty("ecology.user");
password = pro.getProperty("ecology.password");
sDBDriver = DriverClasses;
sConnStr = dburl;
user = users;
pass = password;
conn = null;
rs = null;
try {
Class.forName(sDBDriver);
fin.close();
} catch (ClassNotFoundException classnotfoundexception) {
System.err.println("rs(): " + classnotfoundexception.getMessage());
fin.close();
}
}

public void executeInsert(String s) {
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
int i = statement.executeUpdate(s);
} catch (SQLException sqlexception) {
System.err.println("rs.executeUpdate:" + sqlexception.getMessage()
+ "sConnStr=" + sConnStr);
}
}

public ResultSet executeQuery(String s) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = statement.executeQuery(s);
} catch (SQLException sqlexception) {
System.err.println("rs.executeQuery: " + sqlexception.getMessage()
+ "sConnStr=" + sConnStr);
}
return rs;
}

public void executeDelete(String s) {
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement();
statement.executeUpdate(s);
} catch (SQLException sqlexception) {
System.err
.println("rs.executeDelete: " + sqlexception.getMessage());
}
}

public int executeUpdate(String s) {
int i = 0;
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement();
i = statement.executeUpdate(s);
} catch (SQLException sqlexception) {
System.err
.println("rs.executeDelete: " + sqlexception.getMessage());
}
return i;
}

/**
* 分页
*
* @return
*/
public ResultSet getResultset(int thePage, int count, String sql,
String table_name) {
count = (thePage - 1) * count;
sql = sql + " WHERE (ID NOT IN(SELECT TOP " + count + " id FROM "
+ table_name + " ORDER BY id)) ORDER BY ID";
System.out.println("sql:" + sql);
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement();
rs = statement.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
}
return rs;
}

/**
* EXT分页
*
* @return
*/
public ResultSet getResultsetForEXT(int start, int limit, String sql,
String table_name) {
sql = sql + " WHERE (ID NOT IN(SELECT TOP " + start + " id FROM "
+ table_name + " ORDER BY id)) ORDER BY ID";
System.out.println("sql:" + sql);
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement();
rs = statement.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
}
return rs;
}

/**
* 带WHERE条件的EXT分页
*
* @param start
* @param limit
* @param table_name
* @param where
* @return
*/
public ResultSet getResultsetForEXT_2(int start, int limit,
String table_name, String where) {
String sqlIn = "SELECT TOP " + start + " id FROM [" + table_name
+ "] WHERE " + where + " ORDER BY id";
String sqlOut = "SELECT TOP " + limit + " * FROM [" + table_name + "]";
String sql = sqlOut + " WHERE (ID NOT IN(" + sqlIn + ")) AND " + where
+ " ORDER BY ID";
System.out.println("sql:" + sql);
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement();
rs = statement.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
}
return rs;
}

/**
* 改进后的EXT分页
*
* @param start
* @param limit
* @param table_name
* @return
*/
public ResultSet getResultsetForEXT_2(int start, int limit,
String table_name) {
String sqlIn = "SELECT TOP " + start + " id FROM [" + table_name
+ "] ORDER BY id";
String sqlOut = "SELECT TOP " + limit + " * FROM [" + table_name + "]";
String sql = sqlOut + " WHERE (ID NOT IN(" + sqlIn + ")) ORDER BY ID";
System.out.println("sql:" + sql);
try {
conn = DriverManager.getConnection(sConnStr, user, pass);
Statement statement = conn.createStatement();
rs = statement.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
}
return rs;
}

public void Close() {
try {
if (rs != null)
rs.close();
if (conn != null)
conn.close();
} catch (SQLException sqlexception) {
System.err.println("rs.close: " + sqlexception.getMessage());
}
}
public String getTime() {
String datestr = "" ;
try {
java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy-M-d HH:ss") ;
java.util.Date date = new java.util.Date() ;
datestr = df.format(new java.util.Date()) ;
}
catch (Exception ex) {
}
return datestr ;
}

public ResultSet getRs() {
return rs;
}
public boolean next()
{
return true;
}
}

还需要jdbc驱动和java环境变量.