During the orientation days, I took part in many activities such as BBQ, lecture for new students, outgoing… It’s really relax during this period, but I believe the terrible time will soon come to me. I have many many courses per week, just cuz my major is Computer Science. Don’t like those ppl studying business, I have less free time and stressful tasks to do. But I think it’s ok, so I enjoy the challenge things.

What do Microsoft and a halter top have in common?

Both offer very little support!

I m now staying at home and preparing things for leaving China. Time flies! The year 2007 has come, but I can’t forget 2006. Many things have happened to me in the past year, extremely in the end of 2006, my grandma left me and have gone far far away. Things always happen unconsciously and by tiny reasons. Wish I have a good start, and work well in the totally new environment~

根本原因：

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

解决办法：

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);

Since that I hvn’t enjoyed Anime with my friends for a long time, I downloaded two from VeryCd and ready to enjoy today~

概要

阅读“如何在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