jdk+jswdk+mysql+jdbc驱动？？？

Question

没有用过JDK
用的是WB  sqlserver2000
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");可能通过jb7来测试，你是否和数据库连接成功

Answer 1

jdbc的驱动程序去www.mysql.org下载，
jdbc链接数据库的代码
import java.sql.*;public class Jdbc_conn{
    String sDBDriver="org.gjt.mm.mysql.Driver";
    String sConnStr="jdbc:mysql://localhost:3306/note?user=skyyjl&password=abc";
    Connection conn=null;
    ResultSet rs=null;
    
public Jdbc_conn(){
try{
            Class.forName(sDBDriver);
        }
        catch(java.lang.ClassNotFoundException e){
            System.out.println("Jdbc_conn():"+e.getMessage());
        }
    }

public void executeUpdate(String sql)throws Exception{
sql=new String(sql.getBytes("GBK"),"ISO8859_1");
try{
conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            stmt.executeUpdate(sql);
conn.close();
stmt.close();
        }
        catch(SQLException ex){
            System.out.println("sql.executeUpdate:"+ex.getMessage());
        }
    }
public ResultSet executeQuery(String sql)throws Exception{
        rs=null;
try{
sql=new String(sql.getBytes("GBK"),"ISO8859_1");
            conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            rs=stmt.executeQuery(sql);
conn.close();
stmt.close();
        }
        catch(SQLException ex){
            System.out.println("sql.executeQuery:"+ex.getMessage());
        }
return rs;
    }
}