sq1.java

查看效果之前。连接一下数据源。数据源名称为"miukou"。后效果会更佳。 解压密码www.21codes.com,一定升级到最新版[WinRAR3.5]才能正常解压

import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.io.*;
import java.awt.datatransfer.*;//用于打开文件和保存文件的一个类
import java.applet.Applet;
import java.sql.*;

public class sq1
{
	Connection con;//定义一个能连接数据库的变量
	Statement stmt; 
	ResultSet rs;
	sq1(int n,String s1,String s2,String s3,String s4,String s5,String s6,String s7)
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection("jdbc:odbc:miukou");
			stmt = con.createStatement();
			rs = stmt.executeQuery("SELECT * FROM miuko");
		}
		catch(Exception eeee){}
		try
		{
			String strDel = "DELETE * FROM miuko1 WHERE word =" + s1;
			stmt.executeUpdate(strDel);
			String strInc = "INSERT INTO miuko1(word,mean1,mean2,mean3,mean4,mean5) Values(" 
		 		+s7+","+s2+","+s3+","+s4+","+s5+","+s6+")";
			stmt.executeUpdate(strInc);
			miukoNO8.q8.setText("修改成功!!");
		}
		catch(Exception e8){miukoNO8.q8.setText("修改失败!!");}
	}
}