import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
public class DB4 {
public static void main (String args[])
{
Connection conn;
Statement stat;
ResultSet rs;
try{
Class.forName("sun.mysql.jdbc.odbc.JdbcOdbcDriver");
conn= DriverManager.getConnection("jdbc:odbc:student","root","");
stat=conn.createStatement();
String sql="select * from students";
rs=stat.executeQuery(sql);
while(rs.next())
{
System.out.println("第一个字段内容为"+rs.getString(1));
System.out.println("第二个字段内容为"+rs.getString(2));
System.out.println("第三个字段内容为"+rs.getInt(3));
System.out.println("第四个字段内容为"+rs.getInt(4));
System.out.println("第五个字段内容为"+rs.getInt(5));
}
rs.close();
stat.close();
conn.close();
}catch(Exception e){System.out.println(e.getMessage());}
}
}
用java DB4运行会出现:sun.mysql.jdbc.odbc.JdbcOdbcDriver
这个结果,是怎么回事?
注:我在Mysql里已建好了数据库studnet 和它的表,是不是还要在控制面板中设置?怎么连啊?
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
public class DB4 {
public static void main (String args[])
{
Connection conn;
Statement stat;
ResultSet rs;
try{
Class.forName("sun.mysql.jdbc.odbc.JdbcOdbcDriver");
conn= DriverManager.getConnection("jdbc:odbc:student","root","");
stat=conn.createStatement();
String sql="select * from students";
rs=stat.executeQuery(sql);
while(rs.next())
{
System.out.println("第一个字段内容为"+rs.getString(1));
System.out.println("第二个字段内容为"+rs.getString(2));
System.out.println("第三个字段内容为"+rs.getInt(3));
System.out.println("第四个字段内容为"+rs.getInt(4));
System.out.println("第五个字段内容为"+rs.getInt(5));
}
rs.close();
stat.close();
conn.close();
}catch(Exception e){System.out.println(e.getMessage());}
}
}
用java DB4运行会出现:sun.mysql.jdbc.odbc.JdbcOdbcDriver
这个结果,是怎么回事?
注:我在Mysql里已建好了数据库studnet 和它的表,是不是还要在控制面板中设置?怎么连啊?
http://zhidao.baidu.com/question/30272867.html