import java.lang.Object;
import java.sql.*;public class sqlcon {
public void startsql() throws ClassNotFoundException, SQLException{
//
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/new_db","root","23755959");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select name from table1");
//获取字段
ResultSetMetaData Rm = rs.getMetaData();
int num = Rm.getColumnCount();
while(rs.next()){
//
for(int i = 0;i<num;i++){
String x = rs.getString(i+1);
System.out.print(x);}//end for
}//end while
} public static void main(String[] args) throws ClassNotFoundException, SQLException {
new sqlcon().startsql();
}
}//编译之后报错
Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at singleTest.sqlcon.startsql(sqlcon.java:21)
at singleTest.sqlcon.main(sqlcon.java:38)
//我在mysql网站下了个驱动mysql-connector-java-3.1.10.zip但是不知道怎么安装
//不知道怎么配置,放在哪里,怎么设置变量(请高手帮忙)
import java.sql.*;public class sqlcon {
public void startsql() throws ClassNotFoundException, SQLException{
//
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/new_db","root","23755959");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select name from table1");
//获取字段
ResultSetMetaData Rm = rs.getMetaData();
int num = Rm.getColumnCount();
while(rs.next()){
//
for(int i = 0;i<num;i++){
String x = rs.getString(i+1);
System.out.print(x);}//end for
}//end while
} public static void main(String[] args) throws ClassNotFoundException, SQLException {
new sqlcon().startsql();
}
}//编译之后报错
Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at singleTest.sqlcon.startsql(sqlcon.java:21)
at singleTest.sqlcon.main(sqlcon.java:38)
//我在mysql网站下了个驱动mysql-connector-java-3.1.10.zip但是不知道怎么安装
//不知道怎么配置,放在哪里,怎么设置变量(请高手帮忙)
doc文件夹 -- 里面有几个文档和jar文件
src文件夹 -- 和Java里面的src.zip文件格式一样,里面有很多jar
mysql-connector-java-3.1.10-bin.jar
mysql-connector-java-3.1.10-bin-g.jar
build.xml
还有一些零碎的文件
->请问我应该怎么配置这些文件,是直接拷贝mysql-connector-java-3.1.10.zip到“某”个文件夹下
还是解压缩“某”个文件到什么地方请高手告之如何处理这个驱动包
是服务器上的目录
加入你的jar