conn.creatStatement()

来源：百度知道 编辑：UC知道 时间：2024/06/28 01:38:58
import java.sql.*;

public class test{
public static void main(String args[])
{
ResultSet rs;
Connection conn;
Statement stmt;
String query="select * from table1";
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}

catch(java.lang.ClassNotFoundException e){System.out.println(e.getMessage());
}
try{conn=DriverManager.getConnection("jdbc:odbc:test","","");
stmt=conn.creatStatement();
rs=stmt.executeQuery(query);}
catch(SQLException ee){System.out.println("驱动地址不对");}

while(rs.next()){
int id=rs.getInt(1);
String name=rs.getString("name");
String remark=rs.getString("remark");
System.out.print(id);
System.out.println(" ");

System.out.print(name);
System.out.println(" ");
System.out.println(remark);
}

if(rs !=null)rs.close();
i

你少些了一个字母 应该为stmt = conn.createStatement();

还有一些异常没有捕获 给你改了下

修改如下

import java.sql.*;

public class test {
public static void main(String args[]) {
ResultSet rs = null;
Connection conn = null;
Statement stmt = null;
String query = "select * from table1";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}

catch (java.lang.ClassNotFoundException e) {
System.out.println(e.getMessage());
}
try {
conn = DriverManager.getConnection("jdbc:odbc:test", "", "");
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
while (rs.next()) {
int id = rs.getInt(1);
String name = rs.getString("name");
String remark = rs.getString("remark");
System.out.print(id);
System.out.println(" ");

Sys