java读取mysql内容_用JAVA从数据库中读出字段及内容

import java.sql.*;

ResultSet rs=null;

String classname="";

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=basename";

String user="sa";

String password="";

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from class";

rs=stmt.executeQuery(sql);

while(rs.next())

{

classname=rs.getString("classname");

classname = new String(classname.getBytes("ISO-8859-1"),"gb2312");

System.out.println(classname);

}

---------------------------------------------------------------