具体代码:
这个就是简单的数据库查询
Class.forName("sun .jdbc.odbc.JdbcOdbcDriver"); //加载数据驱动
Connection con=DriverManager.getConnection("jdbc:odbc:myDB","li","1234"); //连接数据库
Statement stmt=con.createStatement(); //获得查询对象
ResultSet rs=stmt.executeQuery("select * from student"); //执行查询语句并返回结果集
while(rs.next())
{
System.out.println(
"姓名"+rs.getString("name")+"\t"+
"性别"+rs.getString("sex")+"\t"+
"学号"+rs.getString("num")+"\t"+
"专业"+rs.getString("zy")+"\t"+
"年龄"+rs.getFloat("nl"));
}
上面的代码,是一个while循环,从结果集里面取出来对象的信息
con.close();
rs.close();
stmt.close();
上面的代码是关闭操作,不对顺序错了,应该这样
rs.close();
stmt.close();
con.close();
package ff;
import java.sql.*;
public class Xw {
public static void main(String[] args)
{
try
{
Class.forName("sun .jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
System.out.println("SQLException:"+ce.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:myDB","li","1234");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from student");
while(rs.next())
{
System.out.println(
"姓名"+rs.getString("name")+"\t"+
"性别"+rs.getString("sex")+"\t"+
"学号"+rs.getString("num")+"\t"+
"专业"+rs.getString("zy")+"\t"+
"年龄"+rs.getFloat("nl"));
}
con.close();
rs.close();
stmt.close();
}
catch(SQLException e)
{System.out.println("SQLExcerption:"+e.getMessage());
}
}
}
这个就是简单的数据库查询
Class.forName("sun .jdbc.odbc.JdbcOdbcDriver"); //加载数据驱动
Connection con=DriverManager.getConnection("jdbc:odbc:myDB","li","1234"); //连接数据库
Statement stmt=con.createStatement(); //获得查询对象
ResultSet rs=stmt.executeQuery("select * from student"); //执行查询语句并返回结果集
while(rs.next())
{
System.out.println(
"姓名"+rs.getString("name")+"\t"+
"性别"+rs.getString("sex")+"\t"+
"学号"+rs.getString("num")+"\t"+
"专业"+rs.getString("zy")+"\t"+
"年龄"+rs.getFloat("nl"));
}
上面的代码,是一个while循环,从结果集里面取出来对象的信息
con.close();
rs.close();
stmt.close();
上面的代码是关闭操作,不对顺序错了,应该这样
rs.close();
stmt.close();
con.close();