JAVA网数据库里面插入数据的时候报错，抛出异常

qq_36627026 2016-11-23 12:12:07

这是代码

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;



public class Test {



	public static final String DBDRIVER="org.gjt.mm.mysql.Driver";

	public static final String DBURL="jdbc:mysql://localhost:3306/company";

	public static final String DBUSER="root";

	public static final String DBPASS="mysql";

	public static void main(String args[]){

		Connection conn=null;

		Statement stmt=null;

		

		//加载驱动程序

		try {

			Class.forName(DBDRIVER);

			System.out.println("加载成功");

		} catch (ClassNotFoundException e) {

			// TODO Auto-generated catch block

			System.out.println("加载失败");

			e.printStackTrace();

		}



		//链接数据库

		try {

			conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);

			System.out.println("链接成功");

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			System.out.println("链接失败");

			e.printStackTrace();

		}





		//执行数据库插入操作

		String sql="insert into student(name,sex,studo,sge)"

		+"VALUES('小韦','男','2015350','30')";

		try {

			stmt=conn.createStatement();

			System.out.println("插入成功");

			stmt.executeUpdate(sql);

			System.out.println("更新成功");

		} catch (SQLException e1) {

			// TODO Auto-generated catch block

			e1.printStackTrace();

		}

		//关闭数据库操作，释放资源

		try {

			stmt.close();

			conn.close();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

这是错误信息

加载成功

链接成功

插入成功

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'sge' in 'field list'

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

	at java.lang.reflect.Constructor.newInstance(Unknown Source)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)

	at com.mysql.jdbc.Util.getInstance(Util.java:387)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)

	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)

	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)

	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

	at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1540)

	at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2595)

	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1468)

	at workspace.Test.main(Test.java:45)