Last week, during the prac 2 of CS IB, we were asked to program in Java to build a simple client/server system in which the server takes “commands” from the client and executes them. Due to the time restriction, we were only asked to implement the server, and use telnet to act as client to transact with server. You can have a look here for details.

1
2
3
4
5

ServerSocket server = new ServerSocket(6666);
Socket s= server.accept();
// We now have a client on the end of the socket s
BufferedReader in = new BufferedReader( new InputStreamReader( s.getInputStream()));
PrintWriter out = new PrintWriter(s.getOutputStream());

It’s no more than the knowledge above. Maybe the simplest nextwork program in Java world.

The telnet on lab’s Mac just work well, but after I brought my program to home and run on my own computer, I met a really troublesome problem with the Microsoft’s telnet in Windows XP.

1. First, I started my server.

(more…)

Zend Debugger 5.2.5 and Zend Studio 5.5 are both newest products from Zend, the PHP company. Zend Debugger is a full-featured server side php debugger engine, an interactive tool that helps you debug PHP scripts. Zend Studio is a fantastic IDE for PHP programming(I am really happy with its code assistant). If they work together, we can use them to debug any PHP codes on a web server,  and have a good studying and development enviroment of PHP.

The installation of Zend Studio 5.5 is very easy. Just follow its setup sequence. However, the installation and configuration for Zend Debugger 5.2.5 is demanding. Fortunately, we have a really good tutorial here. Following its steps start from "Find the extension directory" and you will have this image from call phpinfo() method which indicate the successful of installation.

If you can’t get Zend Debugger to work although you have followed instruction of that tutorial. Please try following solution:

1. open your php.ini (you can find it by calling phpinfo() method and looking up the "Configuration File (php.ini) Path" entry (more…)

根本原因：

访问数据库的用户有登录权限，但无操作表的权限

解决办法：

1. 在[企业控制台]窗口–[树]子窗口–[安全性]子树–[登录]项里将你使用的登陆用户的默认数据库设为你所使用的数据库。
2. 在[企业控制台]窗口–[树]子窗口–[安全性]子树–[登录]项里新增一个登录用户（在其中选择SQL Server 身份验证、服务器角色和要访问的数据库），以后便可用些新增用户访问你勾选的数据库了。

大家在用java连接ms sql时可能会这样的问题
原因是sa用户为系统用户,它虽然能够登陆数据库，但是数据库里边的权限都是dbo的，所以，我们现在为这个数据库重新建立一个用户.
当然,这个情况只发生在java里边. .net是不会这样的.
只要新建立一个用户,再在权限那分配权限做好就行了.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

public Connection getConnectionDB()
{
	String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String ConnectionString = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test;";
	String userName = "username";
	String userPwd = "password";
 
	try {
		Class.forName(driverName);
		con = DriverManager.getConnection(ConnectionString, userName, userPwd);
		//System.out.println("Connection Successful!");
	} catch (Exception e) {
		e.printStackTrace();
	}
 
	return con;
}
 
	ConnectionDB prod=new ConnectionDB();
	Connection con=prod.getConnectionDB();
	CallableStatement callStmt =null;
	java.sql.Statement  stat  =  null;
	java.sql.ResultSet  rs  =  null;
 
	stat  =  con.createStatement();
	String  sql="select * from table";
	rs=stat.executeQuery(sql);

概要

阅读“如何在Access中重置“自动编号”字段值”

今天老师教我们如何使用Visual Studio中集成的Crystal Reports(水晶报表)来制做显示在WinForm中的报表。哈哈，Crystal Reports的强大功能真令人兴奋。简单的几个步骤就能作出非常漂亮的报表来。以下便是我第一次用Crystal Reports做的报表啦：

From Wikipedia, the free encyclopedia

Object-Relational mapping (aka O/RM, ORM, and O/R mapping), is a programming technique that links databases to object-oriented language concepts, creating (in effect) a "virtual object database." There are both free and commercial packages available that perform object-relational mapping, although some programmers opt to code their own object-relational mapping for their systems

其实我是不太喜欢微软的东西的，简单的说就是喜欢Java不喜欢.Net。但是学了C#之后，对微软的东西还是得说一个字”牛“。Visual Studio 2005给人得感觉很不错，但是总觉得是仿照eclipse做的，呵呵，傲慢与偏见。上面的游戏就是用vs 2k5做的，界面是用fireworks画的。还不错吧！点击这里在线运行试试。