import java.sql.*;
public class c{
private String gvDriver = "";
private String gvUser = "sa"; // 数据库登录用户
private String gvPassword = ""; // 数据库登录密码
private Statement sta;
private static String message = "恭喜,数据库连接正常!";
public Connection getConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//gvDriver="jdbc:odbc:sqlserver://127.0.0.1:1433;DatabaseName=myMovie";
gvDriver = "jdbc:odbc:myMovie";
return DriverManager.getConnection(gvDriver, gvUser, gvPassword);
}catch(Exception e){
message = e.toString();
}
return null;
}
public static void main(String args[]){
c cc = new c();
Connection con = cc.getConnection();
try{
Statement s = con.createStatement();
ResultSet r = s.executeQuery("SELECT 影片名称,影片类型,影片介质"+"FROM movie");
while(r.next()){
System.out.println("1");
System.out.println(r.getString("影片名称"));
}
s.close();
}catch(SQLException e){ System.out.println("2"); }
}
}
影片名称和影片类型分别是text类型,影片介质为char类型,为什么程序会抛出SQLException异常!?谢谢!!
public class c{
private String gvDriver = "";
private String gvUser = "sa"; // 数据库登录用户
private String gvPassword = ""; // 数据库登录密码
private Statement sta;
private static String message = "恭喜,数据库连接正常!";
public Connection getConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//gvDriver="jdbc:odbc:sqlserver://127.0.0.1:1433;DatabaseName=myMovie";
gvDriver = "jdbc:odbc:myMovie";
return DriverManager.getConnection(gvDriver, gvUser, gvPassword);
}catch(Exception e){
message = e.toString();
}
return null;
}
public static void main(String args[]){
c cc = new c();
Connection con = cc.getConnection();
try{
Statement s = con.createStatement();
ResultSet r = s.executeQuery("SELECT 影片名称,影片类型,影片介质"+"FROM movie");
while(r.next()){
System.out.println("1");
System.out.println(r.getString("影片名称"));
}
s.close();
}catch(SQLException e){ System.out.println("2"); }
}
}
影片名称和影片类型分别是text类型,影片介质为char类型,为什么程序会抛出SQLException异常!?谢谢!!
如果你的SQL语句中有变量,那你应该用+号把它连起来,你的SQL语句写错了。