android service计算,给计算器写的一个webservice

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

package com.lucher.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

import com.lucher.bean.User;

import com.lucher.util.DBUtil;

public class UserDao {

private static final String getAllUsers = "select * from cacl";

public List getAllUsers() {

// TODO Auto-generated method stub

List list = new ArrayList();

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

conn=DBUtil.getSQLSERVERConnection();

stmt = conn.createStatement();

rs = stmt.executeQuery(getAllUsers);

while (rs.next()) {

User user = new User();

user.setX(rs.getDouble("x"));

user.setY(rs.getDouble("y"));

list.add(user);

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

System.out.println("Ŀǰ��ݿ���û��У�");

for (int i = 0; i < list.size(); i++) {

System.out.println(list.get(i));

}

DBUtil.closeConn(rs,stmt, conn);

}

return list;

}

private static final String addUser = "insert into cacl (x,y) values(?,?)";

public boolean addUser(double x, double y) {

System.out.println(x+"-"+y);

int result = 0;

boolean flag = true;

Connection conn = null;

PreparedStatement pstmt = null;

try {

conn = DBUtil.getSQLSERVERConnection();

pstmt = conn.prepareStatement(addUser);

pstmt.setDouble(1, x);

pstmt.setDouble(2, y);

result = pstmt.executeUpdate();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

DBUtil.closeConn(pstmt, conn);

}

if (result == 0) {

flag = false;

System.out.println("�����û�"+y+"ʧ��");

} else {

System.out.println("�����û�"+y+"�ɹ�");

}

return flag;

}

}