jdbcinsertmulti.java

和数据库的连接工作

import java.sql.*;

public class JDBCInsertMulti
{
	public static void main(String[] args)
	{
		double ns;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException ce)
		{
			System.out.println(ce.getMessage());
			ce.printStackTrace();
		}
		try
		{
			
			Connection con=DriverManager.getConnection("jdbc:odbc:ISSWhuan");
			String sqlquery="INSERT INTO Student VALUES(?,?,?,?)";
			PreparedStatement pst=con.prepareStatement(sqlquery);
			pst.clearParameters();
			pst.setString(1,"101");
			pst.setString(2,"CAMLIN");
			pst.setString(3,"DIRECTOR");
			ns=8000*(1+0.1+0.35-0.12);
			pst.setString(4,""+ns);
			int flag=pst.executeUpdate();
			pst.clearParameters();
			pst.setString(1,"102");
			pst.setString(2,"TALLY");
			pst.setString(3,"CONSULTANT");
			ns=6000*(1+0.1+0.35-0.12);
			pst.setString(4,""+ns);
			flag+=pst.executeUpdate();
			System.out.println(flag+"rows inserted");
			pst.close();
			con.close();
		}
		catch(SQLException se)
		{
			System.out.println(se.getMessage());
			se.printStackTrace();
		}
	}
}