代码:package Mysql;import java.io.*;
import java.sql.*;public class lianjie {
public static void main(String[] args) {
String driver="org.gjt.mm.mysql.Driver";
String url="jdbc:mysql://localhost:3306/cixu";
String user="root";
String password="123456"; try
{
Class.forName(driver);
System.out.print("加载成功.");
}
catch(Exception E)
{
System.out.print("无法加载驱动程序:"+driver);
E.printStackTrace();
} try
{
Connection con=DriverManager.getConnection(url,user,password); Statement smt=con.createStatement();
System.out.print("连接成功");
String sql="update cixu set weizhi=0 where Function='Function1;'";
smt.executeQuery(sql);
con.close();
}
catch(Exception E)
{
E.printStackTrace();
}
}
}结果出现问题:
我用的是Jbuilder9,JDBC是 mysql-connector-java-3.1.14-bin.jar,
编译的时候就会弹出如下异常:C:\JBuilder9\jdk1.4\bin\javaw -classpath "E:\java\sql\sql\classes;C:\JBuilder9
\jdk1.4\demo\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\demo\plugin\jfc\Java
2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\jre\lib\charsets.jar;C:\JBuilder9\jdk1.4\
jre\lib\ext\dnsns.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\ldapsec.jar;C:\JBuilder9
\jdk1.4\jre\lib\ext\localedata.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\sunjce_prov
ider.jar;C:\JBuilder9\jdk1.4\jre\lib\im\indicim.jar;C:\JBuilder9\jdk1.4\jre\li
b\jaws.jar;C:\JBuilder9\jdk1.4\jre\lib\jce.jar;C:\JBuilder9\jdk1.4\jre\lib\jss
e.jar;C:\JBuilder9\jdk1.4\jre\lib\rt.jar;C:\JBuilder9\jdk1.4\jre\lib\sunrsasig
n.jar;C:\JBuilder9\jdk1.4\lib\dt.jar;C:\JBuilder9\jdk1.4\lib\htmlconverter.jar
;C:\JBuilder9\jdk1.4\lib\tools.jar" Mysql.lianjie
加载成功.Wed Apr 11 21:59:54 CST 2007 TRACE: --> NonRegisteringDriver.java:25
9 com.mysql.jdbc.NonRegisteringDriver.connect("jdbc:mysql://localhost:3306/cix
u", {user=root, password=11251125})Wed Apr 11 21:59:54 CST 2007 TRACE: --> NonRegisteringDriver.java:436 com.my
sql.jdbc.NonRegisteringDriver.parseURL("jdbc:mysql://localhost:3306/cixu", {us
er=root, password=11251125})Wed Apr 11 21:59:54 CST 2007 TRACE: --> StringUtils.java:1110 com.mysql.jdb
c.StringUtils.startsWithIgnoreCase("jdbc:mysql://localhost:3306/cixu", "jdbc:m
ysql://")Wed Apr 11 21:59:54 CST 2007 TRACE: --> StringUtils.java:1094 com.mysql.jd
bc.StringUtils.startsWithIgnoreCase("jdbc:mysql://localhost:3306/cixu", 0, "jd
bc:mysql://")Wed Apr 11 21:59:54 CST 2007 TRACE: <-- StringUtils.java:1094 com.mysql.j
dbc.StringUtils.startsWithIgnoreCase(..) returning trueWed Apr 11 21:59:54 CST 2007 TRACE: <-- StringUtils.java:1110 com.mysql.jd
bc.StringUtils.startsWithIgnoreCase(..) returning trueWed Apr 11 21:59:54 CST 2007 TRACE: <-- NonRegisteringDriver.java:436 com.m
ysql.jdbc.NonRegisteringDriver.parseURL(..) returning {HOST=localhost:3306, us
er=root, password=11251125, DBNAME=cixu}Wed Apr 11 21:59:55 CST 2007 TRACE: --> NonRegisteringDriver.java:402 com.my
sql.jdbc.NonRegisteringDriver.host({HOST=localhost:3306, user=root, password=1
1251125, DBNAME=cixu})Wed Apr 11 21:59:55 CST 2007 TRACE: <-- NonRegisteringDriver.java:402 com.m
ysql.jdbc.NonRegisteringDriver.host(..) returning "localhost:3306"Wed Apr 11 21:59:55 CST 2007 TRACE: --> NonRegisteringDriver.java:626 com.my
sql.jdbc.NonRegisteringDriver.port({HOST=localhost:3306, user=root, password=1
1251125, DBNAME=cixu})Wed Apr 11 21:59:55 CST 2007 TRACE: <-- NonRegisteringDriver.java:626 com.m
ysql.jdbc.NonRegisteringDriver.port(..) returning 3306Wed Apr 11 21:59:55 CST 2007 TRACE: --> NonRegisteringDriver.java:292 com.my
sql.jdbc.NonRegisteringDriver.database({HOST=localhost:3306, user=root, passwo
rd=11251125, DBNAME=cixu})Wed Apr 11 21:59:55 CST 2007 TRACE: <-- NonRegisteringDriver.java:292 com.m
ysql.jdbc.NonRegisteringDriver.database(..) returning "cixu"Wed Apr 11 21:59:55 CST 2007 TRACE: --> ConnectionProperties.java:83 com.mys
ql.jdbc.ConnectionProperties$BooleanConnectionProperty.getValueAsBoolean()Wed Apr 11 21:59:55 CST 2007 TRACE: <-- ConnectionProperties.java:83 com.my
sql.jdbc.ConnectionProperties$BooleanConnectionProperty.getValueAsBoolean(..)
returning true。还有狠多~
省略~不懂什么问题~望高手指教~
import java.sql.*;public class lianjie {
public static void main(String[] args) {
String driver="org.gjt.mm.mysql.Driver";
String url="jdbc:mysql://localhost:3306/cixu";
String user="root";
String password="123456"; try
{
Class.forName(driver);
System.out.print("加载成功.");
}
catch(Exception E)
{
System.out.print("无法加载驱动程序:"+driver);
E.printStackTrace();
} try
{
Connection con=DriverManager.getConnection(url,user,password); Statement smt=con.createStatement();
System.out.print("连接成功");
String sql="update cixu set weizhi=0 where Function='Function1;'";
smt.executeQuery(sql);
con.close();
}
catch(Exception E)
{
E.printStackTrace();
}
}
}结果出现问题:
我用的是Jbuilder9,JDBC是 mysql-connector-java-3.1.14-bin.jar,
编译的时候就会弹出如下异常:C:\JBuilder9\jdk1.4\bin\javaw -classpath "E:\java\sql\sql\classes;C:\JBuilder9
\jdk1.4\demo\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\demo\plugin\jfc\Java
2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\jre\lib\charsets.jar;C:\JBuilder9\jdk1.4\
jre\lib\ext\dnsns.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\ldapsec.jar;C:\JBuilder9
\jdk1.4\jre\lib\ext\localedata.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\sunjce_prov
ider.jar;C:\JBuilder9\jdk1.4\jre\lib\im\indicim.jar;C:\JBuilder9\jdk1.4\jre\li
b\jaws.jar;C:\JBuilder9\jdk1.4\jre\lib\jce.jar;C:\JBuilder9\jdk1.4\jre\lib\jss
e.jar;C:\JBuilder9\jdk1.4\jre\lib\rt.jar;C:\JBuilder9\jdk1.4\jre\lib\sunrsasig
n.jar;C:\JBuilder9\jdk1.4\lib\dt.jar;C:\JBuilder9\jdk1.4\lib\htmlconverter.jar
;C:\JBuilder9\jdk1.4\lib\tools.jar" Mysql.lianjie
加载成功.Wed Apr 11 21:59:54 CST 2007 TRACE: --> NonRegisteringDriver.java:25
9 com.mysql.jdbc.NonRegisteringDriver.connect("jdbc:mysql://localhost:3306/cix
u", {user=root, password=11251125})Wed Apr 11 21:59:54 CST 2007 TRACE: --> NonRegisteringDriver.java:436 com.my
sql.jdbc.NonRegisteringDriver.parseURL("jdbc:mysql://localhost:3306/cixu", {us
er=root, password=11251125})Wed Apr 11 21:59:54 CST 2007 TRACE: --> StringUtils.java:1110 com.mysql.jdb
c.StringUtils.startsWithIgnoreCase("jdbc:mysql://localhost:3306/cixu", "jdbc:m
ysql://")Wed Apr 11 21:59:54 CST 2007 TRACE: --> StringUtils.java:1094 com.mysql.jd
bc.StringUtils.startsWithIgnoreCase("jdbc:mysql://localhost:3306/cixu", 0, "jd
bc:mysql://")Wed Apr 11 21:59:54 CST 2007 TRACE: <-- StringUtils.java:1094 com.mysql.j
dbc.StringUtils.startsWithIgnoreCase(..) returning trueWed Apr 11 21:59:54 CST 2007 TRACE: <-- StringUtils.java:1110 com.mysql.jd
bc.StringUtils.startsWithIgnoreCase(..) returning trueWed Apr 11 21:59:54 CST 2007 TRACE: <-- NonRegisteringDriver.java:436 com.m
ysql.jdbc.NonRegisteringDriver.parseURL(..) returning {HOST=localhost:3306, us
er=root, password=11251125, DBNAME=cixu}Wed Apr 11 21:59:55 CST 2007 TRACE: --> NonRegisteringDriver.java:402 com.my
sql.jdbc.NonRegisteringDriver.host({HOST=localhost:3306, user=root, password=1
1251125, DBNAME=cixu})Wed Apr 11 21:59:55 CST 2007 TRACE: <-- NonRegisteringDriver.java:402 com.m
ysql.jdbc.NonRegisteringDriver.host(..) returning "localhost:3306"Wed Apr 11 21:59:55 CST 2007 TRACE: --> NonRegisteringDriver.java:626 com.my
sql.jdbc.NonRegisteringDriver.port({HOST=localhost:3306, user=root, password=1
1251125, DBNAME=cixu})Wed Apr 11 21:59:55 CST 2007 TRACE: <-- NonRegisteringDriver.java:626 com.m
ysql.jdbc.NonRegisteringDriver.port(..) returning 3306Wed Apr 11 21:59:55 CST 2007 TRACE: --> NonRegisteringDriver.java:292 com.my
sql.jdbc.NonRegisteringDriver.database({HOST=localhost:3306, user=root, passwo
rd=11251125, DBNAME=cixu})Wed Apr 11 21:59:55 CST 2007 TRACE: <-- NonRegisteringDriver.java:292 com.m
ysql.jdbc.NonRegisteringDriver.database(..) returning "cixu"Wed Apr 11 21:59:55 CST 2007 TRACE: --> ConnectionProperties.java:83 com.mys
ql.jdbc.ConnectionProperties$BooleanConnectionProperty.getValueAsBoolean()Wed Apr 11 21:59:55 CST 2007 TRACE: <-- ConnectionProperties.java:83 com.my
sql.jdbc.ConnectionProperties$BooleanConnectionProperty.getValueAsBoolean(..)
returning true。还有狠多~
省略~不懂什么问题~望高手指教~
用JSP连接数据库成功,可以进行操作~
换到JBUILDER中连接数据库就失败了~问题出在Connection con=DriverManager.getConnection(url,user,password);一句
获取连接失败`
不知道为什么~
我的博客有详细的介绍,你去看看吧
http://blog.csdn.net/zsxy2007