yanz.java

这个是我们做土地局的一个项目。感觉不错。欢迎下载

package huayi.xt;

import java.sql.*;
import java.io.*;
import java.util.*;
import javax.naming.*;

/**
* 从连接池中取得一个空闲的数据库连接
* @return Connection
* @exception Exception
*/
public class YanZ{
String rwgl="",hygl="",gwgl="",eb="";
//数据处理
public YanZ(){}

public void getqx(String id){
	//连接数据库，
Connection conn = null; 
CallableStatement stmtpro = null;
Statement stmt=null;
ResultSet rs = null;
String ids="YG2004020300001";
try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://202.118.120.197:1433;databaseName=HuaYi;user=center;password=6651002");
   stmt=conn.createStatement();  
   PreparedStatement select=
  conn.prepareStatement("select * from  T_QXGLB ");
  // rs=stmt.executeQuery("select * from  T_QXGLB where YGBH='YG2004020300001'");
  //select.setString(1,ids);
  rs=select.executeQuery();
  while(rs.next()){
   	rwgl=rs.getString("FBTG");
   	hygl=rs.getString("GLTG");
   	gwgl=rs.getString("GLGW");
   	eb=rs.getString("GLTS");    
  }
} catch(Exception e) {System.out.println(e.getMessage());}
}
//数据处理

/*public boolean YanZrw()
{    boolean flag=true; 
     if (rwgl.equals("1")) return flag=true; else flag=false;
	return flag;
	}

public boolean YanZhy()
{       boolean flag=true; 
	if (hygl.equals("1")) return flag=true; else flag=false;
	return flag;
	}

public  boolean YanZgw()
{boolean flag=true; 
	if (gwgl.equals("1")) return flag=true; else flag=false;
	return flag;
	}

public  boolean YanZeb()
{       boolean flag=true; 
	if (eb.equals("1")) return flag=true; else flag=false;
	return flag;
	}
*/
}