import java.sql.*;public class class1
{
public static void main (String[] args)
{
// TODO: Add initialization code here
try
{
String driver="com.ms.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:mzer";
DriverManager.registerDriver(new com.ms.jdbc.odbc.JdbcOdbcDriver());
Connection conn=DriverManager.getConnection(url,"dbo","");
Statement state=conn.createStatement();
String sql="select * from test";
ResultSet rs=state.executeQuery(sql);
while(rs.next())
{
String name=rs.getString("name");
int password=rs.getInt("password");
System.out.println("your name:"+name);
System.out.println("your password:"+password);
}
}
catch(SQLException e)
{
System.out.println("error");
}
}
}
{
public static void main (String[] args)
{
// TODO: Add initialization code here
try
{
String driver="com.ms.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:mzer";
DriverManager.registerDriver(new com.ms.jdbc.odbc.JdbcOdbcDriver());
Connection conn=DriverManager.getConnection(url,"dbo","");
Statement state=conn.createStatement();
String sql="select * from test";
ResultSet rs=state.executeQuery(sql);
while(rs.next())
{
String name=rs.getString("name");
int password=rs.getInt("password");
System.out.println("your name:"+name);
System.out.println("your password:"+password);
}
}
catch(SQLException e)
{
System.out.println("error");
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货