package?view;
import?java.sql.*;
public?class?DBConnection?{
????String?driverName?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
????Connection?con?=?null;
????Statement?st?=?null;
????PreparedStatement?prepare?=?null;
????ResultSet?rs?=?null;
????public?DBConnection（）?{
????????try{
????????????Class.forName（driverName）;
????????????con?=?DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;DatabaseName=Student““sa““111“?）;
????????????st?=??con.createStatement（）;
????????}catch（Exception?e）{
????????????e.printStackTrace（）;
????????}
????}

????public?ResultSet?query（String?sql）{
????????try{
????????????rs?=?st.executeQuery（sql）;
????????????return?rs;
????????}
????????catch（Exception?e）{
????????????e.printStackTrace（）;
????????????return?null;
????????}
????????
????}
????public?int?anyOperate（String??sqlStr）??
	???{
	??????try
	??????{??
	?????????st=con.createStatement（）;??????
	?????????st.execute（sqlStr?）;????????????
	??????????return?1;????
	??????}?
	??????catch（Exception?err1）
	??????{
	?????????System.out.println（““+err1）;
	?????????return?0;
	??????}
	???}
	public?int?update（String?Insertsql?String[]?values）?{
		try	{
			prepare?=?con.prepareStatement（Insertsql）;
			for?（?int?i?=?0;i				prepare.setString（i+1?values[i]）;
			}
			prepare.execute（）;
			return?1;
		}
		catch（SQLException?e）?{
			e.printStackTrace（）;
			return?-1;
		}
	}
	public?int?delete（String?tabName?String?cond）?{
		try?{
			String?sql?=?“delete?from?“+tabName+“?where?sno?=?‘“?+cond+?“‘“;
			System.out.println（sql）;
			st.executeUpdate（sql）;
			return?1;
		}
		catch（SQLException?e）?{
			e.printStackTrace（）;
			return?0?;
		}
	}
	public?void?close（）{
????????try{
????????	if（?rs?!=?null）?{
????????		rs.close（）;
????????	}
????????	if（prepare?!=?null）?{
????????		prepare.close（）;
????????	}
????????	if（st?!=?null）?{
????????		st.close（）;
????????	}
????????	if（con?!=?null）?{
????????		con.close（）;
????????	}
????????}catch（Exception?e）{
????????????e.printStackTrace（）;
????????}
????}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-06-19?11:08??毛朋藝JAVA\
?????目錄???????????0??2014-06-19?11:08??毛朋藝JAVA\lidan\
?????文件?????????534??2010-09-21?15:25??毛朋藝JAVA\lidan\.classpath
?????目錄???????????0??2014-06-19?11:08??毛朋藝JAVA\lidan\.myeclipse\
?????目錄???????????0??2014-06-19?11:08??毛朋藝JAVA\lidan\.myeclipse\profiler\
?????文件?????????772??2014-06-15?14:18??毛朋藝JAVA\lidan\.myeclipse\profiler\Insert.xml
?????文件?????????381??2010-09-14?10:14??毛朋藝JAVA\lidan\.project
?????目錄???????????0??2014-06-19?11:08??毛朋藝JAVA\lidan\images\
?????文件???????10752??2011-05-24?22:16??毛朋藝JAVA\lidan\images\Thumbs.db
?????文件???????39775??2010-09-24?10:21??毛朋藝JAVA\lidan\images\login.jpg
?????文件???????46045??2010-09-24?10:17??毛朋藝JAVA\lidan\images\welcome.jpg
?????文件???????44250??2010-09-24?10:17??毛朋藝JAVA\lidan\images\welcome2.jpg
?????目錄???????????0??2014-06-19?11:08??毛朋藝JAVA\lidan\view\
?????文件????????3228??2010-10-02?16:55??毛朋藝JAVA\lidan\view\DBConnection.class
?????文件????????2132??2010-10-02?16:55??毛朋藝JAVA\lidan\view\DBConnection.java
?????文件????????3523??2010-09-24?10:07??毛朋藝JAVA\lidan\view\Insert$ButtonListener.class
?????文件????????3671??2010-09-24?10:07??毛朋藝JAVA\lidan\view\Insert.class
?????文件????????4907??2010-09-24?10:07??毛朋藝JAVA\lidan\view\Insert.java
?????文件?????????652??2010-09-24?15:35??毛朋藝JAVA\lidan\view\Insert2$1.class
?????文件????????5534??2010-09-24?15:35??毛朋藝JAVA\lidan\view\Insert2$ButtonListener.class
?????文件????????4176??2010-09-24?15:35??毛朋藝JAVA\lidan\view\Insert2.class
?????文件???????10402??2010-09-24?15:35??毛朋藝JAVA\lidan\view\Insert2.java
?????文件????????1018??2010-09-24?10:51??毛朋藝JAVA\lidan\view\LoginDialog$1.class
?????文件?????????652??2010-09-24?10:51??毛朋藝JAVA\lidan\view\LoginDialog$2.class
?????文件????????3872??2010-09-24?10:51??毛朋藝JAVA\lidan\view\LoginDialog$ButtonListener.class
?????文件????????3156??2010-09-24?10:51??毛朋藝JAVA\lidan\view\LoginDialog.class
?????文件????????6686??2010-09-24?10:51??毛朋藝JAVA\lidan\view\LoginDialog.java
?????文件?????????996??2010-09-24?10:12??毛朋藝JAVA\lidan\view\Welcome$1.class
?????文件?????????628??2010-09-24?10:12??毛朋藝JAVA\lidan\view\Welcome$2.class
?????文件????????1040??2010-09-24?10:12??毛朋藝JAVA\lidan\view\Welcome$ButtonListener.class
?????文件????????2256??2010-09-24?10:12??毛朋藝JAVA\lidan\view\Welcome.class
............此處省略11個文件信息