example2.java

来自「Java面向对象编程(随书配套源代码) 阐述了面向对象编程的思想」· Java 代码 · 共 42 行

package chapter17;

import java.sql.*;

public class example2
{
	public static void main(String args[ ])	
	{
		String strUpdate="INSERT INTO StudentInfo(cStudentID,vName,cSex) VALUES(?,?,?)";
		Connection conn;
		PreparedStatement stat;
		int rows;
		String strSID="06120403";
		String strName="任英英";
		String strSex="女";
		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:Student","sa","");
			stat=conn.prepareStatement(strUpdate);
			stat.setString(1,strSID);
			stat.setString(2,strName);
			stat.setString(3,strSex);			
			rows=stat.executeUpdate();
			if(rows<1)
			{				
				System.out.println("插入记录失败!");
			}
			else
			{
				System.out.println("插入记录成功!");
			}
			conn.close();
		}
		catch(Exception err)
		{
			err.printStackTrace();
		}
	}
}