public class Jdbc extends Applet {
Choice students;
Choice grades;
Connection connection;
Statement statement;
public Jdbc(){
students=new Choice();
grades=new Choice();
setLayout(new FlowLayout());
try
{
Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
connection=DriverManager.getConnection("jdbc:odbc:students");
statement=connection.createStatement();
String SQL="SELECT Name FROM Students";
ResultSet resultset=statement.executeQuery(SQL);
while(resultset.next())
students.addItem(resultset.getString(1));
SQL="SELECT Grade FROM Students";
resultset=statement.executeQuery(SQL);
while(resultset.next())
grades.addItem(resultset.getString(1));
}
catch(Exception e){}
add(students);
add(grades);
}
}
运行后,APPLET没有数据显示,我有ACCESS见了students表,ODBC里怎么设置
Choice students;
Choice grades;
Connection connection;
Statement statement;
public Jdbc(){
students=new Choice();
grades=new Choice();
setLayout(new FlowLayout());
try
{
Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
connection=DriverManager.getConnection("jdbc:odbc:students");
statement=connection.createStatement();
String SQL="SELECT Name FROM Students";
ResultSet resultset=statement.executeQuery(SQL);
while(resultset.next())
students.addItem(resultset.getString(1));
SQL="SELECT Grade FROM Students";
resultset=statement.executeQuery(SQL);
while(resultset.next())
grades.addItem(resultset.getString(1));
}
catch(Exception e){}
add(students);
add(grades);
}
}
运行后,APPLET没有数据显示,我有ACCESS见了students表,ODBC里怎么设置
("jdbc:odbc:students")然后选择SQL的服务器→在Login 和 Password中填入你登入服务器的用户名和密码 所以在
↓这后面以这种格式加上 用户名和密码 ("jdbc:odbc:students","L","P")如果没有密码P就不填
("jdbc:odbc:students")→再选择连接的默认数据库名→再下来的东东初级的不要去管它NEXT
→点击 Test Date Source 如果OK了就证明你的数据库已经建立起连接了 ↓这里是 JdbcOdbcDriver
("sun.jdbc.odbc.jdbcOdbcDriver")
方法一,加载驱动器类,用数据库的url取得连接,
方法二,从application server取得DataSource,然后从DataSource得到
2,用jdbc-odbc桥来取得连接
方法步骤同楼上
以上是常用的jdbc连接数据库的类型,还有两类,偶也不会 :(