XytServer1601/src/com/util/ValueBean.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.util;

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

public class ValueBean {
	
	public static String getTeaNameById(int  id){
		DBUtil util= new DBUtil();
		Connection conn = util.openConnection();
		ResultSet rs = null;
		String sql="select realname from tea where id ="+id;
		String result="";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			rs.next();
			result=rs.getString("realname");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
	
	public static String getKsNameById(int  id){
		DBUtil util= new DBUtil();
		Connection conn = util.openConnection();
		ResultSet rs = null;
		String sql="select names from ks where id ="+id;
		String result="";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			rs.next();
			result=rs.getString("names");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
	public static String getAihaoBySid(String  id){
		DBUtil util= new DBUtil();
		Connection conn = util.openConnection();
		ResultSet rs = null;
		String sql="select aihao from stu where id ="+id;
		String result="";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			rs.next();
			result=rs.getString("aihao");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
	public static String getGoodsBySid(String  id){
		DBUtil util= new DBUtil();