sqlchoiceclasss.java

简单的学生管理系统,使用的是SQL2005数据库

package sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQLChoiceClasss {
	public boolean methodChoice(String id,String id1)
	{
		String classs = id1;
		boolean bool = false;
		try
		{
			try {
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=stu","sa","123");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from users where id='"+id+"'");
			if(rs.next())
			{
				String cla = rs.getString("classs");
				classs = classs+","+cla;
				System.out.println("$$$$$$$$$$$$$$$$$$$"+classs);
				bool = true;
			}
			PreparedStatement ps = con.prepareStatement("update users set classs=? where id='"+id+"'");
			ps.setString(1, classs);
			ps.executeUpdate();
			ps.close();
			rs.close();
		}
		catch(SQLException e)
		{
			e.printStackTrace();
			bool=false;
		}
		return bool;
	}
}