100分 的JAVA 初级问题！！！！！
用什么办法 连接 SQL2000数据库 阿 怎么我用JDBC-ODBC桥 连不上啊
可以帮我把语句写下来吗？ 谢谢大虾们
问题点数：100、回复次数：18Top
1 楼grpengwei（宠米）回复于 2004-11-02 23:14:30 得分 20
public class Mytest
{
public static void main(String args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:peng","","");//第一个参数是协议
System.out.println("连接成功");
}
catch(ClassNotFoundException ce){System.out.println("加载驱动失败");}
catch(SQLException se){System.out.println("连接失败");}
}
}Top
2 楼jia0（佳）回复于 2004-11-02 23:28:39 得分 0
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev","sn","sn");
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from book;");
while(rst.next())
{
out.println("<tr>");
out.println(rst.getString("bookId"));
out.println(rst.getString("bookName"));
out.println(rst.getString("publisher"));
out.println(rst.getFloat("price"));
}
rst.close();
stmt.close();
con.close();Top
3 楼blackcourser（潜心修炼）回复于 2004-11-02 23:32:02 得分 0
到MSTop
4 楼blackcourser（潜心修炼）回复于 2004-11-02 23:32:38 得分 0
找SQL SERVER的JDBC下载即可用Top
5 楼zhangwujiang（五江）回复于 2004-11-02 23:52:11 得分 0
大哥，你是怎么提问的
我怎么不会提问啊？
Top
6 楼pokalu（什么是痛苦）回复于 2004-11-03 00:50:46 得分 0
推荐用SQL SERVER 的JDBC驱动Top
7 楼alpha15（奥法）回复于 2004-11-03 01:44:32 得分 0
Statement 最好用PreparedStatement 代替
另外补充要配好数据源Top
8 楼weizhiyong311（人在江湖）回复于 2004-11-03 01:49:13 得分 20
看下面的，可以连接oracle 或MSSQL server,经过测试的！
import java.io.*;
import java.sql.*;
public class sqlBean{
public Connection conn=null;
public ResultSet rs=null;
//private String DatabaseDriver="sun.jdbc.odbc.JdbcOdbcDriver";
private String DatabaseDriver="oracle.jdbc.driver.OracleDriver";
//DataSource 数据源名称DSN
//private String DatabaseConnStr="jdbc:odbc:ClassDB2,'limq',123";
private String DatabaseConnStr="jdbc:oracle:thin:@localhost:1521:ORCL,'scott','tiger'";
//定义方法
/*setXxx用于设置属性值;getXxx用于得到属性值*/
public void setDatabaseDriver(String Driver){
this.DatabaseDriver=Driver;
}
public String getDatabaseDriver(){
return (this.DatabaseDriver);
}
public void setDatabaseConnStr(String ConnStr){
this.DatabaseConnStr=ConnStr;
}
public String getDatabaseConnStr(){
return (this.DatabaseConnStr);
}
public sqlBean(){/////构造函数
try{
Class.forName(DatabaseDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("加载驱动器有错误:"+e.getMessage( ));
System.out.print("执行插入有错误:"+e.getMessage());//输出到客户端
}
}
public int executeInsert(String sql){
int num=0;
try{
//conn = DriverManager.getConnection("jdbc:odbc:ClassDB","limq","123");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott","tiger");
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("执行插入有错误:"+ex.getMessage() );
System.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端
}
CloseDataBase();
return num;
}
// display data
public ResultSet executeQuery(String sql){
rs=null;
try{
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott","tiger");
//conn = DriverManager.getConnection("jdbc:odbc:ClassDB","limq","123");
Statement stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("执行查询有错误:"+ex.getMessage() );
System.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端
}
return rs;
}
// delete data
public int executeDelete(String sql){
int num=0;
try{
//conn = DriverManager.getConnection("jdbc:odbc:ClassDB","limq","123");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott","tiger");
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("执行删除有错误:"+ex.getMessage() );
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端
}
CloseDataBase();
return num;
}
//////////////////
public void CloseDataBase(){
try{
conn.close();
}
catch(Exception end){
System.err.println("执行关闭Connection对象有错误："+end.getMessage( ) );
System.out.print("执行执行关闭Connection对象有错误：有错误:"+end.getMessage()); //输出到客户端
}
}
}
Top
9 楼lenoli（可乐吧）回复于 2004-11-03 08:04:57 得分 0
要个sqlserver的jdbc驱动Top
10 楼lxjian2008（云天飞）回复于 2004-11-03 08:55:16 得分 0
上边的说完了，让我怎么说呀，呵呵Top
11 楼wolfdlut（大工狼）回复于 2004-11-03 09:23:13 得分 0
我的程序 还没做完呢!现在不知道为什么 BUTTON1 的插入功能实现不了!大家帮我看一下好吗/
ge wolf;//打包
import javax.swing.*;
import javax.swing.JOptionPane.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
public class Frame1 extends JFrame //定义主类
{
JButton jButton1 = new JButton();
JPanel jPanel1 = new JPanel();
JButton jButton2 = new JButton();
JButton jButton3 = new JButton();
JButton jButton4 = new JButton();
JPanel jPanel2 = new JPanel();
JPanel jPanel3 = new JPanel();
JPanel jPanel4 = new JPanel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JTextField jTextField2 = new JTextField();
JTextField jTextField4 = new JTextField();
JTextField jTextField5 = new JTextField();
JTextField jTextField6 = new JTextField();
JPanel jPanel5 = new JPanel();
Connection connect;
String url;
JButton jButton5 = new JButton();
GridLayout gridLayout1 = new GridLayout();
String Slected[]={"普通","特殊"};
JComboBox jComboBox1 = new JComboBox(Slected);
JTextArea jTextArea1 = new JTextArea();
JScrollPane jScrollPane1 = new JScrollPane();
JMenuBar jMenuBar1 = new JMenuBar();
JMenu jMenu1 = new JMenu();
JMenu jMenu2 = new JMenu();
JMenuItem jMenuItem1 = new JMenuItem();
JLabel jLabel4 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JLabel jLabel5 = new JLabel();
GridLayout gridLayout2 = new GridLayout(6,1);
JMenu jMenu3 = new JMenu();
JMenuItem jMenuItem2 = new JMenuItem();
public Frame1() //定义构建器
{
try {
langxiaofeng();//为该系统的版面设计方法
}
catch(Exception e) {
e.printStackTrace();
}
}
private void langxiaofeng() throws Exception//对该系统的版面设计方法的编制
{
setTitle("生产的实时控制");
jButton1.setText("添加订单");
jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
this.getContentPane().setLayout(null);
jPanel1.setLayout(gridLayout1);
jButton2.setText("删除订单");
jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
jButton3.setText("生产判断");
jButton3.addActionListener(new Frame1_jButton3_actionAdapter(this));
jButton4.setText("开始生产");
jButton4.addActionListener(new Frame1_jButton4_actionAdapter(this));
jPanel2.setLayout(null);
jPanel3.setLayout(gridLayout2);
jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
jLabel2.setText(" 型号");
jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
jLabel3.setText(" 类别");
jPanel4.setLayout(null);
jTextField2.setText("");
jTextField2.setBounds(new Rectangle(4, 3, 168, 27));
jTextField4.setText("");
jTextField4.setBounds(new Rectangle(4, 66, 168, 27));
jTextField5.setText("");
jTextField5.setBounds(new Rectangle(4, 99, 168, 27));
jTextField6.setText("");
jTextField6.setBounds(new Rectangle(4, 132, 168, 27));
jPanel5.setLayout(null);
jButton5.setText("清空");
jButton5.addActionListener(new Frame1_jButton5_actionAdapter(this));
jComboBox1.setDebugGraphicsOptions(0);
jComboBox1.setToolTipText("");
jComboBox1.setEditable(false);
jComboBox1.setSelectedIndex(0);
jComboBox1.setSelectedItem(this);
jComboBox1.setBounds(new Rectangle(4, 35, 168, 27));
this.setLocale(java.util.Locale.getDefault());
this.setJMenuBar(null);
this.setState(Frame.NORMAL);
jMenu1.setText(" 关于");
jMenu2.setText(" 作者");
jMenuItem1.setText("Read me");
jMenuItem1.addActionListener(new Frame1_jMenuItem1_actionAdapter(this));
jPanel4.setDebugGraphicsOptions(0);
jPanel4.setBounds(new Rectangle(100, 0, 391, 202));
jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
jLabel4.setText(" 数量");
jLabel6.setFont(new java.awt.Font("Dialog", 0, 13));
jLabel6.setText(" 订购时间");
jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
jLabel5.setText(" 编号");
jScrollPane1.setBounds(new Rectangle(16, 22, 465, 116));
jPanel5.setBounds(new Rectangle(5, 317, 493, 167));
jPanel2.setBounds(new Rectangle(-2, 78, 514, 202));
jPanel1.setBounds(new Rectangle(0, 1, 493, 41));
jPanel3.setDebugGraphicsOptions(0);
jPanel3.setBounds(new Rectangle(2, 0, 96, 197));
jMenu3.setText(" 系统简介");
jMenuItem2.setText("Read_me");
jMenuItem2.addActionListener(new Frame1_jMenuItem2_actionAdapter(this));
jPanel1.add(jButton1, null);
jPanel1.add(jButton2, null);
jPanel1.add(jButton3, null);
jPanel1.add(jButton4, null);
jPanel1.add(jButton5, null);
jPanel3.add(jLabel2, null);
jPanel3.add(jLabel3, null);
jPanel3.add(jLabel4, null);
jPanel3.add(jLabel5, null);
jPanel3.add(jLabel6, null);
jPanel3.add(jLabel7, null);
jPanel2.add(jPanel4, null);
this.getContentPane().add(jPanel5, null);
jPanel5.add(jScrollPane1, null);
jScrollPane1.getViewport().add(jTextArea1, null);
this.getContentPane().add(jPanel2, null);
jPanel4.add(jTextField4, null);
jPanel4.add(jTextField6, null);
jPanel4.add(jComboBox1, null);
jPanel4.add(jTextField2, null);
jPanel2.add(jPanel3, null);
jPanel4.add(jTextField5, null);
this.getContentPane().add(jPanel1, null);
jMenuBar1.add(jMenu1);
jMenu1.add(jMenu2);
jMenu1.add(jMenu3);
jMenu2.add(jMenuItem1);
jMenu3.add(jMenuItem2);
setJMenuBar(jMenuBar1);
try{
url = "jdbc:odbc:SulzerDB";//数据库连接
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
connect = DriverManager.getConnection(url);
jTextArea1.append("Connection Successful!");
}
catch ( ClassNotFoundException cnfex ) {
cnfex.printStackTrace();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
catch ( Exception ex ) {
ex.printStackTrace();
}
setSize(600,520);
show();
}
void jButton1_actionPerformed(ActionEvent e) //定义BUTTON1的响应事件
{
try {
Statement statement = connect.createStatement();
if (namelegal()&&legal()&&judge_sex()&&judge_idnum()) {
String query = "INSERT INTO dingdan VALUES"+
"('" +
jTextField5.getText() + "', '" +
jTextField2.getText() + "', '" +
jComboBox1.getSelectedItem() + "', '" +
jTextField4.getText() + "', '" +
jTextField6.getText() +"')";
int result = statement.executeUpdate(query);
if (result == 1)
jTextArea1.append("\n插入成功\n");
else {
jTextArea1.append("\n插入失败\n");
jTextField2.setText("");
jComboBox1.setSelectedIndex( -1);
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
}
}
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
Top
12 楼wolfdlut（大工狼）回复于 2004-11-03 09:24:53 得分 0
void jButton3_actionPerformed(ActionEvent e) {//定义BUTTON3的响应事件
try {
if ( !jTextField2.getText().equals( "" ) ) {
Statement statement =connect.createStatement();
String query = "SELECT * FROM student " +
"WHERE name = '" +jTextField2.getText() + "'";
ResultSet rs = statement.executeQuery( query );
display( rs );
jTextArea1.append( "\n查询成功\n" );
statement.close();
}
else
jTextArea1.setText(
"请输入要查找的用户姓名" );
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void display( ResultSet rs )
{
try {
if (rs.next() ) {
jTextField2.setText( rs.getString( 2 ) );
jComboBox1.setSelectedItem( rs.getString( 3 ) );
jTextField4.setText( rs.getString( 4 ) );
jTextField5.setText( rs.getString( 1 ) );
jTextField6.setText( rs.getString( 5 ) );
}
else
jTextArea1.append( "\n没找到您想要的记录记录\n" );
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void jButton5_actionPerformed(ActionEvent e)//定义BUTTON5的响应事件
{
jTextField2.setText("");
jComboBox1.setSelectedIndex(-1) ;
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextArea1.setText("");
}
void jButton2_actionPerformed(ActionEvent e)//定义BUTTON2的响应事件
{
try {
Statement statement = connect.createStatement();
if ( !jTextField2.getText().equals( "" ) ) {
String query = "DELETE FROM student WHERE name LIKE" +
"'"+jTextField2.getText()+"'";
int result = statement.executeUpdate( query );
if ( result == 1 )
jTextArea1.append( "\n删除成功\n" );
else {
jTextArea1.append( "\n删除失败\n" );
jTextField2.setText( "" );
jComboBox1.setSelectedIndex(-1);
jTextField4.setText( "" );
jTextField5.setText( "" );
jTextField6.setText( "" );
}
}
else
jTextArea1.append( "\n请您输入名子" );
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void jMenuItem1_actionPerformed(ActionEvent e) //对菜单项进行设置，提供了一个作者简介和系统简介
{
JTextArea t=new JTextArea(10,15);
t.setLineWrap(true);
t.setEditable(false);
JScrollPane p=new JScrollPane(t);
t.setText("作者：郎晓峰 管理0101班 学号：200000002");
JOptionPane.showMessageDialog(null,p,"谢谢使用，请多提意见！",JOptionPane.INFORMATION_MESSAGE);
}
void jButton4_actionPerformed(ActionEvent e) //定义BUTTON4的响应事件
{
try {
if ( !jTextField5.getText().equals( "" ) ) {
Statement statement =connect.createStatement();
String query = "SELECT * FROM student " +
"WHERE id = '" + jTextField5.getText() + "'";
ResultSet rs = statement.executeQuery( query );
display( rs );
jTextArea1.append( "\n查询成功\n" );
statement.close();
}
else
jTextArea1.setText(
"请输入要查找的学生学号" );
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
/**该方法是年龄范围的合法性检验*/
boolean judge_age(String input)
{
int age;
try{
age = Integer.parseInt(input);
}catch(Exception e){
return false;
}
if((age >= 1) && (age <=100))
return true;
else
return false;
}
/**该方法是对名字的合法性检验*/
boolean namelegal()
{
if(!jTextField2.getText().equals("")&&jTextField2.getText().length()<=50)
return true;
else
{
message("必须输入姓名，且长度不能超过50");
return false;
}
}
Top
13 楼wolfdlut（大工狼）回复于 2004-11-03 09:26:30 得分 0
/**该方法是年龄范围的合法性检验的判断以及提示框的设计*/
boolean legal()
{
if( judge_age(jTextField4.getText()))
return true;
else{
message("年龄必须在1到100之间，请重新输入！");
jTextField4.setText("");
jTextField6.setText("");
return false;
}
}
/**该方法是对学号长度的合法性检验和对话框显示规则*/
boolean judge_idnum()
{
if(jTextField5.getText().length()==4 )
{
String front1=jTextField5.getText().substring(0,4);
String front2=jTextField5.getText().substring(4,8);
if(idnum(front1)&&idnum(front2))
return true;
else
{
message("编号必须为4位的数字，请重新输入！");
jTextField5.setText("");
return false;
}
}
else
{
message("编号必须为4位的数字,请重新输入!");
jTextField5.setText("");
return false;
}
}
boolean idnum(String t)
{
try{
Integer.parseInt(t);
}catch(Exception e){
return false;
}
return true;
}
/**该方法要求必须对学生的性别有所选择*/
boolean judge_sex()
{
if(!jComboBox1.getSelectedItem().equals(""))
return true;
else
{
message("请选择类别");
return false;
}
}
void message(String t)
{
JOptionPane.showMessageDialog(null,t);
}
void jMenuItem2_actionPerformed(ActionEvent e) {
JTextArea t=new JTextArea(10,15);
t.setLineWrap(true);
t.setEditable(false);
JScrollPane p=new JScrollPane(t);
t.setText("本程序为学生档案管理系统，采用微软的Access数据库实现！");
JOptionPane.showMessageDialog(null,p,"欢迎您再次使用",JOptionPane.INFORMATION_MESSAGE);
}
public static void main(String args[])//定义了该类的主方法
{
Frame1 app=new Frame1();
app.addWindowListener(
new WindowAdapter(){
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
}
);
}
}
class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame1_jButton3_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton3_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Frame1_jButton5_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton5_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class Frame1_jMenuItem1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jMenuItem1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuItem1_actionPerformed(e);
}
}
class Frame1_jButton4_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton4_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class Frame1_jMenuItem2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jMenuItem2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuItem2_actionPerformed(e);
}
}
完! 请大家帮忙看一下!!!解决问题之后我马上结贴!!!有劳大虾!Top
14 楼olimpicgames2008（）回复于 2004-11-03 09:33:42 得分 0
xuexiTop
15 楼duanma（断码）回复于 2004-11-03 18:26:36 得分 0
晕，没有必要搞那么多代码！
你最好编一个测试代码，以便顺利连接数据库。
Top
16 楼frhwxx（笑对^_^人生）回复于 2004-11-03 18:36:40 得分 60
/*
* Created on 2004-6-14
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Generation - Code and Comments
*/
package chinavnet.SP.AuthPay;
/**
* @author Administrator
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Generation - Code and Comments
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import Microsoft.DVAP.PSO.PSOConfig;
public class JDBCHelper {
private String driverName;
private String dbURL;
private static JDBCHelper helper;
private JDBCHelper() throws RuntimeException
{
try
{
driverName = PSOConfig.getConfigInfo("driverName");
dbURL = PSOConfig.getConfigInfo("dbURL");
Class.forName(driverName).newInstance();
}
catch(Exception e)
{
throw new RuntimeException(e);
}
}
public Connection getConnection() throws RuntimeException
{
Connection conn = null;
try
{
conn = DriverManager.getConnection(dbURL);
}
catch(SQLException e)
{
throw new RuntimeException(e);
}
return conn;
}
public synchronized static JDBCHelper getDefault()
{
if(helper == null)
{
helper = new JDBCHelper();
}
return helper;
}
public static void main(String[] args) throws Exception {
PSOConfig.setPropertyFile(ConfigInfo.CONFIG_FILE);
JDBCHelper helper = JDBCHelper.getDefault();
Connection conn = helper.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select name from sysobjects");
while(rs.next())
{
System.out.println(rs.getString("name"));
}
conn.close();
}
}
Top
17 楼frhwxx（笑对^_^人生）回复于 2004-11-03 18:37:46 得分 0
我的是个Helper，通用的！Top
18 楼jingfeng198（没有昵称( ^_^ )）回复于 2004-11-03 19:09:17 得分 0
haha,真多Top
