小弟初学JAVA,想连接数据库把数据库中的数据读出来,我用的是ACCESS数据库,可是出现了问题,编译没有问题,请问这个问题产生的原因是什么???
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Date;
import java.sql.Connection;
class abc
{
public static void main(String[] args)
{
String ul="jdbc:odbc:abc";
String username="";
String password="";
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(ul,username,password);
Statement st=con.createStatement();
String sql="selcet * from student";
ResultSet rs=st.executeQuery(sql);
}
}
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Date;
import java.sql.Connection;
class abc
{
public static void main(String[] args)
{
String ul="jdbc:odbc:abc";
String username="";
String password="";
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(ul,username,password);
Statement st=con.createStatement();
String sql="selcet * from student";
ResultSet rs=st.executeQuery(sql);
}
}
{String ul="jdbc:odbc:abc";
String username="";
String password="";
Connection con;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(ul,username,password);
Statement st=con.createStatement();
String sql="selcet * from student";
ResultSet rs=st.executeQuery(sql);// do something with rs here}
catch(Exception ex)
{
ex.printStackTrace();
}
}
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Date;
import java.sql.Connection;
class abc
{
public static void main(String[] args)
{
try
{
String ul="jdbc:odbc:abc";
String username="";
String password="";
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(ul,username,password);
Statement st=con.createStatement();
//String sql="selcet * from student";
String sql="insert into student values('040351000','中国','女','24','会计学')";
st.executeUpdate(sql);
}
catch(SQLException e)
{
}
catch(ClassNotFoundException e)
{
}
}
}