这个怎么插入不到数据库里面呢!!!
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)
{
}
}
}
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)
{
}
}
}
这样就可以了,如果24是INT型的就把两边的'去掉。